{"id":7428,"date":"2021-10-13T03:53:06","date_gmt":"2021-10-13T03:53:06","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/access-2019-project-due-tomorrow-night\/"},"modified":"2021-10-13T03:53:06","modified_gmt":"2021-10-13T03:53:06","slug":"access-2019-project-due-tomorrow-night","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/access-2019-project-due-tomorrow-night\/","title":{"rendered":"Access 2019 project due tomorrow night"},"content":{"rendered":"
\n

Illustrated Access 2019 | Modules 1-4: SAM Capstone Project 1a<\/p>\n

Midwest Executive Professionals<\/p>\n

Illustrated Access 2019 | Modules 1-4: SAM Capstone Project 1a<\/p>\n

Improve a database by creating and modifying tables, queries, forms, and reports<\/p>\n

GETTING STARTED<\/strong><\/h2>\n

Open the file IL_AC19_CS1-4a_<\/strong>FirstLastName<\/strong><\/em>_1.accdb<\/strong>, available for download from the SAM website.<\/p>\n

Save the file as IL_AC19_CS1-4a_<\/strong>FirstLastName<\/strong><\/em>_2.accdb<\/strong> by changing the \u201c1\u201d to a \u201c2\u201d.<\/p>\n

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.<\/p>\n

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

Support_AC19_CS-1-4a_Industries.xlsx<\/p>\n

Open the _GradingInfoTable<\/strong> 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.<\/p>\n

PROJECT STEPS<\/p>\n

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 Design View of the Applications<\/em> table, modify the table with the following instructions:<\/p>\n

Add a new field after the ApplicationDate<\/em> field named FollowupDate<\/strong> with a Date\/Time<\/strong> data type.\u00a0<\/p>\n

Use ApplicationID<\/strong> to rename the ID<\/em> field. Save and close the Applications<\/em> table.<\/p>\n

In Datasheet View of the JobSeekers<\/em> table, complete the following instructions:<\/p>\n

Delete the record for Richard Marlay<\/em> (JobSeekerID 14<\/em>).<\/p>\n

Edit John<\/em> to be Jonathan<\/strong> for JobSeekerID 10<\/em>.<\/p>\n

Enter a new record into the table using the information in Table 1. Close the JobSeekers<\/em> table.<\/p>\n

Table 1: New Record for JobSeekers Table<\/p>\n

JobSeekerID<\/em><\/p>\n

(AutoNumber will automatically number this field)<\/strong><\/p>\n

FirstName<\/em><\/p>\n

Leonardo<\/strong><\/p>\n

LastName<\/em><\/p>\n

Eagan<\/strong><\/p>\n

Phone<\/em><\/p>\n

5551118887<\/strong><\/p>\n

In the Navigation Pane, make Industries<\/strong> the new name for the Categories<\/em> table.<\/p>\n

Use the import wizard to append the records from the Support_AC19_CS-1-4a_Industries.xlsx<\/strong> to the Industries<\/em> table. Do not save the import steps. (Hint<\/em>: If a warning message appears, Click Open<\/strong>.)<\/p>\n

Create a new table in Table Design View with the following specifications:<\/p>\n

Enter Employees<\/strong> as the name of the new table.<\/p>\n

Add a new field named EmployeeID<\/strong> with the Number<\/strong>data type. Set it as the Primary<\/strong> key<\/strong> field.<\/p>\n

Add two new fields named EmployeeFirst<\/strong> and EmployeeLast<\/strong> in the order shown. They should have the Short<\/strong> Text<\/strong> data type and field size properties of 20<\/strong>.<\/p>\n

Add a new field named Email<\/strong> with the Hyperlink<\/strong> data type. Set the Required property to Yes<\/strong>.<\/p>\n

Add a new field named Salary<\/strong> with the Currency<\/strong> data type. Set the Default Value property to 45000<\/strong>.<\/p>\n

Add a new field named Extension<\/strong> with the Short<\/strong> Text<\/strong>data type. Update the Input Mask property using the Input Mask Wizard. Select the Extension input mask and update the field to 9999<\/strong>, so that 9999;;_<\/strong> is the final input. Accept the default in the last window. Save the table and then close it.<\/p>\n

In Datasheet View of the JobSeekers<\/em> table, complete the following options:<\/p>\n

Delete the Comments<\/em> field. (Hint<\/em>: It currently does not have any data.)\u00a0<\/p>\n

Move the Phone<\/em> field to be the last field in the datasheet.<\/p>\n

Sort the records in ascending<\/strong> order by LastName<\/em>. Save and close the JobSeekers<\/em> table.<\/p>\n

Create a new query in Design View using the Companies<\/em> and Jobs<\/em> tables with the following options:<\/p>\n

Select the CompanyName<\/em> and Industry<\/em> fields from the Companies<\/em> table and the JobTitle<\/em> and StartingSalary<\/em>fields from the Jobs<\/em> table.<\/p>\n

Join the tables using the CompanyID<\/em> field from the Companies<\/em> table and the Company<\/em> field from the Jobs<\/em>table.<\/p>\n

Save the query, using HighSalaries<\/strong> as the name.<\/p>\n

With the HighSalaries<\/em> query still open in Design View, add criteria to select only those records where the StartingSalary<\/em> is greater than or equal to 50000<\/strong>, save the query, switch to Datasheet View as shown in Figure 1, and then close it.<\/p>\n

Figure 1: HighSalaries Query in Datasheet View<\/p>\n

Use the Simple Query Wizard to create a new query with the following options:<\/p>\n

Use the JobSeekers<\/em> and Applications<\/em> tables.\u00a0<\/p>\n

Select all four fields from the JobSeekers<\/em> table and the ApplicationDate<\/em> field from the Applications<\/em> table.\u00a0<\/p>\n

Create a detail query.<\/p>\n

Use ApplicationDates<\/strong> as the title for the query. Save and close the query.<\/p>\n

In Design View of the ApplicationListing<\/em> query, modify the query with the following options:<\/p>\n

Add criteria to select all records with Administrative Assistant<\/strong> or User Support Director<\/strong> as the JobTitle<\/em>.\u00a0<\/p>\n

Sort the records in ascending<\/strong> order by LastName<\/em>, and then by FirstName<\/em>. Run the query to display it in Datasheet View as shown in Figure 2, and then save and close it.<\/p>\n

Figure 2: ApplicationListing Query in Datasheet View<\/p>\n

In Design View of the DirectorSeptember<\/em> query, add criteria using wildcard characters to select all records with Director<\/strong> anywhere in the JobTitle<\/em> field and an ApplicationDate<\/em> greater than or equal to 9\/1\/2018<\/strong>. Run the query to display it in Datasheet View as shown in Figure 3, and then save and close it.<\/p>\n

Figure 3: DirectorSeptember Query in Datasheet View<\/p>\n

Use the Form Wizard<\/strong> to create a new form with the following options:<\/p>\n

Select all of the fields from the Jobs<\/em> table.\u00a0<\/p>\n

Choose a Columnar<\/strong> layout.<\/p>\n

Use JobsEntry<\/strong> as the title. Save and close the JobsEntry<\/em> form.<\/p>\n

Use the Report Wizard<\/strong> to create a new report with the following options:<\/p>\n

Select all of the fields from the Companies<\/em> table.\u00a0<\/p>\n

Group the records by Industry<\/em>.<\/p>\n

Sort the records in ascending<\/strong> order by CompanyName<\/em>.<\/p>\n

Use a Stepped<\/strong> layout and a Portrait<\/strong> orientation.<\/p>\n

Use CompanyListing<\/strong> as the title. Preview, save, and close the report.<\/p>\n

Open the JobSeekerEntry<\/em> form in Form View, enter Jacob<\/strong> as the FirstName<\/em> value for the first record to replace Jack<\/em>, and then add a new record in the main form with the information in Table 2.<\/p>\n

Table 2: New Record for JobSeekerEntry Form<\/p>\n

JobSeekerID<\/em><\/p>\n

(AutoNumber field will automatically increment)<\/strong><\/p>\n

FirstName<\/em><\/p>\n

Camilla<\/strong><\/p>\n

LastName<\/em><\/p>\n

Escobar<\/strong><\/p>\n

Open the JobSeekerEntry<\/em> form in Layout View and modify it with the following options:<\/p>\n

Right-align the text in the JobSeekerID<\/em>, FirstName<\/em>, and LastName<\/em> labels.\u00a0<\/p>\n

Edit the FirstName<\/em> label to read First Name<\/strong> and use Last Name<\/strong> to rename the LastName<\/em> label.\u00a0<\/p>\n

Delete the Close<\/em> command button in the Form Footer section.<\/p>\n

With the JobSeekerEntry<\/em> form still open in Layout View, modify it with the following options:<\/p>\n

Add the Phone<\/em> field to the form and position it just below the Last Name<\/em> label.\u00a0<\/p>\n

Change the font color for the Phone<\/em> label to Automatic (black)<\/strong>.\u00a0<\/p>\n

Apply a quick style, Colored Outline \u2013 Blue, Accent 1<\/strong>(first 1st row second 2nd column of Theme Styles gallery) to the Close<\/em> command button in the Form Header section. Display the form in Form View as shown in Figure 4, and then save and close it.\u00a0<\/p>\n

Figure 4: JobSeekerEntry Form in Form View<\/p>\n

Open the JobListing<\/em> report in Layout View and add conditional formatting so that any StartingSalary<\/em> value greater than or equal to $70,000<\/strong> is formatted using Green 3 background color<\/strong> (7th column, 4th row in the Standard Colors pallete). Save the JobListing<\/em> report.<\/p>\n

With the JobListing<\/em> report still open in Layout View, modify it with the following options:<\/p>\n

Change the background color of the Starting Salary<\/em> label in the Page Header section to the same color, Green 3<\/strong> (7th column 4th row in the Standard Colors palette).\u00a0<\/p>\n

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.\u00a0<\/p>\n

Figure 5: JobListing Report in Report View<\/p>\n

In Layout View of the JobSeekerListing<\/em> report, modify it with the following options:<\/p>\n

Change the Theme Colors to Green<\/strong> .<\/em><\/p>\n

Change the Theme Fonts to Franklin Gothic<\/strong>. Display the report in Report View as shown in Figure 6, and then save and close it.<\/p>\n

Figure 6: JobSeekerListing Report in Report View<\/p>\n

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.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

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 GETTING STARTED Open the file IL_AC19_CS1-4a_FirstLastName_1.accdb, available for download from the SAM website. Save the file as IL_AC19_CS1-4a_FirstLastName_2.accdb by changing […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-7428","post","type-post","status-publish","format-standard","hentry","category-homework-help"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/7428","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=7428"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/7428\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=7428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=7428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=7428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}