This problem continues Problem $8.$ Use the Access$\_$Practice.accdb database that you have been working on to complete the following tasks. $[$O $4-2$

a$.$ Go to the Relationships screen and connect the five tables, enforcing referential integrity.

b$.$ Calculate the total sales for each ustomer. Include CustomerID 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 first

Page $127$

five letters of the employee's last name, e$.$g$.,$ Rod Smith $=>$ rsmith. Include EmployeeID, 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.