Required Information Problem 4-8 and Problem 4-9 [LO 4-2] [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) a. The database contains three tables containing Information about this company's sales process: Inventory. Soles, and Salesitems Use the Relationships window to link the tables together. b. 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 Invoice, InventoryID. Quantity, and UnitPrice in the query. Name the query Item_Extension Calculation c Calculate the total dollar amount of each sale. Include InvoiceID. InvoiceDate, Customer and Employee from the Sales table and the Amt from the Item.Extension_Calculation query Name the query Sale_Amount_Calculation d. Calculate total sales for each Inventory Item e. Calculate total sales 1. Calculate the month in which each sale occurred. Include Invoice and Invoice Date from the Sales table Name the query Sales_Months. (Hint Look for the Month function in the expression builder) 9. 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? Complete this question by entering your answers in the tabs below. Required D Required E Required G g. Which month had the highest sum of sales? What specifically was the sales amount? (Input your answers exactly thay appear in Access with 2 decimal when required.) had the highest sum of sales which was a. Go to the Relationships screen and connect the five tables, enforcing referential Integrity b. Calculate the total sales for each customer. Include Customers and Company Name from the Customer table and the calculated sale amount from the Sale_Amount Calculation query. Name the query Total Customer_Sales. c. Generate an e-mail user name for each employee using the first letter of the employee's first name and the first five letters of the employee's last name, eg. Rod Smith - > rsmith. Include Employeeld. EmployeeFirstName, and EmployeeLastName in the query Name the query Employee_Email Generator. d. Calculate the total sales for each month. e Determine which customer had the highest average sales amount. (Hint Sort in descending order) 1. Assume the employees earn a 5 percent commission on sales. Calculate the total commission due to each employee. Use two queries to do these calculations Required: e. Which customer had the highest average sales amount? What specifically was their average amount? 1. Which employee had the highest earned commission? What specifically was their commission amount? Required Information Problem 4-8 and Problem 4-9 [LO 4-2] [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) a. The database contains three tables containing Information about this company's sales process: Inventory. Soles, and Salesitems Use the Relationships window to link the tables together. b. 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 Invoice, InventoryID. Quantity, and UnitPrice in the query. Name the query Item_Extension Calculation c Calculate the total dollar amount of each sale. Include InvoiceID. InvoiceDate, Customer and Employee from the Sales table and the Amt from the Item.Extension_Calculation query Name the query Sale_Amount_Calculation d. Calculate total sales for each Inventory Item e. Calculate total sales 1. Calculate the month in which each sale occurred. Include Invoice and Invoice Date from the Sales table Name the query Sales_Months. (Hint Look for the Month function in the expression builder) 9. 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? Complete this question by entering your answers in the tabs below. Required D Required E Required G g. Which month had the highest sum of sales? What specifically was the sales amount? (Input your answers exactly thay appear in Access with 2 decimal when required.) had the highest sum of sales which was a. Go to the Relationships screen and connect the five tables, enforcing referential Integrity b. Calculate the total sales for each customer. Include Customers and Company Name from the Customer table and the calculated sale amount from the Sale_Amount Calculation query. Name the query Total Customer_Sales. c. Generate an e-mail user name for each employee using the first letter of the employee's first name and the first five letters of the employee's last name, eg. Rod Smith - > rsmith. Include Employeeld. EmployeeFirstName, and EmployeeLastName in the query Name the query Employee_Email Generator. d. Calculate the total sales for each month. e Determine which customer had the highest average sales amount. (Hint Sort in descending order) 1. Assume the employees earn a 5 percent commission on sales. Calculate the total commission due to each employee. Use two queries to do these calculations Required: e. Which customer had the highest average sales amount? What specifically was their average amount? 1. Which employee had the highest earned commission? What specifically was their commission amount