Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS
FIGURE 5-2
Deliveries form
Form 2
Create a form based on your table that records withdrawal data. Use all the fields in your table to create the
form. Name the form Withdrawals. Your data will vary, but the output should resemble that in Figure 5-3.
FIGURE 5-3
Withdrawals form
Query 1
Create a query called Guard on New Year
s Day. Display headings for the Employee Last Name, Employee First
Name, and Date to summarize which guards worked on New Year
s Day. (If necessary, you can specify a
different day depending on your data.) Your data will differ, but your output should resemble that in Figure 5-4.
FIGURE 5-4
Guard on New Year s Day query
 
Search JabSto ::




Custom Search