New Perspectives Access 2019 | Module 2: End of Module Project 2 Cardiac Rehab Associates Building an Access Database Open the file NP_AC19_EOM2-2_FirstLastName_1

Subject:MS AccessPrice:19.99 Bought3

Share With

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

Cardiac Rehab Associates

Building an Access Database

Open the file NP_AC19_EOM2-2_FirstLastName_1.accdb, available for download from the SAM website.

• Save the file as NP_AC19_EOM2-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.
• To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:
  • Support_AC19_EOM2-2_InsuranceCompanies.xlsx
  • Support_AC19_EOM2-2_NewClients.xlsx
• 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 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.
   
   Open the Enrollments table in Design view and change the Default Value property for the ProgramID field to 1 from 0. Change the Field Size property for the ClientID field to 5 from 255. Save the table. Click Yes if prompted about lost data. Given all ClientID values are five characters or less, no data will be lost.
2. With the Enrollments table open in Design view use the Input Mask Wizard to set the Input Mask property for the EnrollmentDate field using the default values for the Short Date input mask. Change the Required property for the EnrollmentDate field to Yes from No and then save and close the Enrollments table. Click Yes if prompted to test data integrity.
3. In the Navigation pane, use the name Programs to rename the HealthPrograms table.
4. Open the Programs table in Datasheet view and to the right of the ProgramStartDate field, add a new field with a Currency data type and a field name of Fee. Move the ProgramStartDate field to the second column between the ID and ProgramName fields. The final Programs table is shown in Datasheet view in Figure 1. Save and close the Programs table.

 Figure 1: Programs table in Datasheet View

 

 

5. Use the Import Spreadsheet Wizard to add data to the Clients table from Support_AC19_EOM2-2_NewClients.xlsx and select the option to append a copy of the records from the Clients worksheet into the existing Clients table. Do not save the import settings. Open the Clients table in Datasheet view to review the data, a portion of which is shown in Figure 2.

 Figure 2: Clients table in Datasheet View

 

 

6. With the Clients table still open in Datasheet view, delete the MiddleInitial field. Change the data type for the InitiationFee field to Currency. Apply 50 as the Default Value property for the InitiationFee field. Change the data type for the Veteran field to Yes/No. Click Yes if prompted. Given no data has been recorded in that field yet, no data will be lost.
7. With the Clients table in Datasheet view, decrease the decimal places to 1 for the FlexibilityScore field. Increase the decimal places to 1 for the StrengthScore field. To the right of the FlexibilityScore field, add a new field named CognitiveScore with a Number data type. Resize to best fit the column containing the newly created CognitiveScore field. A portion of the final Clients Table Datasheet is shown in Figure 3. Save and close the Clients table.

 Figure 3: Clients table in Datasheet View

 

 

8. Import the Excel workbook named Support_AC19_EOM2-2_InsuranceCompanies.xlsx as a new table. The first row of the spreadsheet contains column headings. Use the default Field Options. Apply the InsuranceCode field as the primary key. Name the new table InsuranceCompanies and do not save the import settings. Open the InsuranceCompanies table in Datasheet view to review the data, a portion of which is shown in Figure 4, and then close it.

 Figure 4: InsuranceCompanies table in Datasheet 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.