Purchase Solution

Access - a few corrections to be made

Not what you're looking for?

Ask Custom Question

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.

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.

Purchase this Solution

Solution Summary

The expert examines a code access for a few corrections to be made.

Purchase this Solution

Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

C# variables and classes

This quiz contains questions about C# classes and variables.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.