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.

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 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.

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 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.