microsoft access assignments

Open the Patient table in Design view, and then update the field properties in using the information in Table 2 on the following page. The PatientID field should be set as the primary key for the table. When you have finished, save the Patient table.

Table 2: Patient Table – Field Properties

© 2014 Cengage Learning.

Add the records shown in Table 3 below to the Patient table. Close the table when you are finished.

Table 3: Patient Table - Records

Jennifer exported her existing patient data to a text file and asks you to add this data to the Patient table. Import the data as follows:

a. Specify support_NP_A13_T2_P1a_patient.txt as the source of the data. (The file support_NP_A13_T2_P1a_patient.txt is available for download from the SAM website.)

b. Select the option to append a copy of the records to the Patient table.

c. In the Import Text Wizard dialog boxes, choose the option to import delimited data, to use a comma delimiter, and to import the data into the Patient table. Do not save the import steps.

Open the Billing table in Design view, and then set the field properties shown in Table 4 below. The BillingID field should be set as the primary key for the table.

Table 4: Billing Table – Field Properties

© 2014 Cengage Learning.

In Design view for the Billing table, move the Sessions field so it follows the EndDate field. Save and close the table.

Use the Import Spreadsheet Wizard to add data to the Billing table from an Excel spreadsheet as follows:

d. Specify support_NP_A13_T2_P1a_billing.xlsx as the source of the data. (The file support_NP_A13_T2_P1a_billing.xlsx is available for download from the SAM website.)

e. Select the option to append a copy of the records to the Billing table.

f. In the Import Spreadsheet Wizard dialog boxes, choose the Sheet1 worksheet, and import to the Billing table. Do not save the import steps.

In Design view, create a new table using the information shown below in Table 5. The LocationID field should be set as the primary key for the table. Save the table as Location, and then close the table.

Table 5: Location Table – Field Properties

© 2014 Cengage Learning.

Add the Therapist, Billing, and Patient tables to the Relationships window. Resize the field list for each table shown in the Relationships window so all fields are visible in the field list. Define a one-to-many relationship between the primary Therapist table and the related Billing table using the TherapistID field. Choose the options to enforce referential integrity and to cascade updates to related fields.

Define a one-to-many relationship between the primary Patient table and the related Billing table using the PatientID field. Choose the options to enforce referential integrity and to cascade updates to related fields. Figure 1 on the following page shows the completed Relationships window. Save and close the Relationships window.

Figure 1: Relationships Window

Microsoft product screenshots used with permission from Microsoft Corporation.

Copyright © 2014 Cengage Learning. All Rights Reserved.

Close and save any open database objects. Compact and repair your database, and then exit Access. Follow the directions on the SAM website to submit your completed project.