9. This problem contin ues problem 8. Use the Access_practice.acccdb database that you have been working on to complete the following tasks.

9. This problem continues Problem 8. Use the Access_Practice.accdb database that you have been working on to complete the following tasks. L04-2 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 CompanyName 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 Page 127 first five letters of the employee's last name, e.g., 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.) f. 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. 9. This problem continues Problem 8. Use the Access_Practice.accdb database that you have been working on to complete the following tasks. L04-2 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 CompanyName 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 Page 127 first five letters of the employee's last name, e.g., 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.) f. 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