1. (1 point) The database contains five tables containing information about this companys sales process: Customers, Employees, Inventory, Sales, and SalesItems. Use the Relationships window to link the tables together, and enforce referential integrity.

2. (3 points) The SalesItems table records the quantity and price of each item sold on each sale (sales may include more than one item). Calculate the extended amount of sale (=Quantity * UnitPrice) (call it Amt). Also include InvoiceID, InventoryID, Quantity, and UnitPrice in the query. Name the query Item_Extension_Calculation.

3. (3 points) Calculate the total dollar amount of each sale (call it TotalAmtEachSales). Also, include InvoiceID, InvoiceDate, CustomerID, and EmployeeID. Name the query Sale_Amount_Calculation.

4. (3 points) Calculate total sales for each inventory item (call it TotalSalesEachInventory). Also, include InventoryID and InventoryName in the query. Name the query Sales_for_Inventory_Items.

5. (3 points) Calculate total sales (call it TotalSales). Name the query Total_Sales.

6. (3 points) Calculate the month in which each sale occurred (call it SalesMonth). For example, if an InvoiceDate is 10/1/2014, the SalesMonth should be either 10 or October. Also, include InvoiceID and InvoiceDate in the query. Name the query Sales_Months. (Hint: Look for the Month function in the expression builder.)

7. (3 points) Calculate the sum of sales for each month (call it TotalSalesEachMonth). Also, include SalesMonth in the query. Name the query Sales_by_Month.

8. (3 points) Calculate the total sales for each customer (call it TotalSalesEachCustomer). Also, include CustomerID and CompanyName in the query. Name the query Total_Customer_Sales.