DISCUSSION QUESTION
Required information [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.
- a. Go to the Relationships screen and connect the five tables, enforcing referential integrity.
- b. Calculate the total sales for each customer. Include CustomerlD 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 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.
Required:
- Which customer had the highest average sales amount? What specifically was their average amount?
- Which employee had the highest earned commission? What specifically was their commission amount?
