Suppose that you have been asked to assist in the managerial decision about how much to increase pay in the next year. Specifically, you are tasked to determine if there are significant salary differences among departments in your company.

You are given an Access database with a table of employee data with the following structure:

EMPLOYEE (Name, Department, Specialty, Salary)

where Name is the name of an employee who works in a department, Department is the department name, Specialty is the name of the employee’s primary skill, and Salary is the employee’s current salary. Assume that no two employees have the same name. You have been asked to answer the following queries:

(1) List the names, department, and salary of all employees earning more than $100,000.

(2) List the names and specialties of all employees in the Marketing department.

(3) Compute the average, maximum, and minimum salary of employees in your company.

(4) Compute the average, minimum, and maximum salary of employees in the Marketing department.
(5) Compute the average, minimum, and maximum salary of employees in the Information Systems department.
(6) Extra credit: Compute the average salary for employees in every department. Use Group By.

a. Design and run Access queries to obtain the answers to these questions, using the data in the Access file Ex10.

b. Explain how the data in your answer contributes to the salary increase decision.

c. Suppose other team members want to use your Access application. Name three ways you can share it with them, and describe the advantages and disadvantages of each.