Microsoft Access Excercise 2

1. Create an Access database based on this Entity Relationship Diagram. Populate each table with at least five records (use records, rather than typing random characters into each field).

2. Create table relationships as shown in the ERD above.

3. Create a query that will display the Appointment date, the patient information the bill status and the amount. (You may or may not need to use all four tables.)

a. Run the query and display the results. Make a screen shot of the result, and include in your screen shot the lower right-hand corner of your screen which shows the system time and date.

b. Remove the relationship connections.

c. Run the query again.

d. What happens? Write a 1 – 2 paragraph discussion on the results, and explain the advantage of a relational database.

Write your answer to Question 3d, and upload it, along with your Access .accdb file.

Appointment

Bill

DoctorPatient

Appointment Date

PK

Appointment Time

Appointment duaration

Bill Number

PK

Bill date

Bill Amount

Doctor Id

PK

Doctor First Name

Doctor Last name

Patient Id

PK

Patient First Name

Patient Last Name

Appointment Reason

Doctor Id

FK

Patient Id

FK

Bill Number

FK

Bill status