24 / 7 Live Support
support@helpinhomework.org
+44-7309655268
+91-9828671065
Midwest Executive Professionals
COMPLETING A DATABASE APPLICATION
GETTING STARTED
• Open the file NP_AC19_CS9-12a_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as NP_AC19_CS9-12a_FirstLastName_2.accdb by changing the “1” to a “2”.
o 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:
o Support_AC19_CS9-12a_StatesProvs.xlsx
• 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
1. 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 complete a database application by building advanced queries, macros, modules, and navigation forms.
Create a new query in Design View and complete the following:
a. Add all of the fields from the JobSeekers table to the query grid. You need to create a backup copy of the table at this point in time for use by another department.
b. Change the query into a Make Table query using JobSeekersBackup as the new table name.
c. Run the query to paste 400 records into the new table.
d. Save the query with the name MakeJobSeekersBackup and then close it.
2. Create a new query in Design View and complete the following:
a. Add all of the fields from the JobSeekersImport table to the query grid. This data was previously imported from an Excel spreadsheet maintained by a remote office and needs to be added to the JobSeekersBackup table.
b. Change the query into an Append query to the JobSeekersBackup table.
c. Run the query to append 115 records.
d. Save the query with the name AppendJobSeekers and then close it.
25 июн 2024
