• What is a calculated field?

• Describe a summary option.

• Using the Restored Product Sales database, create the following:

1. A query that includes the order date, description, quantity, and price for the February Orders table; sort the query (if necessary) in ascending order by order date.
2. Create a calculated field in this new query called "Total Revenue"; formula = quantity*price.
3. Create a grouped report based on the above query that has the following properties:

• all fields are selected
• grouping is done by order date
• a summary value for the total revenue is generated

• Save the report as "report for lesson 17."
• Print page 1 of the report.