I have Database project I made the tables and some of the required.I need to complete the following:I. An…

I have Database project I made the tables and some of the required. I need to complete the following: I. An E-R Diagram (hand drawn or using MS-Visio) II. An MS Access 2010 database including the following “special features” 1. Create a database with multiple normalized tables with the necessary design to support your application and sufficient data to demonstrate the following (data may be real or fictional). 2. Examples of the use of validation rules and input masks for data fields 3. At least two forms, one of which must be a multi-table form (form with a subform). 4. At least two reports, one of which must be a multi-table report 5. At least five queries including examples of each of the following a. Select queries b. Sorting queries c. Calculation field queries (Field created by another field or fields) d. Function queries using By Group (counts,totals, averages) 6. At least two examples of advanced reporting techniques (design mode) 7. At least two examples of advanced form techniques (report mode) 8. A switchboard or button/macro interface for form, reporting navigation.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

0/99

AppointmentID Patient ID Doctor ID Date Time AppointmentTakerInitials
4 1 2 10/7/12 12/

3 TAL
AppointmentID

ChargeID Quantity
ChargeID

Description Fee
5586 fever ¤ 50.00
6675 allergy ¤ 80.00
8680 headache ¤ 70.00
9869 flu ¤ 56.00
1

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
2

ER

DoctorID LastName FirstName Email PhoneNumber Department Current LicenseNumber
Alotabi Karen Kal.us@hotmail.com 315676953 ER 5678
Alshmmari Sarah Sa99@hotmail.com 314666558 8875
1

2

3

InsuranceID InsuranceCompany InsuranceNumber InsuredLastName ExpirationDate PatientID CopyOfInsuranceCard
Aetna 34957 Alharbi 1/16/13
Anthem 90574 Alshammari 3/11/13
AARP 57690 Jone 4/22/13
PatientID LastName FirstName Email PhoneNumber Department

Current

1 Alharbi

ER

2 Alshammari

ER

3 Jone

ER

Address History
Turk ttt_403@hotmail.com 31454058 Rue la cheel allergies
Hsive HS_@hotmail.com 31578979 Main St. high blood pressure
Mike Mj07@live.com 79756478 Olive St. cancer

SELECT [PATIENTS].[PatientID], [PATIENTS].[LastName] AS PATIENTS_LastName, [PATIENTS].[FirstName] AS PATIENTS_FirstName, [PATIENTS].[Email], [PATIENTS].[PhoneNumber] AS PATIENTS_PhoneNumber, [APPOINTMENT].[Doctor ID], [APPOINTMENT].[Time], [DOCTORS].[LastName] AS DOCTORS_LastName, [DOCTORS].[FirstName] AS DOCTORS_FirstName, [DOCTORS].[PhoneNumber] AS DOCTORS_PhoneNumber, [APPOINTMENT].[AppointmentID]
FROM PATIENTS INNER JOIN (DOCTORS INNER JOIN APPOINTMENT ON [DOCTORS].[DoctorID] =[APPOINTMENT].[Doctor ID]) ON [PATIENTS].[PatientID] =[APPOINTMENT].[Patient ID];
SELECT DISTINCTROW *
FROM DOCTORS;

Hospital Database.accdb

AppointmentID Patient ID Doctor ID Date Time AppointmentTakerInitials

4 1 2 10/7/12 12/30/99 TAL

AppointmentID ChargeID Quantity

ChargeID Description Fee

5586 fever ¤ 50.00
6675 allergy ¤ 80.00
8680 headache ¤ 70.00
9869 flu ¤ 56.00

DoctorID LastName FirstName Email PhoneNumber Department Current LicenseNumber

1 Alotabi Karen Kal.us@hotmail.com 315676953 ER 5678
2 Alshmmari Sarah Sa99@hotmail.com 314666558 ER 8875

InsuranceID InsuranceCompany InsuranceNumber InsuredLastName ExpirationDate PatientID CopyOfInsuranceCard

1 Aetna 34957 Alharbi 1/16/13
2 Anthem 90574 Alshammari 3/11/13
3 AARP 57690 Jone 4/22/13

PatientID LastName FirstName Email PhoneNumber Department Address History Current

1 Alharbi Turk ttt_403@hotmail.com 31454058 ER Rue la cheel allergies
2 Alshammari Hsive HS_@hotmail.com 31578979 ER Main St. high blood pressure
3 Jone Mike Mj07@live.com 79756478 ER Olive St. cancer

SELECT [PATIENTS].[PatientID], [PATIENTS].[LastName] AS PATIENTS_LastName, [PATIENTS].[FirstName] AS PATIENTS_FirstName, [PATIENTS].[Email], [PATIENTS].[PhoneNumber] AS PATIENTS_PhoneNumber, [APPOINTMENT].[Doctor ID], [APPOINTMENT].[Time], [DOCTORS].[LastName] AS DOCTORS_LastName, [DOCTORS].[FirstName] AS DOCTORS_FirstName, [DOCTORS].[PhoneNumber] AS DOCTORS_PhoneNumber, [APPOINTMENT].[AppointmentID]
FROM PATIENTS INNER JOIN (DOCTORS INNER JOIN APPOINTMENT ON [DOCTORS].[DoctorID] =[APPOINTMENT].[Doctor ID]) ON [PATIENTS].[PatientID] =[APPOINTMENT].[Patient ID];
SELECT DISTINCTROW *
FROM DOCTORS;

Are you stuck with your online class?
Get help from our team of writers!

Order your essay today and save 20% with the discount code RAPID