Query
In the qry#2TerritoriesAndProducts query:
sort by product description, then by customer name, in ascending order.
In qry#6ConcatenatedNames:
sort by Territory Name, Sales Rep Last Name, First Name, Customer Name,
Contact Last Name, First Name
(Make sure a comma and a space separate the last and first names in each
set of concatenated names.)
Display Rep and Contact as the headings in the two columns of
concatenated field data.
In qry#7ProductAndDateParameter:
Sort by Customer ID, Customer Name, Product Description, Quantity
Ordered, Date of Order
My explanation isn’t visible in the Database window. Please change
the view of the window.
Form
Both form #1 and form #2 need to have the Navigation Bar displayed at
the bottom of the window, so I can move from record to record.
In form #2:
The New England Zip codes are missing their lead zeros in the subform.
This is something that occurred in the tables, and must be fixed.
Item 1 bullet 7: All of the territory names aren’t fully displayed.
the sales rep names aren’t fully displayed, some being truncated.
Computer Science Homework Solutions
#23119
Access - a few corrections to be made
Query
In the qry#2TerritoriesAndProducts query:
- sort by product description, then by customer name, in ascending order.
In qry#6ConcatenatedNames:
• sort by Territory Name, Sales Rep Last Name, First Name, Customer Name, Contact Last Name, First Name
(Make sure a comma and a space separate the last and first names in each set of concatenated names.)
• Display Rep and Contact as the headings in the two columns of concatenated field data.
In qry#7ProductAndDateParameter:
• Sort by Customer ID, Customer Name, Product Description, Quantity Ordered, Date of Order
• My explanation isn't visible in the Database window. Please change the view of the window.
Form
1. Both form #1 and form #2 need to have the Navigation Bar displayed at the bottom of the window, so I can move from record to record.
2. In form #2:
• The New England Zip codes are missing their lead zeros in the subform. This is something that occurred in the tables, and must be fixed.
• Item 1 bullet 7: All of the territory names aren't fully displayed.
• the sales rep names aren't fully displayed, some being truncated.
(See question also in attachment)
Thank you.
What is this?
By OTA - Overall OTA Rating
Shawn Laliberte - 4.8/5
Purchase Cost Now
$2.19 CAD (was ~$3.99)
Included in Download
- Plain text response
- Attached file(s):
- 23119sol.zip
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Query Question - Hi, I like to make changes to the attached database based on the question (queryquestion.doc). Since I can not attach the access file, please change the name database.xls to databse.mdb when op ...
- Query - I need to make changes to the database based on the query question in Word. Since I can not attach Access, please change the file extension to database.mdb when open database.exl. Thank you!
- Write a Bash script to concatenate the argument lists and output the resulting list. - Write a Bash script to concatenate the argument lists and output the resulting list. Final list should not include any argument that is a sub-list of the entire list. The script should not leave any r ...
- Auto form - Please refer to access_11 questions and make changes on database. (please change the file extension to access) The following is also in the attachment 1. Create an AutoForm based on t ...
- Programming Concept - Please describe this program for me. (See attached files for full problem description)
