Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: CREATING A FORM, QUERIES, AND A REPORT
Assignment 2C: Creating a Totals Query
Create a query that adds up the number of boxes on order for the month of July. Your output should show
the box type, description, monthly price, and number of orders for July. (Note that the Number of Orders
heading is a column heading change from the default setting provided by the query generator.) Save your
query as July Order Summary. Your output should resemble that shown in Figure 1-6. Print the output if
July Order Summary query
Assignment 2D: Creating a Query with a Calculated Field
Create a query that calculates the new price of a
box, which is 20 percent higher than the current price.
Include columns that list the Last Name, First Name, and Email Address of all
box recipients, along with
the new price. Save the query as Price Increase Notification. Your output should resemble that shown in
Figure 1-7. Print the output if desired.
Price Increase Notification query
Assignment 2E: Generating a Report
Generate a report based on a query. The query should display the last name, first name, and address of all
customers who receive veggie boxes in April, along with the monthly price and start date. Save the query as
April Bills. From that query, create a report with a grand total of all monthly payments at the bottom. Make
sure that all fields and data are visible, and title the report April Bills. Your report output should resemble
that in Figure 1-8.
April Bills report