New Perspectives Access 2019 | Module 4: End of Module Project 1 | Homestead Partners (2025)

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”.
o
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.
2.
3.
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.
Open the PropertyEntry form in Form View and edit the Year Built value for the first
record (Property No 1) to 1985 from 1975.
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
4.
2018
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.
6.
7.
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).
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.
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.
Figure 1: PropertyEntry form in Form View
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.
Figure 2: HomeStyles Form in Form Vie