Homework answers / question archive / New Perspectives Access 2019 | Module 7: End of Module Project 2 Cardiac Rehab Associates Creating Reports GETTING STARTED Open the file NP_AC19_EOM7-2_FirstLastName_1

New Perspectives Access 2019 | Module 7: End of Module Project 2 Cardiac Rehab Associates Creating Reports GETTING STARTED Open the file NP_AC19_EOM7-2_FirstLastName_1

MS Access

Share With

---

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

Cardiac Rehab Associates

Creating Reports

GETTING STARTED

• Open the file NP_AC19_EOM7-2_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as NP_AC19_EOM7-2_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. Cardiac Rehab Associates is a company that helps people rehabilitate their health and strength after an illness or an accident. You work as a research analyst to maintain records and to analyze the success of various activities and programs. At Cardiac Rehab Associates, you are developing an Access database application to help manage this information. In this project, you will improve the existing database by creating and modifying many different types of report controls. You will also format and create new reports.
   
   Open the InsuranceCompanyList report in Layout View and add a title. Modify the title to add a space between the words Insurance, Company, and List and bold the title. Center-align the InsuranceCode label and the InsuranceCode data in the first column. Save, preview, and close the InsuranceCompanyList report.
2. Open the ClientsByName report in Design View and change the number of columns to 2 with a Down, then Across layout. Save, preview, and close the ClientsByName report.
3. Open the HealthProgramListing report in Design View and remove the control layouts from all controls in all report sections. Remove the ProgramName Header section. Resize the Health Programs label in the Report Header section so that the right edge stops at the 2.5" mark on the horizontal ruler. Save the HealthProgramListing report.
4. With the HealthProgramListing report still open in Design View, select all controls in the Page Header section and change the font color to Automatic (black). Change the Alternate Back Color to White, Background 1 for the Detail section. Save, preview, and close the HealthProgramListing report.
5. Create a new report in Report Design View. Apply the Record Source property to the ClientScores query. 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 ClientScoreDetails and close it.
6. In the Navigation window, copy the ProgramRosters report and paste it with the name ProgramInfo. Open the ProgramInfo report in Design View, delete the ID label in the Page Header section and the ClientID text box in the Detail section. Move the FirstName label in the Page Header and FirstName text box in the Detail section slightly to the right so that their right edges are at the 7.5" mark on the horizontal ruler. Save the ProgramInfo report.
7. While still working in Design View of the ProgramInfo report, add two sort orders after the grouping field to sort the records in ascending order, by LastName, then FirstName. Save the report and view it in Print Preview, confirm that it matches Figure 1, then close the ProgramInfo report.

8. Open the ProgramRosters report in Design View. Expand the size of the Report Footer section to be about 1.5" tall, then use the Subreport Wizard to add a subreport control to the left side of the Report Footer section at about the 0.5" mark on the horizontal ruler. Base the subreport on the existing HealthProgramListing report. Choose None when asked which fields link the main report to the subreport. Use the default name for the subreport. Save, preview, and close the ProgramRosters report.
9. Open the ClientListing report in Design View and add page numbers to the report using the Page N of M format positioned in the right side of the Page Footer. Save the ClientListing report.
10. With the ClientListing 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 2" mark on the horizontal ruler. Within the text box, add an expression to count the ClientID field for the entire report. Enter Total Clients: for the Caption property for the new label in the Report Footer section. (Hint: If necessary, change the width of the label so that the text is fully visible.) Left-align the left edges of the new text box in the Report Footer section with the FirstName text box in the Detail section. Left-align the content within the new text box in the Report Footer section. Preview the last page of the report in Print Preview, a portion of which is shown in Figure 2. Save and close the ClientListing report.

11. The office has a need for physical files for some clients, so you decide to create a label report to generate labels for the files. Use the Label Wizard to create a report based on the Clients table, and use the Avery C2651 label size. Accept the default settings for font style and color. Insert the InsuranceCode field on the first line of the label, and on the second line insert the ClientID field followed by a space, the LastName field followed by a comma and a space, and then the FirstName field. Sort the labels by the InsuranceCode field, then use ClientLabels as the name of the report. Switch to Print Preview and confirm that your report matches Figure 3, then save and close it.

12. Open the ClientsByInsurance report in Design view, and group the report by the InsuranceCode field. Use the arrows at the right side of the group, sort, and total pane to move the grouping field above the sort levels. Add the InsuranceCode field to the new InsuranceCode header directly below the Insurance Code label in the Page Header section, and delete the label associated with it. Preview the report and confirm that it matches Figure 4, then save and close it.

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.