Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS
Deliveries by Type and Shape query
Create a query called Withdrawals by Type and Shape. Display headings for the Customer ID, Number
Withdrawn, 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-8 if you entered Gold and Bullion at the prompts.
Withdrawals by Type and Shape query
Create a query called November Hours that summarizes the shifts worked by guards during November.
Display headings for the Employee Last Name, Employee First Name, Date, Number of Hours (a calculated
field), and Employee ID. Your data will differ, but your output should resemble that in Figure 5-9. Note that
only a portion of the output is showing in the figure.