Database systems; design using Microsoft Access

1. Create a query that displays all patient records for each provider (PROVIDERS and PATIENT RECORDS)
   1. Provide an appropriate query title.
2. Create another query that displays the nurse and patient information for each patient visit listed in PATIENT RECORDS. This query should display the following fields from PATIENT RECORDS, PATIENTS, and NURSES:
   

   Nurse Last Name
   Nurse First Name
   Patient Last Name
   Patient First Name
   Date Admitted
   Chief Complaint

   1. Provide an appropriate query title.
3. Create another query that displays the provider and nurse information for each patient visit listed in PATIENT RECORDS. This query should display the following fields from PATIENT RECORDS, PATIENTS, PROVIDERS, and NURSES:

Provider Last Name
Provider ID
Nurse Last Name
Nurse ID
Medical Record Number
Account Number
Patient Last Name
Date Admitted
Chief Complaint

• 1. Provide an appropriate Query title.

Instructions – Creating Reports

Prepare two (2) reports as follows from queries #2 and #3 created above:

1. Create a report from each customizing the header to “Community Health and Wellness Clinic”

• • Using query #2 create a summary report; group the contents under Nurse Last Name
  • Using the query #3 create a summary report; group the contents under Provider Last Name.