PR $6-8$ and $6-9($LO $6-2)$ Use the Access$\_$Practice.accdb database to complete the following tasks in Access.

Skip to question

$[$The following information applies to the questions displayed below.$]$

Use the Access$\_$Practice.accdb database to complete the following tasks in Access.

Note: Microsoft Access is required for this problem.

PR $6-8($LO $6-2)$ Parts d$,$ e$,$ and g$.$

The database contains three tables containing information about this company$$s sales process: Inventory, Sales, and SalesItems. Use the Relationships window to link the tables together.

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 $($call it Amt$)$ for each item $($Quantity $*$ UnitPrice$).$ Include InvoiceID, InventoryID, Quantity, and UnitPrice in the query. Name the query Item$\_$Extension$\_$Calculation.

Calculate the total dollar amount of each sale. Include InvoiceID, InvoiceDate, CustomerID, and EmployeeID from the Sales table and the Amt from the Item$\_$Extension$\_$Calculation query. Name the query Sale$\_$Amount$\_$Calculation.

Calculate total sales for each inventory item.

Calculate total sales.

Calculate the month in which each sale occurred. Include InvoiceID and InvoiceDate from the Sales table. Name the query Sales$\_$Months. $($Hint: Look for the Month function in the expression builder.$)$

Calculate the sum of sales for each month.