Question 2 Create 4 tables and add the following fields for each table. Use datatypes that are appropriate for the type of information you are storing. Also edit your field properties and add any data masks or property fields types you feel are appropriate (i.e. phone number input mask, etc.).

Table name: Clinic

Required Fields:

ClinicID ClinicName Address Phone Fax Table name: Doctor

Required Fields:

DoctorID DrFirstName DrLastName PhoneNumber E-MailAddress HourlyRate PhysicianType PhysicianStatus ClinicID Table name: Patient

Required Fields:

PatientID FirstName LastName PhoneNumber DoctorID Table name: Appointment

Required Fields:

AppointmentID DateOfAppointment TimeOfAppointment ReasonForVisit PatientID Type "I have completed this step" or "I was not able to complete this step" in the response box when finish

Question 2 Create a new blank database with your student number and first and last name as the file name. For example: BenWhitneyA00124356.accdb

Type "I have completed this step" or "I was not able to complete this step" in the response box when finished. Question 3 (5 points) Create appropriate relationships between the Clinic, Doctor, Patient and Appointment tables. Create a 1 to Many relationship type for each relationship and enable data integrity for all relationships.

Type "I have completed this step" or "I was not able to complete this step" in the response box when finished. Add/Import Data Question 4 (5 points) Using the file below, import the sample data into your database. Make sure you import the data from each of the worksheets labelled Clinic, Doctor, Patient and Appointment. If you do not know how to do this step, you may still download the worksheet and enter in your data manually, however this step will take you more time.

MedicalClinic.xlsx

Type "I have completed this step" or "I was not able to complete this step" in the response box when finished.

Question 4 options: