Access Module 7 End of Module Project 2 | New Perspectives Access 2019 | Cardiac Rehab Associates

Описание: If you directly want to get the project from us then contact us on our Whatsapp. Link is given below,

https://wa.me/message/PPXGSJS2TLWUA1

Whatsapp Contact Number:
+91 8114420233

Email ID:
[email protected]

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.
Figure 1: ProgramInfo report in Print Preview



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