Illustrated Access 2019 | Modules 1-4: SAM Capstone Project 1a Midwest Executive Professionals Illustrated Access 2019 | Modules 1-4: SAM Capstone Project 1a Improve a

Illustrated Access 2019 | Modules 1-4: SAM Capstone Project 1a Midwest Executive Professionals Illustrated Access 2019 | Modules 1-4: SAM Capstone Project 1a Improve a database by creating and modifying tables, queries, forms, and reports Open the file , available for download from the SAM website. Save the file as 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_CS-1-4a_Industries.xlsx Open the 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 manage and analyze companies, jobs, applicants, and job placements facilitated by your company. In Design View of the table, modify the table with the following instructions: Add a new field after the field named with a data type. Use to rename the field. Save and close the table. In Datasheet View of the table, complete the following instructions: Delete the record for ( ). Edit to be for . Enter a new record into the table using the information in Table 1. Close the table. Table 1: New Record for JobSeekers Table In the Navigation Pane, make the new name for the table. Use the import wizard to append the records from the to the table. Do not save the import steps. ( : If a warning message appears, Click .) Create a new table in Table Design View with the following specifications: Enter as the name of the new table. Add a new field named with the data type. Set it as the field. Add two new fields named and in the order shown. They should have the data type and field size properties of . Add a new field named with the data type. Set the Required property to . Add a new field named with the data type. Set the Default Value property to . Add a new field named with the data type. Update the Input Mask property using the Input Mask Wizard. Select the Extension input mask and update the field to , so that is the final input. Accept the default in the last window. Save the table and then close it. In Datasheet View of the table, complete the following options: Delete the field. ( : It currently does not have any data.) Move the field to be the last field in the datasheet. Sort the records in order by . Save and close the table. Create a new query in Design View using the and tables with the following options: Select the and fields from the table and the and fields from the table. Join the tables using the field from the table and the field from the table. Save the query, using as the name. With the query still open in Design View, add criteria to select only those records where the is , save the query, switch to Datasheet View as shown in Figure 1, and then close it. Figure 1: HighSalaries Query in Datasheet View Use the Simple Query Wizard to create a new query with the following options: Use the and tables. Select all four fields from the table and the field from the table. Create a detail query. Use as the title for the query. Save and close the query. In Design View of the query, modify the query with the following options: Add criteria to select all records with or as the . Sort the records in order by , and then by . Run the query to display it in Datasheet View as shown in Figure 2, and then save and close it. Figure 2: ApplicationListing Query in Datasheet View In Design View of the query, add criteria using wildcard characters to select all records with anywhere in the field and an . Run the query to display it in Datasheet View as shown in Figure 3, and then save and close it. Figure 3: DirectorSeptember Query in Datasheet View Use the to create a new form with the following options: Select all of the fields from the table. Choose a layout. Use as the title. Save and close the form. Use the to create a new report with the following options: Select all of the fields from the table. Group the records by . Sort the records in order by . Use a layout and a orientation. Use as the title. Preview, save, and close the report. Open the form in Form View, enter as the value for the first record to replace , and then add a new record in the main form with the information in Table 2. Table 2: New Record for JobSeekerEntry Form Open the form in Layout View and modify it with the following options: Right-align the text in the , , and labels. Edit the label to read and use to rename the label. Delete the command button in the Form Footer section. With the form still open in Layout View, modify it with the following options: Add the field to the form and position it just below the label. Change the font color for the label to . Apply a quick style, (first 1st row second 2nd column of Theme Styles gallery) to the command button in the Form Header section. Display the form in Form View as shown in Figure 4, and then save and close it. Figure 4: JobSeekerEntry Form in Form View Open the report in Layout View and add conditional formatting so that any value is formatted using (7th column, 4th row in the Standard Colors pallete). Save the report. With the report still open in Layout View, modify it with the following options: Change the background color of the label in the Page Header section to the same color, (7th column 4th row in the Standard Colors palette). Group the two labels in the Report Header section together in a tabular layout. Save and display the report in Report View as shown in Figure 5, and then close it. Figure 5: JobListing Report in Report View In Layout View of the report, modify it with the following options: Change the Theme Colors to Change the Theme Fonts to . Display the report in Report View as shown in Figure 6, and then save and close it. Figure 6: JobSeekerListing Report in Report View 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.

Do you need us to help you on this or any other assignment?


Make an Order Now