Reference no: EM132354233

Your task:

This is a two-part assignment. First, you will design a new table to be added to the ROClinic database that you worked on last module. This table will provide more information about the tetanus vaccination that we studied. You will also create a relationship between this new table and the table already present in ROClinic for HIS Development.

For Part 1 of this assignment you need:

• The Access database files that you worked on last module
• Part 1 Instructions

For Part 2, please locate a source online or in our library on tetanus immunization. Read about the various types of vaccines, recommended schedules, and the like. Describe two things you learned about the immunization process and timing that would be helpful in developing a database for storing patient information.

In this portion of the assignment, you will build a new table and form relationships for information on a single major class of immunization (tetanus). The entity about which we are storing data is thus, tetanus immunization. Each time an immunization is administered to the patient an entry would be made to this sort of a table.

The design of this Table should include:

• Tetanus Immunizations
- First name (of patient)
- Last name (of patient)
- date of immunization
- Batch number for vaccine
- Expiration date for vaccine (media)
- Manufacturer
- Person administering
- type (Td, Tdap, DPT)

1. Open your MS Access database Assignment_Mod05.accdb.
2. Use Create-Table.
3. Name the new table, Tetanus Immune.
4. Enter each of the fields indicated above onto the table.
5. Designate data types as follows:
• ID as Number
• Date of immunization and Expiration date for vaccine as date/time
• the remainder, as text.

6. Create a relationship between the two tables as follows:
a. Open Database Tools.
b. Click Relationships.
c. Using the left mouse button, drag the ID field over to the Patient ID field in Tetanus Immune. A line will be drawn and a window will open with information about the relationship characteristics.
d. Just click OK.

You can always go back and edit the relationship characteristics by double clicking on the "line" that formed.

You have just formed a relationship between the two tables, Copy of Patient Information and Tetanus Immune.

7. Now please print the relationship to a file. You may do so by:
a. With the relationships tab Closed, click on Database Tools -Relationships.
b. Click on Relationship Report in the upper left hand corner. Wait a moment until the report runs.
c. Click on file- Save As-Pdf.

You can submit the pdf file or, alternatively, if the relationship report does not run, you may zip the MSAccess database for submission. Be sure the database is zipped first before submitting!

You have just created a database relationship!

Attachment:- Module 5 Access database.rar