Reference no: EM132668075
Question - Use the Access_Practice.accdb database to complete the following tasks in Access.
Use the database to complete tasks a through g in Access. Answer the questions below after completing tasks d, e, and g, respectively.
1. Go to the Relationships screen and connect the five tables, enforcing referential integrity.
2. 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.
3. 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.
4. Calculate the total sales for each month.
5. Determine which customer had the highest average sales amount. (Hint: Sort in descending order.)
6. 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 -
a. Which customer had the highest average sales amount? What specifically was their average amount?
b. Which employee had the highest earned commission? What specifically was their commission amount?
|
Ethical-legal components of corporate social responsibility
: Differentiate between the ethical and legal components of corporate social responsibility
|
|
What amount of accrued liability should tedd have
: A reasonable estimate of additional taxes was $400,000 but could be as much as $600,000. What amount of accrued liability should Tedd have
|
|
Leadership and creative solutions
: In what kinds of change initiatives are you currently involved-shallow, deep, mixed? What Changes and What Doesn't?
|
|
Create training and development system for the organization
: The CEO has approved funding for your project to create a training and development system for the organization. She now wants you to explain your process.
|
|
Which employee had the highest earned commission
: Which customer had the highest average sales amount? What specifically was their average amount? Calculate the total sales for each month
|
|
What was your favorite part of the course
: What was your favorite part of the course? What was your least favorite? (Not to include homework/classwork). Which chapter did you like the most?
|
|
Enhancing ethical behavior in workplace job satisfaction
: TOPIC Cultural diversity in the workplace Enhancing ethical behavior in the workplace Job satisfaction, the loyalty of the worker to the company,
|
|
Determine the deferred tax liability
: Jaguar Ltd purchased a machine on 1 July 2016 at the cost of $640,000. Determine the deferred tax liability and/or deferred tax asset that will result
|
|
Do you feel rights are being protected or infringed
: Communicable diseases are a potential concern for the local, state, and federal governments, as well as public health officials and the community.
|