Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: CREATING A FORM, QUERIES, AND A REPORT
ASSIGNMENT 2: CREATING A FORM, QUERIES, AND A REPORT
Assignment 2A: Creating a Form
Create a form for easy recording of new customers and their orders. The main form should be based on the
Customers table, and the subform should be inserted with the fields from the Orders table. Save the form as
Customers. View one record and, if required by your instructor, print the record. Your output should
resemble that in Figure 1-4.
FIGURE 1-4
The Customers form with subform
Assignment 2B: Creating a Parameter Query
Create a parameter query that prompts for a zip code and subsequently lists columns for the Last Name, First
Name, Address, Zip Code, and Box Type of all customers in the respective zip code. Save your query as Delivery
by Zip Code. Your output should resemble Figure 1-5 when you enter the zip code 30600 at the prompt.
FIGURE 1-5
Delivery by Zip Code query
Run the query. Print the results if required.
 
Search JabSto ::




Custom Search