ANSWER a

PLEASE USE MS ACCESS TO ANSWER (a)

EMPLOYEE X Name Adams, James Angel, Kathy Ashley, Jane Bosa, Victor Ching, Kam Hoong Collins, Giovanni Corning, Sandra Corovic, Jose Davidson Kaye Dixon, James T Dixon, Eleonor Drew, Richard Duong, Linda Goston, Sayeh Jordan, Matthew Lane, Brandon Lee, Brandon Lunden, Haley Menstell,Lori Lee Pham, Mary Quigly, James Ray, Tony Rikki, Nicole Ryan, Mark Scott, Bryan Scott, Rex Spenser, William UTran,Diem Thi Warrem, Jason Wei, Guang * - Department Accounting IS Marketing Marketing Marketing IS Accounting Accounting Accounting Marketing IS Accounting Marketing Marketing Marketing Accounting IS Specialty Salary Accounts Receivable $59,300.00 Operations $92,300.00 Market Analysis $107,700.00 Inside Sales $71,400.00 Operations Manager $122,000.00 Database Administrator $160,500.00 Market Analysis $91,200.00 Accounts Receivable $59,300.00 Accts Payable Manager $98,800.00 Outside Sales Manager $107,700.00 CISO $179,600.00 Cost Accounting $103,300.00 Outside Sales $104,950.00 Outside Sales $96,700.00 Inside Sales $73,600.00 Cost Accounting Manager $125,300.00 Asst. Database Administra $127,500.00 Development $120,900.00 Market Analysis Manager $141,800.00 Development $123,100.00 Operations $82,400.00 Accts Payable $79,100.00 Help Desk $78,000.00 Accounts Receivable $70,300.00 Development $119,800.00 Inside Sales Manager $113,200.00 Cost Accounting $100,000.00 Outside Sales $87,900.00 Accounts Payable Manage $103,300.00 Accts Payable $64,800.00 IS Marketing IS IS Accounting IS Accounting IS Marketing Accounting Marketing Accounting Accounting 2-2 the advantages and disadvantages of each. Suppose that you have been asked to resist 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) Compule 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 In- formation 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 file ChO2EX02_U9e.accdh