Extrac Credit: Access Clinic Database

Attached is the Clinic Database in a Microsoft Access format.  We will review this database while examining several features in Microsoft Access.  You should download the Clinic Database to the system that you are using in the classroom or to a USB storage device.  Your task is to write the queries for the following information requests and upload your version of the database after completing the in class activities.

Clinic.accdb Download Clinic.accdb

Here are a list of the activities

In Access Create a Query that will list all of the doctors that are Dermatologist. Name the Query Dermatologists.

In Access Create a Query that will list all of the patients that live in the 901 area code and are over 55.  The the Query '901 area code over 55'

In Access, use the relationship tool located in the Database Tools to set the following relationships

1 - many relationship between doctor and prescription

1 - many relationship between patient and prescription

1 - many relationship between drug and prescription

In Access Create a Query listing all prescriptions.  In the query include the Doctors Name, Patients Name, and Drugs Name. Name the query 'Prescriptions Filled'

I

n Access, create a Form for the Doctor Table

Create a Report using the Prescription Query