New Perspectives Access 2019 | Module 7: End of Module Project 1 Homestead Partners CREATING AND MODIFYING REPORTS GETTING STARTED ? Open the file NP_AC19_EOM7-1_ FirstLastName _1

Subject:MS AccessPrice:19.99 Bought3

Share With

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

Homestead Partners

CREATING AND MODIFYING REPORTS

GETTING STARTED

?

Open the file

NP_AC19_EOM7-1_

FirstLastName

_1.accdb

, available for download from

the SAM website.

?

Save the file as

NP_AC19_EOM7-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. In this project, you will improve an existing database by creating

and modifying many different types of report controls. You will also format, modify, and

create new reports.

Open the

ManagerScores

report in Layout View and add a title. Modify the title to add a

space between the words Manager

and

Scores and bold the title. Right-align the last

names in the first column

Bretz

,

Dzambazi

,

Perez

,

Walton

, and

Washington

. Save and

close the

ManagerScores

report.

2.

Open the

Properties

report in Design View and set the number of columns to

2

with a

down then across layout. Save and preview the

Properties

report, and then close it.

3.

Open the

Surveys

report in Design View and remove the control layout from the controls

in the Page Header, Detail, and Report Footer sections. Remove the Report Header and

Report Footer sections.

(Hint:

Select Yes in the Microsoft Access window that appears

asking if you want to delete the sections.) Resize the

Comment

text box so that the right

edge reaches the

7.5"

mark on the horizontal ruler. Save the

Surveys

report.

4.

With the

Surveys

report still open in Design View, select all controls and change the font

color to Automatic (black) and set the Alternate Back Color to White, Background 1 for

the Detail section. Save and close the

Surveys

report.

5.

Create a new report in Report Design View. Set the Record Source property to the

Managers

table. Add all of the fields from the field list to the top of the Detail section of

the report at about the

2"

mark on the horizontal ruler. Save the report with the name of

ManagerList

and close it.

6.

In the Navigation window, copy the

HomeStyles

report and paste it with the name

HomeInfo

. Open the

HomeStyles

report in Design View, delete the

Property No

label in

the Page Header section and the

PropertyNo

text box in the Detail section. Move the

LName

text box slightly to the right so that the left edge is at the

4.5"

mark on the

horizontal ruler. Save the

HomeStyles

report.

7.

While still working in Design View of the

HomeStyles

report, add a sort order after the

two grouping fields to sort the records in descending order, from largest to smallest, by

the

YearBuilt

field. Save and preview the report as shown in Figure 1, then close the

HomeStyles

report.

Figure 1: HomeStyles Report in Print Preview

8.

Open the

StateListing

report in Design view expand the size of the Detail section to be

about

2"

tall, then use the Subreport Wizard to add a subreport control to the form just

below the

StateName

label. Base the subreport on the

Properties

table. Include the

PropertyNo, City, ManagerID

, and

YearBuilt

fields from the

Properties

table. Use the

default link and name for the subreport. Save and close the

StateListing

report.

9.

Open the

ManagerBonuses

report in Design View and add page numbers to the report

using the

Page N

format positioned in the left side of the Page Footer. Add the date (but

not the time) to the report using the default date format. Save the

ManagerBonuses

report.

10.

With the

ManagerBonuses

report still open in Design View, expand the Report Footer

section to be about

0.5"

tall and add a text box at about the

3"

mark on the horizontal

ruler. Within the text box, add an expression to total the

SignonBonus

field for the entire

report.

Delete the label in the Report Footer section. Right align the right edges of the

new text box in the Report Footer section with the

SignonBonus

text box in the Detail

section. Save and preview the report in Report View as shown in Figure 2, then close the

ManagerBonuses

report.

Figure 2: ManagerBonuses Report in Report 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.