Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS
Query 2
Create a query called Popular Deliveries that displays headings for the Metal Type, Shape, and
Number Delivered. Be sure to sort your output. Your data will differ, but your output should resemble
that in Figure 5-5. Note the column heading change from the default setting provided by the query
generator.
FIGURE 5-5
Popular Deliveries query
Query 3
Create a query called Popular Withdrawals that displays headings for the Metal Type, Shape, and
Number Withdrawn. Be sure to sort your output. Your data will differ, but your output should resemble
that in Figure 5-6. Note the column heading change from the default setting provided by the query
generator.
FIGURE 5-6
Popular Withdrawals query
Query 4
Create a query called Deliveries by Type and Shape. Display headings for the Customer ID, Number Delivered,
Metal Type, and Shape. This query should prompt for two inputs: Metal Type and Shape. Your
data will differ, but your output should resemble that in Figure 5-7 if you entered Gold and Bullion at the
prompts.
 
Search JabSto ::




Custom Search