Question

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

ANSWER a

PLEASE USE MS ACCESS TO ANSWER (a)

Answer 1

a)

Name	Department	Specialty	Salary
Ashley, Jane	Marketing	Market Analysis	$107,700.00
Ching, Kam Hoong	Marketing	Operations Manager	$122,000.00
Collins, Giovanni	IS	Database Administrator	$160,500.00
Dixon, James T	Marketing	Outside Sales Manager	$107,700.00
Dixon,Eleonor	IS	CISO	$179,600.00
Drew, Richard	Accounting	Cost Accounting	$103,300.00
Duong,Linda	Marketing	Outside Sales	$104,950.00
Lane, Brandon	Accounting	Cost Accounting Manager	$125,300.00
Lee,Brand on	IS	Asst. Database Administra	$127,500.00
Lund en,Haley	IS	Development	$120,900.00
Menstell,Lori Lee	Marketing	Market Analysis Manager	$141,800.00
Pham,Mary	IS	Development	$123,100.00
Scott, Bryan	IS	Development	$119,800.00
Scott, Rex	Marketing	Inside Sales Manager	$113,200.00
Warrem, Jason	Accounting	Accounts Payable Manage	$103,300.00

b)

Name	Specialty
Ashley, Jane	Market Analysis
Bosa, Victor	Inside Sales
Ching, Kam Hoong	Operations Manager
Dixon, James T	Outside Sales Manager
Duong,Linda	Outside Sales
Gaston, Sayeh	Outside Sales
Jordan, Matthew	Inside Sales
Menstell,Lori Lee	Market Analysis Manager
Scott, Rex	Inside Sales Manager
Lifran,Diern Thi	Outside Sales

c)

Average	Maximum	Miniimum
$102,191.67	$179,600.00	$59,300.00

d)

Average	Maximum	Minimum
$120,456	$179,600	$78,000

e) Let me know if you want it so I will do it Student. Otherwise, feel free to leave a thumbs up :D