Homework answers / question archive / New Perspectives Access 2019 | Module 6: SAM Critical Thinking Project 1c Global Human Resources Consultants Working With Form and Report Controls     GETTING STARTED Open the file NP_AC19_CT6c_FirstLastName_1

New Perspectives Access 2019 | Module 6: SAM Critical Thinking Project 1c Global Human Resources Consultants Working With Form and Report Controls     GETTING STARTED Open the file NP_AC19_CT6c_FirstLastName_1

MS Access

Share With

---

New Perspectives Access 2019 | Module 6: SAM Critical Thinking Project 1c

Global Human Resources Consultants

Working With Form and Report Controls

 

 

• GETTING STARTED

• Open the file NP_AC19_CT6c_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as NP_AC19_CT6c_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_CT6c_Logo.jpg
• 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. You work in the software division of Global Human Resources Consultants (GHRC), which sells modular human resources (HR) software to large international companies. For high-level planning purposes, you have created an Access database to track new clients, the HR software modules they have purchased, and the lead consultant for each installation. In this project, you will work with different form and report controls. You will also create a split form.
   
   Create a split form from the Consultant table. Save the form with the name ConsultantSplit, as shown in Figure 1, and then close it.

 

 

2. Modify the ClientEntry form by completing the following tasks:
   1. Change the record source for the form to the ClientSortedByName query.
   2. Change the tab order so that the ClientID field is in the first position in the Detail section.
      
      Save the ClientEntry form.
3. Still in the ClientEntry form, add a combo box by completing the following tasks:
   1. Position the new combo box below the existing ProjectStart text box at approximately the 2" mark on the horizontal ruler.
   2. Select the ConsultantID, FirstName, and LastName fields from the Consultant table for the combo box.
   3. Sort the records by the LastName field in ascending order.
   4. Hide the key column, and do not adjust column widths.
   5. Store the value in the ConsultantID field.
   6. Enter Consultant as the label for the combo box.
   7. Use the new combo box to select Sharilyn Sipes as the consultant for the first record (ClientID 15 Ainyx Steel).
      
      Save and close the ClientEntry form.
4. Modify the ConsultantSalary form by completing the following tasks:
   1. Add a check box control below the Current Salary text box and at approximately the 1.5" mark on the horizontal ruler.
   2. Set the Control Source of the check box to the ContractEmployee field.
   3. Use Contract Employee? as the accompanying label.
      
      Save and view the form in Form View, as shown in Figure 2, and then close the ConsultantSalary form.

 

 

5. Modify the CountryEntry form by completing the following tasks:
   1. Apply the Stacked layout to the controls in the Detail section.
   2. Expand the Detail section to be about 3" tall.
   3. Create a subform control using all of the fields from the Consultant table.
   4. Show Consultant for each record in Country using CountryCode.
   5. Use ConsultantsByCountry as the name of the subform.
   6. Position the subform just below the Country Name label at approximately the 0.5" mark on the horizontal ruler.
   7. Save and view the CountryEntry form in Form View, and then navigate to the third record (for Canada), as shown in Figure 3.
      
      Close the CountryEntry form.

 

 

6. Modify the SoftwareComponents form by completing the following tasks:
   1. Add a new text box to the form, and position it just below the Installation Fee label and text box at approximately the 1.5" mark on the horizontal ruler.
   2. Use Monthly Fee as the accompanying label.
   3. Use MonthlyFee as the Control Source property for the text box.
   4. Left-align the text in the text-box.
      
      Save the SoftwareComponents form.
7. Modify the SoftwareComponents form by completing the following tasks:
   1. Right-align the text in the labels in the Detail section.
   2. Right-align the right edges of the labels in the Detail section.
   3. Add a rectangle control around the four controls that identify the fees.
      
      Save the SoftwareComponents form.
8. With the SoftwareComponents form still open, insert the image from the Support_AC19_CT6c_Logo.png file found in the default folder to be used as a logo. Save and view the form in Form View, as shown in Figure 4, and then close the SoftwareComponents form.

 

 

9. Create a Multiple Items form based on the ClientSoftware table. View the form in Layout View, confirm that it matches Figure 5, and then save it, using ClientSoftwareMultiple as the name. Close the form.

 

 

10. Modify the CountryList report by completing the following tasks:
    1. Add a rectangle control around the two labels in the Page Header section.
    2. Change the shape fill of the rectangle control to Transparent.
    3. Add a horizontal line to the Report Footer section, just above the text box that calculates the count.
       
       Save and view the CountryList report in Print Preview, as shown in Figure 6, and then close it.

 

 

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.