Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the!Access_Practice.accdbldatabase that you have been working on to complete the following tasks. a. Go to the Relationships screen and connect the five tables, enforcing

Use the!Access_Practice.accdbldatabase that you have been working on to complete the following tasks. 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 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 emplo) Use two queries to do these calculations.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

If 0 Answered: 1 week ago

Answered: 1 week ago

Question

What do you need to know about motivation to solve these problems?

Answered: 1 week ago

Question

8. Demonstrate aspects of assessing group performance

Answered: 1 week ago