6.46 Tech Tool: Database Software Software Videos: Database Queries, Calculated Fields 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 invoice form with invoice line fields as well as line total amount. Your form should display the total amount of that sales order at the bottom of the form.

Invoice Sales Order SalesOrderNe 43860 OrderDate: 8/1/2012 CustomerNo 1 ProductID OrderQty. UnitPrice Line Total 761 20 $419.46 $8,389 770 1 $419.46 $419. 758 2 $874.79 $1,749. 765 2 $419.46 $838, 732 1 $356.90 $356, 762 1 $419.46 $419. 738 1 $178.58 $178. " First Invoice Next Invoice Invoice Subtotal 18543.6544