Required information

Problem $4-8$ and Problem $4-9[$LO $4-2]$

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. Microsoft Access is required for this problem.

$$

$$

Use the database to complete tasks a through g in Access. Answer the questions below after completing tasks d$,$ e$,$ and g$,$ respectively.

Problem $4-8[$LO $4-2]$

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.

$$

Required:

d$.$ What are the values for sales that were calculated for the following inventory items?

e$.$ What is the value of total sales from the query?

g$.$ Which month had the highest sum of sales? What specifically was the sales amount?