Скачать или смотреть Access Module 2 End of Module Project 2 | Cardiac Rehab Associates

Access Module 2 End of Module Project 2 | Cardiac Rehab Associates #newperspectives

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:
https://api.whatsapp.com/message/4B6NMKKBK...

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
[email protected]

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English.

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.