please please please explain this question. I am really stuck.

I apps.ccsu.edu CCSU Applications General Lab Desktop Include InvoicelD, InvoiceDat X d. Calcul. *Homework Help - Q&A from Online Tut.. C I Need Help With How To Calculate Th... + Central Pipeline Bb MS Access Tutorial - AC-340-OL X 5 6020002 Connect X + X C D ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activity/question-group/kEZAS.. Apps Chapter 4: Homework Saved Help Save & Exit Submit Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to question 2 Required information Part 2 of 2 Required: e. Which customer had the highest average sales amount? What specifically was their average amount? f. Which employee had the highest earned commission? What specifically was their commission amount? 10 points x Answer is not complete. Complete this question by entering your answers in the tabs below. Required E Required F f. Which employee had the highest earned commission? What specifically was their commission amount? (Input your answers exactly as they appear in Access, with 2 decimals when required.) Barbara Watterson had the highest earned commission, which was Mc Graw Hill Type here to search A 7:10 PM 9/29/2020 I apps.ccsu.edu CCSU Applications General Lab Desktop Include InvoicelD, InvoiceDat X d. Calcul. *Homework Help - Q&A from Online Tut.. C I Need Help With How To Calculate Th... + Central Pipeline Bb MS Access Tutorial - AC-340-OL X 5 6020002 Connect X + X C D ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activity/question-group/kEZAS.. Apps Chapter 4: Homework Saved Help Save & Exit Submit Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to question 2 Required information Part 2 of 2 Required: e. Which customer had the highest average sales amount? What specifically was their average amount? f. Which employee had the highest earned commission? What specifically was their commission amount? 10 points x Answer is not complete. Complete this question by entering your answers in the tabs below. Required E Required F e. Which customer had the highest average sales amount? What specifically was their average amount? (Input your answers exactly as they appear in Access, with 2 decimals when required.) Ohio Casualty Corp. had the highest average sales amount, which was $ 8.64 X Mc Graw Hill Type here to search A 7:10 PM 9/29/2020 0 A ezto.mheducation.com C M Connect Ask a Question Chapter 4: Homework Saved Help Save & Exit Submit Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to question 2 Required information Part 2 of 2 [The following information applies to the questions displayed below.] Use the Access_Practice.accdb database to complete the following tasks in Access. 10 points 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 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 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. Required: e. Which customer had the highest average sales amount? What specifically was their average amount? f. Which employee had the highest earned commission? What specifically was their commission amount? x Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Mc Graw