Calculating fields in Access 2010

Create calculated fields: [2009 Salary]: [Salary]*[2008Increase]+[Salary]
Create calculated fields: Bonus: IIf([Performance]=”Excellent”,0.05*[Salary],IIf([Performance]=”Good”,0.025*[Salary],0))
Then create a new field called increase, tjem Subtract [2008 Salary] from [2009 Salary] to perform the

irstName

00

Salary

0

Salary

00.0

2

F T01

000.0

L01 Good

/05

3

F T01

1

0.0

L01

/08

4

F T01

00.0

L01 Good

/

5

iels

M T01

0.0

L01 Good

6

ny

M T01

0.0

L01

7

F T01

0.0

L01 Excellent

8

F T01

000.0

L01 Good

9

M T01

.0

L01 Good

/06

10

F T01

00.0

L01 Average

M T01

00.0

L01 Excellent

12

M T01

600.0

L01 Average

F T01

200.0

L01 Average

/04

F T01

0.0

L01 Excellent

15

F T01

L01 Good

F T01

00.0

L01 Good

/02

F T01

0.0

L01 Average

18

F T01

500.0

L01 Good

/

on

F T01

0.0

L01 Excellent

20

John M T01

400.0

L01 Average

21

M T01

00.0

L01 Excellent

22

ise

F T01

200.0

L01 Average

F T01

00.0

L01 Excellent

Harris

F T01

900.0

Average 12/9/04

25

M T01

700.0

L02 Excellent

26

Jan F T01

700.0

L02 Good

27

M T01

00.0

L02 Excellent 9/5/05

28

F T01

L02

F T01

L02 Good

30

nda

F T01

L02 Good

31

F T01

00.0

L02 Excellent

32

Karen F T01

00.0

L02 Good

33

F T01

00.0

L02 Good

34

F T01

00.0

L02 Excellent

35 Park

F T01

00.0 L02 Average

F T01

L02 Excellent

37

F T01 46900.0 L02 Good

38

ald

F T01

L02 Excellent

39

M T01

L02 Good

40

a

nne

F T01

L02 Average

F T01

0.0

L02 Good

42

M T01

0.0

L02 Good

F T01

00.0

L02 Good

44

F T01

L02 Good

45

F T01

L02 Good

46

F T01

L02 Average

47

F T01

00.0

Good

48

F T01

00.0

L03 Excellent

49

Susan F T01

0.0

L03 Average

50 Mills

F T01 44700.0 L03 Good

M T01

L03 Average

52

M T01

00.0

L03 Average

M T01

00.0

L03 Average

F T01 27200.0 L03 Excellent

M T01

L03 Average

56

F T01

00.0

L03 Average

57

Joan F T01

00.0

L03 Average

F T01 49000.0 L03 Excellent

F T01

0.0

L03 Average 12/9/04

60 Park Jack M T01

00.0

L03 Excellent

61

F T01

.0

L03 Excellent

62

F T01

0.0

L03 Good

F T01

.0

L03 Excellent

64

Julia F T01

0.0

L03 Excellent 2/12/04

Johnson

my

M T01

L03 Average

M T01

L03 Average

F T01

00.0

L03 Excellent

68

Eleanor F T01 46900.0 L03 Average 8/26/04

69

F T01 45000.0 L03 Average

70

F T01 32800.0

Average

M T01 49000.0 L04 Good

72

F T01

L04 Good

Payne

M T01

L04 Good

M T01

0.0

L04 Average

F T01

.0

L04 Average

F T01

00.0

L04 Excellent

Mills

F T01

00.0

L04 Average

78

F T01

00.0

L04 Average

79

M T01

00.0

L04 Excellent

80

F T01

0.0

L04 Average

F T01

00.0

L04 Average

82

F T01 39000.0 L04 Average

Bob M T01

00.0

L04 Average

84

F T01

L04 Excellent

Mike M T01

0.0

L04 Excellent

86

F T01

L04 Good

F T01 40600.0 L04 Average

88

M T01

L04 Average

89

George M T01

L04 Average 6/17/05

90

Barbara F T01 40200.0 L04 Average

91 Johnson Michael M T01

L04 Average

92

F T01

L04 Excellent 3/13/04

93

M T01

Excellent 3/23/06

94

Kathy F T01 32000.0 L05 Excellent

95 Jones

F T01

0.0

L05 Good

96

F T01

L05 Poor

97

M T01

L05 Poor

98

F T01

00.0

L05 Average

99

M T01

00.0

L05 Excellent

100

Laura F T01

00.0

L05 Good

M T01

L05 Excellent

M T01 33100.0 L05 Good 8/11/04

F T01 44200.0 L05 Average

F T01

L05 Excellent

Morgan F T01

00.0

L05 Excellent

M T01

L05 Excellent

Cynthia F T01

00.0

L05 Poor

F T01

L05 Excellent

F T01

L05 Excellent

M T01

L05 Good

Eckblom Linda F T01

0.0

L05 Excellent

Jan F T01

L05 Excellent 3/13/04

Paige

F T01

L05 Excellent

Jerry M T01

L05 Excellent

F T01

0.0

L05 Good

F T01

Average

F T01 43200.0 L06 Excellent 11/24/03

F T01

L06 Average

M T01

00.0

L06 Excellent

F T01

0.0

L06 Average

F T01

L06 Excellent 6/17/05

Ron M T01 49300.0 L06 Good 12/22/04

F T01

00.0

L06 Average

Paula F T01

L06 Good

Smith

F T01 37200.0 L06 Good 4/20/05

Barbara F T01 41800.0 L06 Excellent

M T01 40600.0 L06 Average 12/22/04

F T01 44700.0 L06 Excellent

F T01

L06 Excellent

130

ell

F T01

L06 Good

Gary M T01

Average

Smith

M T01

L07 Poor

M T01

00.0

L07 Poor

Debbie F T01

L07 Good

M T01 29300.0 L07 Excellent

F T01 46600.0 L07 Good

F T01

00.0

L07 Excellent

George M T01

L07 Excellent

Brown

F T01 45000.0 L07 Average

F T01

L07 Average

M T01 34500.0 L07 Average

M T01

L07 Excellent

Dan M T01 41800.0

Average 3/15/06

M T01

L08 Average

F T01

00.0

L08 Average

F T01

L08 Average 12/12/03

Crystal F T01

L08 Average 12/22/03

F T01

L08 Average

M T01

L08 Average

F T01

L08 Good

Smith

M T01 30300.0 L08 Good

ces

F T01 45300.0 L08 Good

M T01

L08 Average

F T01

L08 Excellent 9/5/05

M T01

00.0

Average

F T01

00.0

L09 Excellent

Smith Deborah F T01 27100.0 L09 Average

Munroe

F T01 43200.0 L09 Average

Barbara F T01

L09 Average

160

F T01 39600.0 L09 Good

M T01

L09 Average

F T01

L09 Good

F T01

L09 Good

Wood

F T01

L09 Good 8/26/04

F T01 36800.0 L09 Average 9/2/04

Fran F T01 45000.0 L09 Excellent

M T01 44200.0

Excellent 12/22/03

Holly F T01

00.0

L10 Good 4/18/05

F T01 25800.0 L10 Good

170

F T01

00.0

L10 Excellent

George M T01

L10 Good

F T01 42600.0 L10 Average

F T01

00.0

L10 Good

Betsy F T01 49000.0 L10 Excellent 12/12/03

M T01 42700.0 L10 Average

F T01 41300.0 L10 Average

F T01 29400.0 L10 Average 4/28/05

M T01

00.0

L10 Good 1/7/05

F T01 43900.0

Good

180 Edmunds Jack M T01 46700.0 L11 Good 4/16/05

F T01

00.0

L11 Good 4/28/05

Jessica F T01 42400.0 L11 Average 2/1/05

Strump

M T01 45600.0 L11 Average 11/17/03

F T01

L11 Average

F T01

L11 Excellent 11/17/03

F T01

L11 Good 5/27/06

M T01

L11 Average

F T01 31400.0 L11 Excellent

M T01 49000.0 L11 Excellent

190

F T01

00.0

L11 Good

Kathy F

L01 Excellent

John M T02

L02 Good

F T02

L03 Excellent

F T02

L03 Good 4/18/05

F T02

L04 Good

M T02

L04 Excellent

F T02

L05 Good

Laura F T02

L06 Good

Dan M T02

L07 Excellent

200

Linda F T02

L08 Average

Cole

M T02

L09 Excellent

Anderson

F

L01 Excellent

M T04

L01 Average

F T04

L01 Good

Susan F T04

L01 Good

Newman

M T04 45000.0 L01 Average

Li

M T04

L01 Excellent

F T04

L01 Average 1/18/05

Susan F T04

L01 Excellent 4/24/05

F T04

L01 Excellent 6/10/04

F T04

L01 Average

F T04

L02 Average

Kelly

M T04

L02 Good

Laurie F T04 44300.0 L02 Excellent

Wendy F T04

L02 Good

F T04

L02 Good

Battle Susan F T04

L02 Good

Allison F T04

L02 Average

F T04

L02 Excellent 9/4/06

220

M T04

L02 Average

Gary M T04 42600.0 L02 Excellent

Becky F T04

L03 Excellent

Susan F T04

L03 Good

John M T04

L03 Excellent

Lolly F T04

L03 Poor

M T04

L03 Excellent 6/28/05

F T04

L03 Good 12/25/04

M T04 56200.0 L03 Good 9/2/04

F T04

L03 Average

230

M T04

L03 Average

Kristen F T04

L03 Excellent

Vieth Mimi F T04

L03 Average

F T04 48500.0 L04 Good 2/4/06

Ashley

F T04 51900.0 L04 Good

Adams

M T04

L04 Excellent

John M T04 42600.0 L04 Good 9/30/05

Barbara F T04

L04 Average 2/1/05

David M T04

L04 Good

Mary F T04

L04 Average

240

Judy F T04

L04 Good 2/24/06

F T04

L04 Good

M T04

L04 Excellent 4/20/05

Woods

F T04

L04 Average

F T04

L05 Good

F T04

L05 Excellent

M T04

L05 Average

M T04

L05 Average

F T04

L05 Good

Diane F T04

L05 Good

250 Bartolini

F T04 63000.0 L05 Average

251

F T04

L05 Average

252

F T04

L05 Good 9/6/05

Evans

F T04

L05 Excellent 4/16/05

Park

F T04 46100.0 L05 Excellent 6/28/05

F T04 43300.0 L06 Good

256

F T04

L06 Good

257

Maria F T04 45000.0 L06 Excellent 6/10/04

258 Munroe

F T04

L06 Excellent

Mary F T04

L06 Excellent

260

F T04 59500.0 L07 Average 4/24/05

M T04 48500.0 L07 Good

John M T04 43200.0 L07 Excellent

263

F T04

L07 Average

M T04 40400.0 L08 Good

265

M T04 58000.0 L08 Excellent

Juli F T04

L08 Excellent 1/2/04

Cambell

F T04

L08 Good 1/18/05

M T04 49200.0 L09 Excellent

269

F T04 48200.0 L09 Good

270 Leslie Cheryl F T04 42900.0 L09 Good

271

F T04 42200.0 L09 Average

272

Laurie F T04

L10 Average

273

F T04

L10 Good

274

F T04

L10 Good

Cindy F T04

L10 Average

276

Ben M T04

L11 Average 8/11/04

F T04

L11 Average 6/8/05

278

Cindy F T04

L11 Good 2/16/04

Jim M T04

L11 Average 9/6/05

280 Brown

F

L01 Excellent 6/8/05

M T03

L01 Average

Holly F T03

L01 Average

F T03 21800.0 L02 Average

F T03

L02 Average

M T03

L02 Excellent

M T03

L02 Good

Smith

F T03

L03 Excellent 1/2/04

Mark M T03

L03 Excellent

289 Bryan

F T03

L03 Average

290

F T03

L04 Poor

Michelle F T03

L04 Average 11/24/03

F T03

L04 Good

293 Corlett

F T03

L05 Average

294

Marion F T03 18700.0 L05 Average

295

Cheryl F T03

L05 Good 2/12/04

296

F T03 21800.0 L06 Good 3/1/02

Scott Kelly F T03

L06 Average

Li

M T03 20500.0 L07 Poor

299

Jimmy M T03 21700.0 L07 Good

300

M T03 21700.0 L08 Poor

301

F T03

L08 Excellent 2/16/06

Lisa F T03 20500.0 L08 Good

303

M T03

L09 Excellent

Rodriguez

M T03

L09 Excellent

305

Eleanor F T03

L09 Good

F T03

L10 Poor 10/10/05

Phil M T03

L10 Average

Leslie F T03 19600.0 L10 Excellent 2/28/01

309

M T03

L11 Poor

310

Marjorie F T03

L11 Good 2/16/04

Mike M T03 19200.0 L11 Excellent

																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																						EmployeeID	LastName																																																																																																																																																																																																																				F	Gender		Title	Salary		Location	Performance	HireDate	TermDate		2	8		20	9	Bonus
1	Lacher	Tom																																																																																																				M																																																																																																																																																																																															T01		3	12																																						L01																																																																																																		Good	3/3/0	5
Fantis			Laurie		28	1/	7
Fleming		Karen		4	10																																																																																																										Average			12/12/03	5/	15
Mc Key	Boo		39	6	7/	26	95
		Dan		Phil		42	60			2/1/05
			Park						John		48	40																																																																																															Excellent			9/5/05
		Johnson		Debbie	39	70	6/20/	99
Drubin		Lolly		37	9/9/03
Titley		David		40	200	1/	18	1/12/07
Grippando		Joan	2	61			8/26/04
11	Block	Leonard	2	62			12/9/04	12/26/06
		Mills			Jack		44	11/3/02
13	Nagel		Mimi		46	12/	25
14	Rammos	Mitzi		32	50	6/5/00
	Vieth		Paula		40400.0	5/13/	97	6/12/07
16	Novicheck		Deborah	4	68	11/	22
17	Brumbaugh		Paige		49	30			12/22/03
Abrams		Wendy		47	5/	21	94
19		Harris	Jenifer	44	80	10/16/95
Gander		38	12/28/02
Sell			Mike	4	35	10/6/00	7/13/06
					Smith			Jan		45			1/18/05
23	Pawley			Eleanor	4	27	12/18/	90
24	Jennifer		34																																							L02
North	Randy		31	9/12/	91
Shuffield		33			4/20/05	4/26/08
Barnes	Jeb			4	69
	Michael	Bea		32000.0												Poor		3/23/06
29	Strafaci	Betty			44200.0		3/1/02
Edelman					Li					49000.0	10/29/03
Center	Dante	2	52			6/17/05
Fishe	2	56	11/4/03
Parsley	Eileen	2	57	4/1/91
Brasington	Shelly			2	72	8/3/	96
Tiffany	272	7/12/97	11/26/07
36	Dill		Marjorie			40600.0	2/5/03
Whiting			Kathy	2/18/	93
	Ron	Margaret	36900.0	9/24/93
Gonzalez	Alfonso			44700.0	11/24/97
Freyre			Juli	44000.0	9/4/95
41	Morrison	Andrea	4	230	6/6/99
	Jones	Hank		4	270		10/10/05
43	Vandalay						Susan	4	82	10/2/07
Powell	Monica		43900.0			4/28/05
		Holly	Gwen	35200.0	2/28/	98
Lykes	Caryn	40900.0			11/17/03
Tobin	Yolanda	3	86																																								L03	10/20/03
Buhler	Natalee	4	64	3/22/95
	Bob	3	190	11/5/00
	Marion	4/20/98
51	Flint	Arnold	40000.0		2/24/06
Newcomm	Henry		309	3/24/98
53	Guilford		Jerry	2	88	7/26/03	3/13/03
54	Duffy	Liz	2/11/94
55	Aikman	Dino	45200.0			2/12/04
Heatley	Jane	2	78	7/25/97
	Payne	3	89	6/2/99
58	Rapee	Missy	9/2/94
59	Voell		Michelle	3	250
4	92			3/13/04	4/24/08
Sheridan		Judy		44	300	7/1/05
Lane	Chris		3	280	9/27/94
63	Ogilby			Cheryl							45000	6/24/96
			George		4	220
65			Jim	44900.0	12/16/98	10/11/07
66	Fascfius	Ken		39000.0	11/1/91
67	Snead		Crystal	4	79			9/2/04
McClain
Davidson			Mary			2/16/04
Ship	Joellen																																								L04	8/6/00
71	Spillis	Steve	6/18/94
	Anderson	Tanisha	49900.0	4/19/96
73	Reggie	40700.0	4/21/02
74	Trane	Larry		4	290	4/21/97	11/19/06
75		Cambell		Morgan	25	100			8/11/04
76	Felsher			Laura		256	1/13/94
77					Barbara			258	3/27/01
Parker	Terri			303	1/16/08
Ray	Clay			294	6/30/05
Glasson		Cynthia		3	310	2/24/94
81	Ford	Julie	3	84	4/21/01
Guiterrez	Juanita	11/8/97
83	Walker		276	5/17/02	3/7/06
	Newman	Lynn	33500.0			6/10/04
85	Bobbitt		4	130	3/1/94
	Eckblom		Lisa		37200.0	6/27/95
87	Herst	Helga		1/7/05
De	Maria	Oronzo				43200.0			11/24/03
Mcdowell	33000.0
O’Keefe	4/19/91
49100.0	6/14/92
Lazarus	Kathleen			48500.0
Bailey	LeBron	39900.0																																							L05
Nichols	2/22/02
Danette			4	180	11/20/07
Trice	Suzy	37600.0			6/8/05	6/8/06
Stack		Scott	37900.0	10/16/98	12/31/05
Hoffman	Heidi		252	8/10/96
Diamond			Gary		265	11/6/93
Fischler		305	4/22/91
101	Mahmoud	Rashif		39600.0	9/6/97
102	Goldstein	Manny
103	Moran	Angela	5/16/08
104	Pearce	Ramsey	41300.0	11/1/96
105	Carlo		289	1/23/03
106	Parmenter	Robert	35900.0	6/13/03
107	Freyer		299	6/16/92
108	Bonds	Sofi	40800.0	2/23/94
109	McGrath		Becky		46100.0	10/28/06
110	Lazenby	Jeff	32300.0	1/4/00
111	4	160	5/29/99	6/30/06
112	Shubin	40100.0
113	Maryanne	47300.0	1/18/06
114	Wharton	47100.0	2/4/96
115	Hagood	Jo Ellen	4	170	3/22/98
116	Bland	LaKesha	38000.0																								L06			12/22/04
117	Thompson		Ashley
118	Krissel	Chriss	36200.0	5/22/00
119	Vergaldi		Mark		251	4/23/91
120	Dowling	Marilyn	3	240	5/6/91
121	Mc Dougal	Bridget		49300.0
122	Fairbairn
123	Wynperle		Betsy		295	12/30/91
124	Murphy		45600.0	10/22/91
125		Jessica
126	Miller	8/19/91
127	Cybert	Emit
128	Jenks	Jean	5/6/03
129	Scola	Kolleen	31700.0	2/26/02
		Brown	Pat		45300.0	5/26/98
131	Worley		34500.0																				L07	1/2/01
132	LeVon		46600.0	4/16/93
133	Schultz	Judge			293	11/11/96
134	Jefferson	36700.0		3/15/06
135	Everett	Kyle	7/6/98
136	Mason	Cara	9/4/02
137		Corlett	Meg		273	3/13/94
138	Kickman	47600.0			1/2/04
139	Patsy	9/9/01
140			Munroe	Alexandra		31400.0	9/9/99
141	Bianch	Arthur	7/23/00
142	Thomas	Kenny		42400.0	9/29/00
143	Erpf																					L08
144	Tamer	Bill	47800.0			4/16/05
145	Maragni			Cindy		260	6/3/07
146	Sade			Leslie	27000.0
147	Kahn		46700.0
148	Mulva		Allison	46500.0	8/20/03
149	Bell	Roni	38400.0	6/10/03
150		Wood	Debby		36800.0	9/1/91
151	Fred	1/21/02
152	Houtz		Fran	1/27/02
153	Brockhouse	Kevin				42600.0		9/30/05
154		Cole	Melissa	31800.0
155	Cooper	Rick		263																					L09	10/17/99
156	Martin	Carole			271	4/9/91
157		9/4/06
158	Agnes	6/4/97
159	Tarbe	33700.0	12/9/93
Sapp		Kristen			4/18/05
161	Bermont	William		48200.0	9/26/05
162	Brooks	Patty		49200.0	9/30/92
163			Kelly	Clara	42500.0	12/13/98
164	LaKeesha	45800.0
165		Evans	Lenore
166	Huling	7/19/96
167		Bartolini	Armando																				L10
168	Wilson		257
169	Justice	Dainey	7/3/02
Bray	Sarah		269			4/24/05
171		Edmunds	49500.0	10/9/93
172	Magenheimer	Carolyn	8/29/07
173	Hood	Georgia		274	2/18/98
174		Strump
175	Morteleo	Judson		5/27/06
176	Siegal	Jamie	11/28/95
177	Cleos	Michele
178	Ross	Bobby		296
179		Battle	Susannah																				L11	7/17/94
181	Cobb	Meredith		301
182	Skor
183	Jay
184	Brickey	Sandra	49600.0	6/11/98
185	Moss	Amy	41100.0
186	Hopkins	Garth	42200.0
187	Ruble	Troy	45500.0	11/28/98
188	Winnick	Hildee	4/5/04
189	Kahl	Elias	3/6/99
Manning	Caroline		278	10/23/91
191	Wiggins												T02	74200.0	7/12/94
192	Starke	77100.0	5/24/92
193	Kollner	Christy	84600.0	5/20/00
194	Brawner	Shari	84400.0
195	Boss	Sissy	76300.0			9/6/05
196	Munter		Bryan	71500.0	5/17/91
197	Roberts	Margie	70900.0	8/21/98
198	Figure	95000.0	2/20/91
199	Chiavacci	70000.0	1/30/01
Elway	71800.0	4/2/08
201	Moe	74500.0	11/25/99
202	Vicki																																																																															T04	47900.0	9/18/02
203	McCammon	Johnny	43100.0	6/19/99
204	Rudy	Libby	40300.0	4/20/95
205	Bichette	61500.0	9/7/94
206	Adam	10/8/00
207	Jhoon-Rhee	51300.0	6/16/03
208	Imber	Elise	63700.0
209	Valls	57500.0
210	Davis	Martha		51900.0
211	Williamson	Jo-Ann	37100.0	10/6/03
212	Wilkinson	Jodi		59500.0	11/27/02
213	Burt		63000.0	9/13/94
214	Fegin		2/16/06
215	Alworth		56200.0	2/28/00
216	Smart		Diane	35300.0		12/25/04
217	37000.0	8/17/99
218	Moynahan	35700.0	12/11/95
219	Tilghman	Arianne	61900.0
Brett	Cameron	41400.0	11/10/99
221	Pennekamp		2/4/06
222	McKinney	62900.0			6/28/05
223	Billingslea	54200.0	2/25/91
224	Noble	39200.0	11/9/92
225	Drier	52600.0	1/2/93
226	Armstrong	Ringo	53500.0
227		Woods	Cherie	41000.0
228		Adams	LeShon
229	Isenbergh	Dinah	57800.0	2/5/99
Spinale	Hunter	37800.0	8/10/91
231	Schobelock	61400.0	1/8/93
232	49800.0	2/18/92
233	Bocholis	Sue
234	Tina	6/13/99
235		Ben	45900.0		2/28/01
236	Jackson
237	Moll	52000.0
238	Dunes	46000.0	7/30/92
239	Watson	64500.0	4/5/05
Sharp	62700.0
241	O’Donell	Criste	57600.0	1/18/92
242	Sussman	Ryan		58000.0
243	Claudia	47500.0	1/23/05
244	Bogani	Sonia	44600.0	4/11/97
245	Young	Beth		43300.0	2/19/93
246	Watt	Jimmy	60200.0	9/9/00
247	Afflord	Lance	59100.0	2/8/07
248	Mosely	Ana Marie	64800.0	6/2/01
249	Jamison	53700.0	5/20/96
Suzie	5/20/94
Shindell	Johanna	43800.0	10/7/93
Sywolski	Annette	35600.0
253	LaQuinita	39300.0
254	Terry
255	Houston	Galia	7/3/92
Mc Cammon	Cantillon	45400.0	7/25/91
	Rodriguez
Sylvia	54400.0	11/1/02
259	Crowder	60900.0	10/28/03
Lundeen	Cathy
261	Reid	Harold	7/30/06
262	Cookson	10/14/95
Hasty	Jeanne	63800.0	7/8/95
264	Lederman	Eric	6/24/03
Ramirez	Ricardo	3/2/04
266	Glassman	42300.0
267	Nancy	62000.0
268	Goyette	Alonzo	9/16/02
Reed	Maylou	6/14/95
5/14/93
Collins	Megan	3/27/95
Felser	51000.0	10/9/97
Brinckerhoff	Ruth	60100.0	9/30/98
Posten	Pauline	60500.0	8/2/91
275	Kirsman	37300.0	7/13/92
Prider	63200.0
277	Foerster	June	45700.0
Knight	46300.0
279	Brockway	55400.0
LaShonda																																	T03	20100.0
281	Johnshon	Gunnar			21800.0	4/25/95
282	Simon	18500.0	11/5/95
283	Pfleger	Penny	9/12/98
284	Weber	Lorna			21700.0	3/7/03
285	Cusak	Frank		18700.0	4/30/02
286	Beamer	Brian	20900.0	8/27/02
287	Denie	19800.0
288	Liler	22700.0	2/9/96
Ofe	18300.0	5/24/03
Sotolongo	Cristi	21400.0	6/2/98
291	Clarke	21500.0
292	Lobree	Celeste	18200.0	3/10/99
McClendon	22000.0	10/18/07
Moore	1/27/95
Stieglitz			20500.0
Halloway	Jill
297	18400.0	4/13/92
298	Steven	12/27/02
Sampieri	8/22/01
Robins	Tony	4/22/90
Zachar	Anita	19500.0
302	Eastcott	7/10/08
Edelstein	Francis		19200.0	7/4/01
304	Domingo	19300.0	11/30/98
Zaytown	19900.0	8/12/92
306	Porter	Peggy	20600.0
307	Dellis		19600.0	10/7/91
308	White
Witherspoon	Nick	21300.0	10/25/91
Dorn	18100.0
311	Quinton	8/21/93

Location

L01

L02

L03

L04

L05

L06

L07

L08

L09

L10

FL

L11

CA

LocationID	Address	State	Zipcode	OfficePhone	CostOfLiving
Atlanta	450 Peachtree Road	GA	30316	(404) 333-5555	97.4
Boston	3 Commons Blvd	MA	02190	(617) 123-4444	135.4
Las Vegas	1250 W. Flamingo Rd	NV	90003	(702) 555-3897	93.0
Branson	3750 River Road	MO	64101	(816) 555-9998	94.2
New York	3495 Fifth Avenue, Suite 33998	NY	10029	(212) 555-6654	204.3
San Francisco	44 Montgomery Street		CA	94102	(415) 555-3737	171.4
Chicago	500 Loop Highway	IL	60620	(312) 444-6666	117.4
Miami	1417 NE 136th St		FL	33018	(305) 555-0098	116.2
Phoenix	4535 N. 23rd Ave	AZ	85001	(602) 555-0098	100.4
Orlando	1000 Kirkman Road	32801	(407) 555-5555	107.3
Los Angeles	1000 Rodeo Drive	90210	(213) 666-6666	159.0

Title

T01

T02

Four year degree

T03

25000

T04

45000 150000 0.04

TitleID	Description	EducationRequired	MinimumSalary	MaximumSalary	2008Increase
Account Rep	A marketing position requiring a technical background. Employees begin with a fixed salary, then switch to a combination of salary and commission.		Four year degree		25000	75000	0.03
Manager	A supervisory position requiring at least 5 years in the company or an equivalent industrial experience. Primary responsibility is to help the Account Reps in a sales capacity.	50000		150000		0.04
Trainee	An entry-level position in which the employee interns at several functional areas in the corporation. The normal training period lasts approximately one year.	Two year degree	18000	0.05
SeniorRep	A senior, non supervisory position	Four Year Degree

SELECT Employees.Location, Employees.LastName, Employees.FirstName, Employees.Gender, Employees.Title, Employees.Performance, Employees.Salary, Employees.HireDate, Employees.[2008 Salary], Employees.[2009 Salary]
FROM Employees;