Homework answers / question archive /    New Perspectives Access 2019 | Module 4: End of Module Project 1 Homestead Partners   Creating and Modifying Reports     GETTING STARTED Open the file NP_AC19_EOM4-1_FirstLastName_1

   New Perspectives Access 2019 | Module 4: End of Module Project 1 Homestead Partners   Creating and Modifying Reports     GETTING STARTED Open the file NP_AC19_EOM4-1_FirstLastName_1

MS Access

Share With

---

 

New Perspectives Access 2019 | Module 4: End of Module Project 1

Homestead Partners

 

Creating and Modifying Reports

 

 

• GETTING STARTED

• Open the file NP_AC19_EOM4-1_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as NP_AC19_EOM4-1_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.
• 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. Homestead Partners is a company that connects independent home owners with long-term renters. You work in the Customer Service Department of Homestead Partners as a data analyst. You are developing an Access database application to help manage and analyze several types of customer service data including property and property manager effectiveness.
   
   Create a new form using the Form Wizard based on all the fields in the Managers table. Use a Columnar layout, use ManagerEntry as the title for the form, open the form to view information, and then close it.
2. Open the PropertyEntry form in Form View and edit the Year Built value for the first record (Property No 1) to 1985 from 1975.
3. With the PropertyEntry form still open in Form View, enter a new record with the field values shown in Table 1.

 

Property No	(AutoNumber will automatically number the record)
Property Type	2
Street Address	101 High St
Owner First	Javier
Owner Last	Moran
City	Kansas City
State	MO
Zip	66220
Manager	4
Year Built	2018

 

4. Switch the PropertyEntry form to Design View, then move the Close command button from the Form Footer section to the right side of the Form Header section. Position the button so that the right edge is at about the 4" mark on the horizontal ruler. Save the PropertyEntry form.
5. Switch the PropertyEntry form to Layout View, select the Property Entry Form label in the Form Header section, and apply bold styling. Select the Close command button and apply the Intense Effect-Gray Accent 3 Quick Style (6th row, 4th column in the Theme Styles menu).
6. With the PropertyEntry form still open in Layout View, delete the Homestead Partners label in the Form Footer section. Edit the Zip label, using ZIP Code as the new value.
7. With the PropertyEntry form still open in Layout View, add the Baths field to the form and position the new label and text box just below the Year Built label and text box. Display the PropertyEntry form in Form View as shown in Figure 1 and then save and close the PropertyEntry form.
    

 

 

8. Open the HomeStyles form in Design View, select the TypeID label and Description label in the Detail section, and change the font color to Automatic (Black). (Hint: Be careful to select the labels and not the text boxes.) Save the HomeStyles form. Display the HomeStyles form in Form View as shown in Figure 3, then close the HomeStyles form.
    

 

 

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.