Homework answers / question archive / 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

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

MS Access

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

Homes by Style and State
Description	State	City	Year Built	Owner
Southern
	AZ
		Merriam	2017	Kendra
		Wildwood	2016	Hoskinson
		Merriam	2016	Halfacre
		Merriam	2015	Taylor
		Wildwood	2005	Meyer
		Merriam	2003	Sander
	CA
		Smithville	2004	Needham
	CO
		Pawnee	2014	Tomczak
		Desoto	1986	Ashner
	FL
		Mountain	2018	Simoneau
		Still Waters	2014	Horrocks
		Fairway	2011	Garcia

 

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

Manager Bonuses
ManagerID	Manager	Bonus	Cell Phone
5	Bretz	$6,000.00	(555) 128-1238
3	Dzambazi	$5,000.00	(555) 126-1236
2	Perez	$6,000.00	(555) 125-1235
4	Walton	$6,000.00	(555) 127-1237
1	Washington	$5,000.00	(555) 123-1234
		28000

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.