Tech Tool:Database SoftwareSoftware Videos:Database Queries, Calculated Fields1. Download...

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.