NEED A PERFECT PAPER? PLACE YOUR FIRST ORDER AND SAVE 15% USING COUPON:

4.8/5

CREATING QUERIES

Application: Creating and Using a Microsoft Access Database, Part 3

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
    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

Don't use plagiarized sources. Get Your Custom Essay on
CREATING QUERIES
Just from $13/Page
Order Essay
  • 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.

Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!
Open chat
Scan the code
Need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and doctorate-prepared writers.