New Perspectives Access 2019 | Module 4: End of Module Project 1 Homestead Partners
Creating and Modifying Reports
· Excel Projects Help
GETTING STARTED
1. Open the file NP_AC19_EOM4-1_FirstLastName_1.accdb, available for download from the SAM website.
2. Save the file as NP_AC19_EOM4-1_FirstLastName_2.accdb by changing the “1” to a “2”.
a. 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.
3. 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.
Table 1: Record for PropertyEntry Form
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 Layout View, then move the Close command button from the left side to the right side of the Form Footer section. Position the button so that the right edge is aligned with the right edge of the Year Built textbox in the form detail section above. Save the PropertyEntry form.
5. With the PropertyEntry form still open in Layout View, select the Property Entry Form label in the Form Header section, and apply bold styling.
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, position the Baths 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.
Figure 1: PropertyEntry form in Form View
8. Open the HomeStyles form in Layout 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.
Figure 2: HomeStyles Form in Form 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.