Tech Tool:Database SoftwareSoftware Videos:Database Queries, Calculated FieldsSome databas...

Tech Tool:Database Software

Software Videos:Database Queries, Calculated Fields

Some database designers prefer to not include the calculated fields in the database tables. These fields’ values are calculated when they are needed for displaying in forms or reports. The data file for this exercise includes a sales order line with product id, quantity sold, and the unit price.

1. Download the data file for this exercise.

---

2. Create a query to calculate the total dollar amount for each sales order line.

---

3. Use Microsoft Access database software and the following sample to build a form to display each sales order line fields as well as line total amount. Your form should display the total amount of sales at the bottom of the form.