Access Project

I need this project finished today there is an step by step instructions with support excel file but you have to have a Microsoft instead of Mac because it it not supported by mac only Window

New Perspectives Access 2019 | Modules 5-8: SAM Capstone Project 1a

Midwest Executive Professionals

New Perspectives Access 2019 | Modules 5-8: SAM Capstone Project 1a

IMPROVING TABLES, QUERIES, FORMS, AND REPORTS

GETTING STARTED

Open the file NP_AC19_CS5-8a_FirstLastName_1.accdb, available for download from the SAM website.

Save the file as NP_AC19_CS5-8a_FirstLastName_2.accdb by changing the “1” to a “2”.

If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:

Support_AC19_CS5-8a_StateProvs.csv

Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

Midwest Executive Professionals is a firm that connects professional job seekers with job openings. You work in the Research Department of Midwest Executive Professionals as a research analyst. You are developing an Access database application to help manage and analyze companies, jobs, applicants, and job placements facilitated by your company.
In this project, you will improve an existing database by modifying tables, queries, forms, and reports.
Open the JobSeekers table in Design View and complete the following:

After the existing Phone field add a new field named Email with a Hyperlink data type.

Add a second new field named Comments with a Long Text data type.
Save and close the JobSeekers table.

Open the Jobs table in Design View and complete the following:

Add Salary as the caption property to the StartingSalary field.

Add >=Date() as the Validation Rule property for the PostingDate field.

Add Date must be on or after today as the Field Validation Text property for the PostingDate field.
Save and close the Jobs table. If prompted to test data integrity click Yes.

Open the Companies table in Design View and complete the following:

Use the Lookup Wizard to lookup values for the Industry field.

The lookup field should get its values from the Industries table.

Select the Industry field and sort the records in ascending order by the Industry field.

Widen the Industry field to get the best fit for all of the values in the list.

Enable data integrity on the relationship and use Industry as the label for the lookup field.

Save the table if prompted.

Switch to Datasheet View then choose Investment Banking & Asset Management for the Industry field for CompanyID 2 (Des Moines Financial Group).
Close the Companies table.

Open the ApplicationListing query in Design View and complete the following:

Add >=[Enter minimum salary] as parameter criteria to the StartingSalary field.

Run the query using 60000 when prompted. 
Save and close the ApplicationListing query.

Open the IndustryAnalysis query in Design View and complete the following:

Add the Total row to the query grid.

Group By the Industry field, Count the CompanyName field, and Avg (average) the StartingSalary field.

Switch to Datasheet View and widen each column to see all data and field names as shown in Figure 1 with the following measurements: Change the Industry column field width to 35, the CountOfCompanyName to 22, and the AvgOfStartingSalary to 19.
Save and close the IndustryAnalysis query.

Figure 1: Final IndustryAnalysis Query in Datasheet View

Start a new query in Design View and complete the following:

Add the Companies and Jobs tables.

Add the Industry field from the Companies table and the JobTitle and StartingSalary field from the Jobs table to the query grid.

Change the query from a Select query to a Crosstab query.

Put the Industry field in the Column Heading area and the JobTitle field in the Row Heading area.

In the Value area, Avg (Average) the StartingSalary field.

Use JobCrosstab to name and save the query.

Switch to Datasheet View and widen each column to see all data and field names as shown in Figure 2. 
Save and close the JobCrosstab query.

Figure 2: Final JobCrosstab Query in Datasheet View

Open the JobSeekerEntry form in Design View and complete the following:

Add a combo box to the Form Header section at about the 4″ mark on the horizontal ruler using the Combo Box Wizard.

The combo box should find a record.

Select the LastName and then FirstName fields for the combo box list.

Use FIND as the label for the new combo box.

Save the form and open it in Form View.

Use the new combo box to find the Thompson, Christina record.
Close the JobSeekerEntry form.

Open the JobsEntry form in Design View and complete the following:

Add a subform control below the Posting Date label using the Subform Wizard.

The subform should contain all the fields from the ApplicationDates query.

Show ApplicationDates for each record in Jobs using JobID.

Use the default name for the subform.
Save the JobsEntry form, open it in Form View, and then close it.

Open the CompanyEntry form in Design View and complete the following:

Right-align the right edges of the labels in the Detail section.

Right-align the content within the labels in the Detail section.
Save the CompanyEntry form.

With the CompanyEntry form still open in Design View, change the Record Source to the CompaniesSortedByName query.

With the CompanyEntry form still open in Design View, change the tab order in the Detail section so that CompanyID is the first item in the list. Save the form and switch to Form View as shown in Figure 3, and then close the CompanyEntry form.

Figure 3: Final CompanyEntry Form in Form View

Open the JobListing report in Design View and add a horizontal line above the text box in the Report Footer section that sums the StartingSalary. The line should be just above and approximately the same width as the text box. The line will be positioned between the Report Footer section bar and the text box and be approximately 1.7″ wide that is the width of the text box. Save the JobListing report.

With the JobListing report still open in Design View complete the following:

Add the PostingDate field to the left side of the Detail section.

Delete the PostingDate label.

Position the left edge of the PostingDate text box at about the 1″ mark on the horizontal ruler.

Add a label to the Report Footer section at about the 1″ mark on the horizontal ruler.

Use Internal Use Only as the caption for the label.
Save the JobListing report.

With the JobListing report still open in Design View, add a sort order under the existing CompanyName grouping field to sort the records in ascending order on the JobTitle field. Save the report and display the JobListing report in Print Preview as shown in Figure 4, then close the JobListing report.

Figure 4: Final JobListing Report in Print Preview

Open the JobSeekerListing report in Design View and complete the following:

Expand the Report Footer section by about 0.5″.

Add a text box to the Report Footer section at about the 1″ mark on the horizontal ruler and use the expression of =Count([LastName]) as the Control Source for the text box.

Delete the new label in the Report Footer section.
Save the JobSeekerListing report, preview it, then close it.

Copy the CompanyListing report and paste it as the CompanyInfo report. 

Open the CompanyInfo report in Design View and change the Record Source to the CompaniesSortedByName query. Save the CompanyInfo report.

With the CompanyInfo report still open in Design View, add page numbers to the report in an N of M format to the center of the Page Footer. Save the CompanyInfo report, preview it, then close it.

Open the JobSalaries report in Design View and use the Chart Wizard to create a chart at about the 0.5″ mark on the horizontal ruler in the Report Footer section with the following information:

Base the chart on the JobSalaryIndustry query.

Include the StartingSalary and CompanyName fields.

Select a Bar Chart.

Use the CompanyName in the Axis area and the sum of the StartingSalary field in the Data area.

Do not link the report and the chart.

Use Salary Total By Industry as the title for the chart and do not display a legend.

Resize the chart to be about 2.75″ tall and 7″ wide.
Save the JobSalaries report, preview it as shown in Figure 5, and close it.

Figure 5: Final JobSalaries Report in Print Preview

Export the Companies table as an HTML Document to the default folder with the default file name with the following information:

Do not include formatting and layout.

Save the export steps using Export-Companies to HTML for the name.

Do not include an export Description.

Export the CompanyListing report as an HTML Document to the default folder with the default file name with the following information:

Do not select an HTML template.

Use default encoding.

Save the export steps as Export-CompanyListing to HTML for the name.

Do not include an export Description.

Import the Support_AC19_CS5-8a_StateProvs.csv file as a new table with the following information:

The file is in a comma-delimited format.

The first row contains field names.

Do not modify the fields.

The StateAbbrev field should be the primary key.

Use StatesProvs as the new table name.

Do not save the import steps.

Export the Jobs table in an XML format to the default folder with the default file name with the following information:

Export both the Data XML and Schema XSD files.

Save the export steps as Export-Jobs to XML for the name.

Do not include an export Description.

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.

2

_Status

					IfSuccessful	GA_Status_Icon	SAM_Logo
true
	false

false

7E

D-B

7-4

1-9

-02

5

7B

B}

{

7E

7D-B

–

-9

0-0

20

7B23B}

		ID			FirstName			LastName	AssignmentGUID	UserID
Emra	Haskic		{			7							4																	1	77	47			9												2										3	70							5			20							6		23	74		17	477	49			21	37		25	56

ID FirstName LastName

Score

ProjectName	SubmissionNum	Max	Score	EngineVersion

ID

IfSuccessful

StepNumber		Description	StepScore	StepMaxScore	ErrorText	ActionName	StepActionOrder

1 1 1

/21

2 2 1 7/31/21
3 3 1

/1/21

4

1

5

1

6 20 2

/21

7 21 2

8 25 3

9

3

1

/21

2

/21

4

5

14

6

15

4 9/3/21

16

4 9/3/21

17

4

18

5

19

6

20

6

21

6 9/7/21

5

23

5

ApplicationID		JobSeekerID		JobID	ApplicationDate	FollowupDate
		7/	31
			8
		15	8/2/21
		16	8/3/21
8/	14
8/15/21
	8/16/21
	26		8/17/21
		10		40	8/		18
		11		41	8/		19
		12		52	8/31/21
		13		53		9/1/21
	55			9/3/21
	61
	42
	62	9/4/21
	59	9/5/21
	60	9/6/21
	72		9/7/21
	83
	22		84	9/8/21
	85	9/9/21

ID

1

Web Services

8

22

2

7

3

6

33

	Company	CompanyName		Industry	HRContactFirstName	HRContactLastName	HRContact	Phone
Madison			Computer Hardware & Software	Douglas	Perez	55	58	82
Des Moines Financial Group		Insurance Carriers	Mindi	Schwartz	55	57	71	111
Omaha Mutual Research		Financial Analytics & Research	Toni	Lang	555	66	33

EmployeeID	EmployeeFirst	EmployeeLast	Email	Salary	Extension

Industry

lding & Personnel Services

& Telephone Providers

Computer Hardware & Software
Financial Analytics & Research
Insurance Carriers
Internet

Accounting
Advertising & Marketing
Aerospace & Defense
Airlines
Architectural & Engineering Services
Auto Repair & Maintenance
Automotive Parts & Accessories Stores
Banks & Credit Unions
Beauty & Personal Accessories Stores
Biotech & Pharmaceuticals
Brokerage Services
	Bui
Business Service Centers & Copy Shops
Cable,	Internet
Car Rental
Casual Restaurants
Catering & Food Service Contractors
Chemical Manufacturing
Colleges & Universities
Commercial Equipment Rental
Construction
Consulting
Consumer Electronics & Appliances Stores
Consumer Product Rental
Consumer Products Manufacturing
Convenience Stores & Truck Stops
Department, Clothing, & Shoe Stores
Drug & Health Stores
Education Training Services
Electrical & Electronic Manufacturing
Energy
Enterprise Software & Network Solutions
Express Delivery Services
Fast-Food & Quick-Service Restaurants
Federal Agencies
Financial Transaction Processing
Food & Beverage Manufacturing
Food & Beverage Stores
Food Production
Funeral Services
Gambling
Gas Stations
General Merchandise & Superstores
General Repair & Maintenance
Grocery Stores & Supermarkets
Health Care Products Manufacturing
Health Care Services & Hospitals
Health, Beauty, & Fitness
Home Centers & Hardware Stores
Home Furniture & Housewares Stores
Hotels, Motels, & Resorts
Industrial Manufacturing
Insurance Agencies & Brokerages
Investment Banking & Asset Management
IT Services
K-12 Education
Legal
Lending
Logistics & Supply Chain
Media & Entertainment Retail Stores
Membership Organizations
Metal & Mineral Manufacturing
Mining
Miscellaneous Manufacturing
Motion Picture Production & Distribution
Municipal Governments
News Outlet
Office Supply Stores
Oil & Gas Exploration & Production
Oil & Gas Services
Other Retail Stores
Parking Lots & Garages
Pet & Pet Supplies Stores
Preschool & Child Care
Publishing
Radio
Rail
Real Estate
Research & Development
Security Services
Social Assistance
Sporting Goods Stores
Sports & Recreation
Staffing & Outsourcing
State & Regional Agencies
Telecommunications Manufacturing
Telecommunications Services
Toy & Hobby Stores
Transportation Equipment Manufacturing
Transportation Management
Travel Agencies
Truck Rental & Leasing
Trucking
TV Broadcast & Cable Networks
Upscale Restaurants
Utilities
Vehicle Dealers
Video Games
Wholesale

JobID

Description

Company

ingDate

1

,000.00

2 7/31/21

2

1

3

,000.00

3 8/16/21

4

,000.00

3 8/17/21

5

1

6

,000.00

2

7

,000.00

1

8

¤ 64,000.00 2

9

¤ 69,000.00 1

10

2

/21

11

,000.00

1

12

1 9/1/21

13

3

JobTitle	StartingSalary		Post
Director Risk Management	Administrator position responsible for managing planning, organizing, leading, and controlling the activities of the Risk Management Department to minimize institutional risk on capital and earnings. Responsible for business and operational risk management mitigation district-wide.	¤	95
Director of Talent Acquisition	Administrator position responsible for developing recruitment, sourcing and retention strategies and related action plans while implementing best practices to support the talent needs of the college. Responsible for evaluating the recruiting function of the college as well as partnering with other HR leaders and key business leaders to ensure timely understanding of the college’s current and future talent needs and related recruiting demands.	¤ 85,000.00	8/14/21
Facility Services Superintendent	Responsible for managing and supervising all physical facilities operations for the college, operating and maintaining the climate control system as necessary to meet demands, and overseeing the maintenance and operation of all physical facilities systems.		¤	69
User Support Director	Responsible for purchasing, maintaining and supporting IT systems for the end user. The position will have overall responsibility for the IT helpdesk that will provide frontline support to end users for computing, network, phone and media. Directly supervises the helpdesk support team, the PC engineering team and the campus support teams		¤	64
Director of Employee Health Programs	Administrator position responsible for developing, recommending, implementing and directing the company’s employee health programs.	¤ 60,000.00	8/18/21
Administrative Assistant	Full-time staff position to provide skilled confidential secretarial support and administrative assistance, making routine work decisions independently and performing duties requiring advanced computer skills and the use of perceptive judgment and discretion.	¤	39	8/19/21
Research Analyst	Full-time staff position responsible for the design, coordination, production, and reporting of institutional studies relating to product tracking, assessment, program evaluation and enrollment trends.	¤	65	8/20/21
Software Engineer	Develop new or modifies existing research related information technology solutions, including formulation of application systems’ scope and objectives and preparing detailed specification documents.	8/22/21
Systems Engineer	Serves in a technical capacity in multiple domain areas including: system administration, database administration/management, network administration, and telecommunications	8/23/21
Financial Consultant	Responsible to drive successful revenue cycle project implementations. You will analyze data and produce actionable recommendations intended to improve revenue cycle processes and key performance indicators.	¤ 55,000.00	8/	24
Integrated Technologies Architect	An Integrated Technologies Architect develops technical architectures, frameworks and strategies, either for an organization or for a major application area, to meet the business and application requirements.	¤	93	8/25/21
Vulnerability and Threat Analyst	Performs infrastructure and application based security vulnerability assessments in accordance with industry accepted standards and procedures.	¤ 59,000.00
Business Intelligence Developer	Tasked with SQL and Tableau development and data mining. This role will involve meeting directly with teams to understand the reporting needs and deriving answers to questions through data. You will develop scripts to load data from multiple sources into a data mart and also develop and maintain automated reports and dashboards using SQL Server, SSRS, or Tableau.	¤ 70,000.00	9/2/21

JobSeekerID FirstName LastName Phone
1

5

2

0777

3

66

4

23

9

5

4

24

6 Richard

9

7

22

8

9

600

10

7

11

0

12

0044

13

15

0

16

3

5

17 Michael

8578

18

Post

45

19

2

20

21

4

7

22 Michael

21

23

2

24

10

25

6

3

26

40

27

88

29

31 Robert

7

4

32

68

33

003

34 Brent

8

35

1

36

37

0

38

do

0

39

24

40 Michael Washington

0

41

9

42

00

43

3

44

0

45

2

46 Charlene

47

13

48

Slade

49

80

50

1

51

728

52

54

53

22

54

6600

55

66

56

71

57

58

11

59

60

9

61

178

62

7

64

cia

65

66

55

67

888

68

84

69

70

00

71

000

72

73

001

74

75 Robert

73

76

77

8

78

50

79

7

80

3

81

82

0

83

01

84

Gregg

85

0

86

5

87 Jeff

781

88 Anne

00

89

81

90

35

91 Bruce

88

92

8

93 Tim

080

94

95

Eric

00

97

1118

98 David

6

99 Michael

70

100

00

3

Michael

John

2

106

Robert

0

Jeff

07

110

37

111

5

112

Coughlin

07

Michael

0

115 Steve

Kim

55

117 Brad

118 Jennifer

5

Charles

121

9

124

125

126

91

127 Patrick

45

Slade

884

Eric

131 Robert

2

132 Becky

7

6

134

135

Patricia

5

John

776

0

139

Coughlin

140

68

141 Becky

717

144 Eric

Brown

6

147

09

700

2

151 Cindy

13

2

Mark

5

154 Annette

155

9

4

84

Beverly

Mark

5

299

Michael

02

Jack

34

David

76

Bill

Smith

170

6

Michael

174

Paul

94

176 Kim

177

34

178 Jennifer

85

179

8585

180

181

335

182 Susan

26

184 Jim

86

185 John

63

188 Robert

101

Jennifer

90

190 Jeff Bradley

996

191

6

Smith

r

Mark

2050

15

Ray

29

Paul

199 Greg

33

200 John

8

Don

2

Jeff

9277

204 Christopher

205

Jack

207

5

208

0

211 Kelly

23

212

977

Jennifer

214

2

215 Mark

Robert

Bailey

218

220

Wilson

6977

222 Ed

09

223 Bob

224

225

80

226

Spence

00

227 David

228 Diane

337

229 Richard

24

230 Cynthia

55

Kelly Wining

232

233 Richard

0

235

00

236 Janet

237

238

70

239 Myron Cramer

240

Jones

00

Robert

15

243

244

245

6930

246 Larry

247

52

248

7

249 James Warden

250

55

251

2

535

253

254 Stephen

255

00

256 Mark

00

258

2400

259 Paul

260 Paul

990

Bob

262

263

264

Jones

14342

265 Douglas

Michael

267

0

268

269 Diane

270 Becky

271

Cole

272

Brown

273

274 Stephanie

Christopher

88

276 Jeff

277

278

Kelly

222

280 Richard Harris

14

Elliott

3

James

000

285 Jim

286

0

287

000

288

2

293

Richard

295

296 Janet

5

297

298

356

299

300

Mary

Kevin

303 Marty

John Curry

062

305 Mark

Rodney

266

Gary Martin

63

Mary

309

Matthew

311

00

312

313 Tim

7

314 John

316 Ryan

3

317

Smith

318 Shane

319 Sarah

320

00

321

322

323 Michael

324 Jack Coughlin

325

326

1

327

328 Carter

330

331

Clough

332

Wilson

333

334 Charles

335

6401

336 Beverly

337 Jennifer

0

4

49

Joe

341

342 Teresa

343 Richard

1

Laura

2

Stephen

Juan

03

349 Christina

90

Jones

Charles

353 David

354

9120

356

357

358 Tony Sanders

360

5434

361 Patrick Hill

362 Paul

363 Bill

364

365 Mike

366

2

367

368

8553

369 Matt

371

Kevin Scott

Duncan

564

375 Raymond

378

Steve

380

381

382

383 Brad

384 Kevin

385 Robert

386 Katie Hahn

387

388

389

390

Don

Kelly

8327

394

395

Greg

398

399

5185

400

401

James

403

405

406 James

20

408

Cowden

409 Kenneth

410

411

Darcy

412

413

415

3000

418 Dianne Finn

419 Jack

Tim

421

422 David

Stephen

424 Aileen Huynh

Sherri

426

Russell

430

Stephens

431

432

433 Tom

434 Sonja

436 Barry

David

439

441 Bonnie

442

Robert

444 James

445 Randy

446

447 Gary

448 Mary

449 Robin

man

450 John

451

Barbara

454 John

455

456 John

457 David

458 David

459 Janice

Kate

Richard

Ryan Helvie

Tony

465

Coughlin

Annette

469

Elliott

470 David

471

472

Hugo

474 James

475

Stephen Chellis

477 Robert

479 Mark Bearde

Susan

481

482

Scott

9

484

Blake

485 Bill

486 Edward

Tom

488 John

489 Mike

490

491 Sharon

0

492 Ryan

Daniel

494

Steph

David Ali

498 Richard

499 Kevin

500

Jessica

James

503

505 Jim Johnson

506

507 Holly

Cindy

509 Deborah

510 Gary Hart

511

Bui

512 Nathan

513 Beverly

515

Coughlin

516

Jacob	Boggs	5557	222	27
Tong	Shofstall	55	54	32
								Richard	Mccormack	555722	38
		Bob	Avelluto	555	36	34
Anthony	Hagen	555	80	92
Beckmann	555	236	322
		Patrick	Bijon	555	43	125
Eva	Mollison	5554	323	112
										Michael	Scheuerman	55538	45
Jonathan	Chestnut	555	67	44	88
Cassandra	Remley	5552	369	29
	Dianne	Schowengerdt	555	384
		Steve	Joslin	555722	46	78
				Stephen	Wetzer	5558	314	50
										Robert	Schmitt	555	432	35
Brod	5557	89
	Deborah	55583	131
	Bradley		Washington	555	232	224
	Christina	Thompson	5556777778
	Patricia	Vargas	5558	94	76
		Slade	55543	270
							Mark	Wirth	555384	121
Laird	Horn	5553	81	48
Randall	Pedrotti	555	471	51
	Aileen	Magnus	55536	204
	Brent	Morris	55526	212	79
28	Dago	Breshears	55572	223
		Scott	Schumacher	5557222	117
30	Glen	Griffith	55579519	68
Mcmullen	555	362	86
Irwin			Wilson	555	75	418
Melissa	Dean	55567	73
Bennink	555677	507
Robb	Schroff	555384	126
		Don		Hahn	55538	419	91
		Kim	Keith	555	254	147
		Greg		Ray	555432	208
Stuart	Maher	55567	188
5557	226	90
	Joe		Bearde	5553845	99
	Juan	Mitchelson	55583	124
Helen		Blake	555722	200
	Charlene	Cummings	555432	230
			Gary	Nelson	5554	321	97
Becker	5557	225	500
			James	Lomshek	55543	238
			Jim	55536	297	98
		Cindy	Kahn	55526	243
			Eric	Underwood	555831	240
	Daniel	Gardner	5555	506
		Diane	Lynch	55572	264
										David	Wright	55526	239
	Sonja	Phillips	555	262
Amy	Peavler	55572	255
										John	Gross	55540	385
Lois						Coughlin	5556770566
		Brad	Nalls	55543	299
					Jennifer	Dickinson	5556	485	135
	Katie	Felten	555536	178
Timothy				Jones	5552	367
Roger		Hugo	5552623	274
63						Jeff	Humphrey	555	305	434
	Ali	Honn	5557637	211
Don	Margaris	5552622	141
Stacie	Liebert	55536	259
Chad	Eddy	5551	118
Meloney				Smith	55526	244
Phil	Alejos	5552367	333
	Gregg	Taylor	55540	398
	Bruce	Carver	5554	320
Mignon	Schoonover	5552620	154
Alex		Johnson	5553	220
			Beverly	Sailors	5557	134	400
Roy	55536	295
	Anne	Andrews	5554320	127
		Susan	Helock	555384	100
Kipp			Brown	55526	228
	Kenneth	Fitzmaurice	5553843	87
	Douglas	Adair	555262	303
			Tim	Dalen	5552	368	181
Betty	Janich	555	378	190
Rocky	Mcclung	55572	269
Christine	5558	318	180
Michelle	Boyle	555	439	110
Surendra	Norsworthy	555384	140
Meyers	5558	272
Burkhead	55567	185
		Tom	Allen	55526	298
			Charles	Loper	55548	132
Warren	55583	144
				James	Rodman	555262	383
Banker	5554	327
Shandi	Sull	5552	365	335
		Janet	Hosterman	5553620007
96	Daniels	55543	288
Corby	Casey	555	248
Woods	555677	336
Rattay	55540	300
Kamyar	Bryner	55526	273
101				Becky	Herrington	5556770025
102	Ben	Walsh	555	207	106
103	Hatfield	5558903980
104	Ephland	555384	258
105				Bill	Quinn	5556776633
Chris	Hansen	5555662723
107	Paschal	555362	390
108	Snodell	55526	218
109		Raymond	Kring	5554	325	182
Kathi	Hanf	55538	139
		Christopher	Becsei	555262	115
Troy	55538	410
113	Stricklin	555262	245
114	Asher	Wu	5554322075
Sloss	5556761113
116		Wining	55543	285
Shin	5553841006
Brill	555362	251
119	Alton	Nguyen	5553621800
120	Anderson	5554321	174
Aurangzeb	Addison	5552623	151
123		Edward	Keaton	555327	191
	Laura	Spore	5553841005
	Ed	O’Donnell	5553841004
Danny	Ourada	55543	277
Solorio	5553841003
128			Annette	Jatta	55526	215
129	Sandra	5552	364
130		Cole	5553841002
Lapple	555	387	356
Hayhow	555831	177
133		Matthew	Cattaneo	555432	380
Cathy	Baumgartner	5553841001
				Kelly	Nikoomanesh	5559627767
136	Loomis	555384	337
137	Humphreys	5558	311
138		Stephanie	Porter	555384	280
William	5557222800
Rupinder	Langworthy	55567	176
Kaseff	5554323832
142	Pete	Dhillon	5556770022
143	Harold	Heuback	5557	227
Caster	5556777005
145	Wilaiporn	Gingerich	5556771364
146		Matt	555770	450
		Tony	Donaway	55583	179
148		Larry	Young	5558	317
149	Alejandro	Buch-Gm	555384	334
150					Jack	Rawoot	5553627	155
Simpson	55576	170
152		Janice	Ceo	555831	415
153	Ye	555831	205
	Bailey	5554323000
	Bonnie	Fuchs	555262	278
156	Lynn	Willingham	555236	474
157	Neil	Riggs	55526	214
158	Twyman	5552622323
159	England	555722	250
160	Karla	Legler	5558	515
161	Frazee	55559	184
162	Sirinph	55572	233
163		Barbara	Lewis	5556655565
164	Taylor Routh	5552629860
165	Werner	Karlson	5558272385
166		Sherri	Byrd	5557898778
167	Xue	Chilson	55543	276
168	Quint	5552627	263
169	Asif	5557220799
Pam	Lander	555	268	446
171	Laclaire	5556600995
172	Jude	Giger	5552621230
173						Paul	Carter	5557899595
Carmen	Foster	5558107757
175	Reagan	55538	494
Hoover	5554320020
Joanie		Sanders	55536	287
Evans	55580	401
Densie	Shoemaker	555	403
	Rodney	Moore	5556771010
Bethany	Frazier	5554	326
Hayes	55538	491
183	Bernadette	Hutteger	5552368	265
Michaelis	55538	409
Breslow	5554327000
186	Vanessa	DaSilva	5552627060
187		Randy	Shaw	55567	296
Watkins	5554	386
189	Ruperto	55587	199
5558	312
Ricardo	Pate	555	389	451
192	Wood	5553843	366
193	Rick		Spence	5554038900
194	Owen	555	381
195	Maureen		Curry	5558317300
196	Fair	Courtney	55526	267
197	Andy	55534	256
198	Sandler	5552364	433
Vanderhoof	55543	235
	Finn	555236	512
201		Shane	555432	360
202	Michaela	Boothe	5556491776
203		Warden	555	509
Knopp	5556657156
Kenny	Hinz	5553629690
206	Orlando	5555992020
Gwyneth	Jennings	555831	455
Travis	Wun	555	492	253
209					Kevin	Olson	5559816500
210	Leland	Dutcher	5558311119
Thiede	55545	271
			Ryan	Marquette	5558	510
213	Portell	5556771550
Suzanne		Martin	555322	399
Kreka	5556	237	249
216	Cobble	5552622	430
217	Lisa	5557222222
Sandy	Segura	5552628858
219	Pedro	Frye	5552055212
	Cynthia	555	456
221	Chuck	Vandyke	5554038136
Heley	55594	229
Kaspare	5557220104
Oscar	Meeker	5553629777
			Mary	Leiker	55543	247
Beckie	55574	436
Rodenburg	5556456652
	Stephens	5558	316
Cooper	55551	431
Duckers	55538	445
231	5556718	371
	Russell	Sweeney	5553840058
Pedroza	5552368547
234	Iris	Gillette	555262	260
	Myron	Wiber	55540	395
French	5552626555
Dawn	Rios	5557899600
Olivia		Cramer	55538	457
5554038000
So	5557897600
241	Tammy	Hogarty	55582	516
242	Engel	55543	246
Darrell	Kavanaugh	5552368988
Kathleen	Oliver	5557803166
Donaldson	R Blessing	555	363
Lostal	5554150771
Linda	Thornhill	55543	313
Blake	Chertoff	555	361	286
5552432150
	Teresa	Westphal	55572	293
	Darcy	Co Inc	555636	309
252	Hennessy	5559	489
Ruth	Kriske	5554326951
Pavicic	5552	342	444
Jerry	Nitcher	55599	349
Davis	55568	481
257	Kirk	Klein	5559069991
Mickey		Harris	555	479
Suzie	5558149444
Vunovich	5559	426
261	Ragland	5553620711
		Mike	Cross	5556474300
Tina	Mcinerney	5554	324	447
		Elliott	55	511
Cardozo	5555238	331
266	White	5552627733
	Jessica	Slinker	555632	330
Mia	Stryker	5556383	490
Stoker	5553871825
Mcroy	5559678599
Martha	5558251200
Andrew	5552623630
Les	Andachter	5553841000
Fulks	5552622220
275	Roth	55540	388
Ginn	5558073212
Sumya	Shamet	5554323270
	Robin	Peterson	5552223333
279	Alonso	5553	332
5556779000
281	Cheri	Scanlon	55538	411
282	Fawcett	555677	454
283	Penny	5553121055
284	Elizabeth	Thieme	5558	319
Hanson	5552622664
Graham	Crabtree	555722	422
Georgia	Teters	5559	488
Raul	Anani	5559610621
289	Kalin	Moyer	555384	469
290	Emilee	Pickford	5557109696
291	Cole	Abbott	5553179204
292	Megan	Pfanmiller	5555889040
Allen	Parton	5552627722
294	Sullivan	5558319100
Brandon	Welch	5555226474
Furnell	555432	405
Hien	Zuber	5559400207
Patrica		Huynh	5557	357
	Marty	Cottrell	5552369016
	Sarah	Hopkins	5556771920
301	Laughman	5553627921
302	Mccracken	5552624500
L Bozman	5554324719
304	5556	482
Hinckle	5555291130
306	O’conner	5554	328
307	55538	458
308	Glover	5552620606
Dongsoo	Cunningham	5554011494
310	Vitug	5557899594
Paco		Hill	55596	394
Dale	Dexter	5558317701
Lee	555	484	408
Mccullough	5553844446
315	Fatoumata	Valentine	5558313100
Benben	555262	448
Trevor	5558316701
Griffin	5558311150
Clapp	5558310711
Calvin	Wilkison	55538	441
Valerie	Thibodo	5552819800
	Carter	Fitzsimons	5557221146
	Clough	5552360020
5556774	343
Audra	Kochuyt	5553620122
Shaun	Fleming	555384	459
Kirby	Kilburn	5552686822
Kennedy	5554323	341
329	Rita	Karr	5557899100
Sara	Boldt	5552366801
Julie	5556717099
Deanna	5557897684
Crystal	Koron	5555991010
Sauls	5555574000
Jason	Bachand	555	449
Blakely	5556775	375
	Duncan	555252	505
338	George	Woodbury	555708	412
339	Miguel	Ayotte	55563	354
340	Morales	5554320800
Frank	Bircher	5556775	465
Wang	5557222000
Azorsky	5552552200
344	Bryan	Golden	555371	413
345	Luce	555831	475
346	Rhonda	Stewart	5556028710
347	Calwell	5552329610
348	Scheck	55595	353
Balock	55596	358
350	5556718290
351	Riddle	5552079209
352	Jaci	Laurie	5556267670
Guy	5556341057
Gabriel	Bishop	5552196644
355	Marcai	Matthews	555	424
Zach	Kornitzer	5555351000
Lori	Sheets	5555153271
5556771400
359	Sean	Suggs	5552621991
Gayle	Gilbert	555	421
5559409190
Milliken	5554326690
Perkins	5558310265
Cristy	Jabr	5557890997
Fanska	5552689557
Se	Wohlert	555831	442
Pamela	Shelby	5552629700
Amber	Bowman	555	406
Clifford	5557758585
370		Steph	Mahaney	5553625611
Jenny	Jackobile	5557877899
372	5557220055
373	Todd	5554	382
374	Dan	Gomez	5554030033
Lykins	5552368200
376	Zi	Wheeler	5552626001
377	Carla	D Brandom	5552366886
Tyson	Kalen	5553629292
379	Pope	5556771633
Pesharaw	Clark	5554811964
Tyler	Barzinj	5554030073
Lora	Choikhit	5558259961
Berman	5552135238
Overton	5553815400
Kreger	5553817305
5553059	470
Danielle	Mcghee	55566202
Stewart	Reno	5554410911
Sturgeon	5556719788
Kristi	Leon Carter	5558945163
391	Rustin	Elic	5553629898
392	Switzer	5552319695
393	Cronin	555	499
Phyllis	Kumar	5559933300
Leah	Davee	5558319977
396	Atlas	5554321724
397	Ned	Romero	5554247426
Nick	Deffenbaugh	5552627075
Ron		Cowden	555	486
Fred	Wilkinson	5554998326
Beth	Stannard	5556386448
402	Estreda	5558852739
Marla	Babcock	5558313131
404	Rachelle		Helvie	5558310631
Orville	Guglielmino	5559400383
Bartko	55523	472
407		Barry	Dupree	5556600700
	Holly	5552449290
Starr	5556415588
Connie	Pigg	5552625858
Teri	5553020794
Mario	Aalders	5554320055
Al	Carmony	5553810372
414	Jane	Gass	5557220100
Thomas	Schloss	5553279658
416	Lavonne	Schultze	555	498
417	Jill	Bennett	5556775854
5556815655
Hogerty	5553691550
420	Wohletz	5555303018
Brian	Meis	5554320101
Felman	5554325348
423	Genova	5552364059
5553848997
425	Atchis	5554321111
Clifford	Fisher	5557226816
427	Clarence	5557229300
428	Scott		Chellis	5556868395
429	Rachael	Gonzalez	5558636999
Lucy	5553622107
Farhad	Sheil	5557899639
Corey	Parvatti	5553628282
Singh	5552680352
Piva	5556956958
435	Ranj	Shultheis	5553090286
G Smith	5556484424
437		Kate	Burchfiel	5552623937
438	Lavender	5557225615
Deborh	Hull	5552622900
440	Vonda	Belanger	5552622434
Hollinger	5555795167
Ashlie	Copeland	5552188850
443	Sturtridge	5559145705
Grady	5553622775
Tummous	5552573437
Ashley	Wolfe	5558318188
Noland	5556773477
Locklear	5557223253
	Hart	5557897730
Hey	5553628830
Phillip	Denzer	5557806143
452	Kenney	5557417997
453	Kathy	Sauvan	5558311387
Guerra	5557899977
Geoffrey	Hamil	5556313300
Ross	5554321040
Palmgren	5552621000
Woolridge	5552369075
Rojjanaspirat	5556772688
460	Kozeta	Gelles	5552365395
461	Stuteville	5553623950
462	Bonsal	5553840726
463	5557225410
464	Haley	5554323104
Amit	Keeny	5552624744
466	Roberto	Fears	5559823708
467	Orlando	5557224332
468	Lujan	5556342674
Lawrence	5552622017
Gauna	5556349814
Janene	Coons	5553845423
Theresa	Raizada	5553627171
473		Sharon	5552365318
Dowgray	5557226500
Mabel	Geren	5552565221
476	5558311609
Oakley	5553623663
478	Donna	Erickson	5554329100
5557226105
480	Willits	5553624242
	Nathan	Deterding	5556718199
Carol	555278	513
483	Debbie	Crowell	5555454747
Lynda	5556773353
Postlewait	5554326057
Sandoval	5554322887
487	Benson	5552626213
Richardson	5557226606
Owens	5554328408
Angel	Everett	5552363090
Mosby	555236	503
Holtgrewe	5556997999
493	Fullerton	5554328827
Chrissy	Delich	5554326008
495	Poptsis	5558311244
496	5557221700
497	Martin	Pesch	5556774293
Eslinger	5558312617
Schneider	5557224300
Angela	Kremers	5553842229
501	Mohler	5556667777
502	Akers-Phillips	5556770305
Craig	Timmerman	5558311684
504	Dave	Duggan	5554327260
5553625683
Garry	Savage	5554445555
Staudt	5552612269
508	Verdi	5554323667
Peck	5553057559
5553399104
Janel	5552627564
Barry-Mayer	5552223334
Runyan	5553845511
514	Milton	Waters	5554322583
Jamie	5556772555
Leonardo	Eagan	5551118887
517	Camilla	Escobar

SELECT [Industries].[Industry]
FROM Industries
ORDER BY [Industry];
PARAMETERS __JobSeekerID Value;
SELECT DISTINCTROW *
FROM Applications AS JobSeekerEntry
WHERE ([__JobSeekerID] = JobSeekerID);
SELECT [Industries].[Industry]
FROM Industries
ORDER BY [Industry];
SELECT [Industries].[Industry]
FROM Industries
ORDER BY [Industry];
SELECT DISTINCTROW *
FROM Companies;
SELECT DISTINCTROW *
FROM Jobs;
SELECT DISTINCTROW *
FROM Companies;
SELECT [Companies].[CompanyName], [Companies].[Industry], [Jobs].[JobID], [Jobs].[JobTitle], [Jobs].[StartingSalary], [Jobs].[Company], [Jobs].[PostingDate], [Companies].[CompanyID]
FROM Companies INNER JOIN Jobs ON [Companies].[CompanyID] =[Jobs].[Company];
SELECT [Companies].[CompanyName], [Companies].[Industry], [Jobs].[JobID], [Jobs].[JobTitle], [Jobs].[StartingSalary], [Jobs].[Company], [Jobs].[PostingDate], [Companies].[CompanyID]
FROM Companies INNER JOIN Jobs ON [Companies].[CompanyID] =[Jobs].[Company];
SELECT DISTINCTROW *
FROM JobSeekers;
SELECT JobSeekers.JobSeekerID, JobSeekers.FirstName, JobSeekers.LastName, JobSeekers.Phone, Applications.ApplicationDate, Applications.JobID
FROM JobSeekers INNER JOIN Applications ON JobSeekers.[JobSeekerID] = Applications.[JobSeekerID];
SELECT JobSeekers.LastName, JobSeekers.FirstName, Jobs.JobTitle, Jobs.StartingSalary, Jobs.Company, Jobs.PostingDate, Applications.ApplicationDate
FROM JobSeekers INNER JOIN (Jobs INNER JOIN Applications ON Jobs.JobID = Applications.JobID) ON JobSeekers.JobSeekerID = Applications.JobSeekerID
ORDER BY JobSeekers.LastName, JobSeekers.FirstName;
SELECT Companies.CompanyID, Companies.CompanyName, Companies.Industry, Companies.HRContactFirstName, Companies.HRContactLastName, Companies.HRContactPhone
FROM Companies
ORDER BY Companies.CompanyName;
SELECT JobSeekers.LastName, JobSeekers.FirstName, Jobs.JobTitle, Jobs.StartingSalary, Companies.CompanyName, Applications.ApplicationDate
FROM JobSeekers INNER JOIN ((Companies INNER JOIN Jobs ON Companies.CompanyID = Jobs.Company) INNER JOIN Applications ON Jobs.JobID = Applications.JobID) ON JobSeekers.JobSeekerID = Applications.JobSeekerID
WHERE (((Jobs.JobTitle) Like “*Director*”) AND ((Applications.ApplicationDate)>=#9/1/2018#));
SELECT [FirstName] & ” ” & [LastName] AS StudentName, [_GradingReport].ProjectName, “Submission #” & [SubmissionNum] AS SubmissionCt, [_GradingReport].Score, [_GradingReport].MaxScore, “Score is: ” & [Score] & ” out of ” & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & “. ” & [Description] AS Step, [_GradingReportSteps].[StepScore] & “/” & [_GradingReportSteps].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingIcons].GA_Status_Icon, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingIcons].SAM_Logo, [_GradingReportSteps].Description, [_GradingReport].EngineVersion
FROM _GradingReport, _GradingIcons INNER JOIN _GradingReportSteps ON [_GradingIcons].[IfSuccessful_Status] = [_GradingReportSteps].IfSuccessful;
SELECT Companies.CompanyName, Companies.Industry, Jobs.JobTitle, Jobs.StartingSalary
FROM Companies INNER JOIN Jobs ON Companies.CompanyID = Jobs.Company
WHERE (((Jobs.StartingSalary)>=50000));
SELECT Companies.Industry, Companies.CompanyName, Jobs.StartingSalary
FROM Companies INNER JOIN Jobs ON Companies.CompanyID = Jobs.Company;
SELECT Companies.CompanyName, Companies.Industry, Jobs.JobTitle, Jobs.StartingSalary
FROM Companies INNER JOIN Jobs ON Companies.CompanyID = Jobs.Company
WHERE (((Jobs.StartingSalary)>=50000));
SELECT JobSeekers.JobSeekerID, JobSeekers.FirstName, JobSeekers.LastName, JobSeekers.Phone
FROM JobSeekers
ORDER BY JobSeekers.LastName;

Support_AC19_CS5-8a_StateProvs

Washington

StateName	StateAbbrev	Capital
Alaska	AK	Juneau
Alabama	AL	Montgomery
Arkansas	AR	Little Rock
Arizona	AZ	Phoenix
California	CA	Sacramento
Colorado	CO	Denver
Connecticut	CT	Hartford
	Washington	DC
Delaware	DE	Dover
Florida	FL	Tallahassee
Georgia	GA	Atlanta
Hawaii	HI	Honolulu
Iowa	IA	Des Moines
Idaho	ID	Boise
Illinois	IL	Springfield
Indiana	IN	Indianapolis
Kansas	KS	Topeka
Kentucky	KT	Frankfort
Louisiana	LA	Baton Rouge
Massachusetts	MA	Boston
Maryland	MD	Annapolis
Maine	ME	Augusta
Michigan	MI	Lansing
Minnesota	MN	St. Paul
Missouri	MO	Jefferson City
Mississippi	MS	Jackson
Montana	MT	Helena
North Carolina	NC	Raleigh
North Dakota	ND	Bismarck
Nebraska	NE	Lincoln
New Hampshire	NH	Concord
New Jersey	NJ	Trenton
New Mexico	NM	Santa Fe
Nevada	NV	Carson City
New York	NY	Albany
Ohio	OH	Columbus
Oklahoma	OK	Oklahoma City
Oregon	OR	Salem
Pennsylvania	PA	Harrisburg
Rhode Island	RI	Providence
South Carolina	SC	Columbia
South Dakota	SD	Pierre
Tennessee	TN	Nashville
Texas	TX	Austin
Utah	UT	Salt Lake City
Virginia	VA	Richmond
Vermont	VT	Montpelier
WA	Olympia
Wisconsin	WI	Madison
West Virginia	WV	Charleston
Wyoming	WY	Cheyenne
Alberta	AB	Edmonton
British Columbia	BC	Victoria
Manitoba	MB	Winnepeg
New Brunswick	NB	Fredericton
Newfoundland and Labrador	NL	St. John’s
Northwest Territories	NT	Yellowknife
Nova Scotia	NS	Halifax
Nunavut	NU	Iqaluit
Ontario	ON	Toronto
Prince Edward Island	PE	Charlottetown
Quebec	QC	Quebec City
Saskatchewan	SK	Regina
Yukon	YT	Whitehorse