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 |
IfSuccessful | GA_Status_Icon | SAM_Logo | |||||
---|---|---|---|---|---|---|---|
true | |||||||
false |
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 |
ProjectName | SubmissionNum | Max | Score | EngineVersion |
---|
StepNumber | Description | StepScore | StepMaxScore | ErrorText | ActionName | StepActionOrder |
---|
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 |
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 | Salary | Extension |
---|
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 |
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 |
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
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 |