6.45 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.

List of its sold with tots! Sales ProductID -Orders- UnitPrice 761 20 $419.46 Line Total $8,388.18 770 1 5419.46 $419.46 758 2 5874.79 $1,749.59 755 2 $419.46 $838.92 732 1 5356.90 $356.90 762 I 5419.46 $419.46 738 1 $178.58 $178.58 768 1 $419.46 $419.46 753 2 $2.146.96 $4,293.92 729 1 $183.94 $183.94 753 I $419.46 $419.46 756 1 5874.79 $874.79 756 1 5874.79 5874.79 761 3 5419.40 $1,258.20 758 2 $874.79 $1,749.58 Total Sale $22,426.22