Exp19_Access_Ch8_Cap_Performance

profilelacey.xyY
Blake_Exp19_Access_Ch8_Cap_Performance.accdb
Home>Computer Science homework help>Exp19_Access_Ch8_Cap_Performance
EmployeeID LastName FirstName Gender Title Salary Location Performance HireDate Probation
3 Fleming Karem F T01 ¤ 41,100.00 L01 Average 2016-12-12 false
9 Titley David M T01 ¤ 40,200.00 L01 Good 2019-01-18 false
17 Brumbaugh Paige F T02 ¤ 57,500.00 L01 Average 2016-12-22 false
19 Harrison Jenifer F T01 ¤ 44,800.00 L01 Excellent 2018-10-16 false
21 Sell Mike M T01 ¤ 43,500.00 L01 Excellent 2013-10-06 false
27 Barnes Jeb M T02 ¤ 56,900.00 L02 Excellent 2018-09-05 false
28 Michael Bea F T01 ¤ 32,000.00 L02 Poor 2019-03-23 true
36 Dill Marjorie F T01 ¤ 40,600.00 L02 Excellent 2016-02-05 false
38 Ronald Margaret F T01 ¤ 38,900.00 L02 Excellent 2016-09-24 false
40 Freyre Julianne F T01 ¤ 44,000.00 L02 Average 2018-09-04 false
73 Payne Reggie M T01 ¤ 40,700.00 L04 Good 2015-04-21 false
76 Felsher Laura F T01 ¤ 35,750.00 L04 Excellent 2017-01-13 false
79 Ray Clay M T01 ¤ 39,500.00 L04 Excellent 2018-06-30 false
82 Guiterrez Joan F T01 ¤ 39,000.00 L04 Average 2013-11-08 false
132 Smith Johnny M T01 ¤ 46,600.00 L07 Average 2016-04-16 false
133 Schultz Judge M T02 ¤ 50,750.00 L07 Poor 2019-11-11 true
134 Jefferson Debbie F T01 ¤ 36,700.00 L07 Good 2019-03-15 false
135 Everett Kyle M T01 ¤ 39,300.00 L07 Excellent 2018-07-06 false
140 Munroe Alexandra F T01 ¤ 41,400.00 L07 Average 2017-09-09 false
142 Thomas Kenny M T01 ¤ 42,400.00 L07 Excellent 2013-09-29 false
290 Sotolongo Cristi F T03 ¤ 24,000.00 L04 Average 2018-06-02 false
ID mSysRowId
1
SELECT Employees.LastName, Employees.FirstName, Employees.Performance, Employees.Salary, [Salary]*[Raise]+[Salary] AS NewSalary, IIf([Performance]="Excellent",0.05*[Salary],IIf([Performance]="Good",0.025*[Salary],0)) AS Bonus, Employees.Probation, (([NewSalary]+[Bonus])-[Salary])/[Salary] AS PercentIncrease, Employees.HireDate FROM Employees;