This Lab uses and expands upon the OURDatabase Access file that you submitted in Module 02.
In this assignment, you will add more tables to your OURDatabase. This will be OURDatabase Step 3. We are beginning the process of approximating a medical encounter database “build” with this activity.
Part 1
In Part 1 of this assignment, you will use Microsoft Access to add Tables to OurDatabase. Watch the video below to learn how to add a table and to change its name to the one desired.
Using Microsoft Access, add Tables to OurDatabase for each of the following Entities:
To do this, first click on “Create,” then “Table” to add each table.
Part 2
In Part 2 of this assignment, you will use Microsoft Access to add and correctly name the needed Primary and Foreign keys in OurDatabase. Watch the video below to learn how to establish the Relationships within Microsoft Access.
Now continue working with your OurDatabase file and do the following:
If you are not familiar with taking screenshots, please visit the Library and Learning Services page “How can I take a screenshot on my smartphone, tablet, Mac, or PC?” for guidance.