Database systems; design using Microsoft Access Application: Creating and Using a Microsoft Access Database, Part 3 | Coursehero Solutions

Part 3 – Queries and Reports

In Week 5, you began working on Parts 1 and 2 of this Assignment. This week you begin working on Part 3. The entire Application (all three parts) is due in or before Day 7 of Week 8.

Instructions – Creating Queries

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

   Don't use plagiarized sources. Get Your Custom Essay on

   Database systems; design using Microsoft Access Application: Creating and Using a Microsoft Access Database, Part 3 | Coursehero Solutions

   This is a Snippet Preview, get a Complete Solution Here

   Order Essay

   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