2023 Application Creating and Using a Microsoft Access Database Part 3 Part 3 Queries and Reports In Week 5
2023 Nursing Database systems; design using Microsoft Access
Application Creating and Using a Microsoft Access Database Part 3 Part 3 Queries and Reports In Week 5 2023
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
- Create a query that displays all patient records for each provider (PROVIDERS and PATIENT RECORDS)
- Provide an appropriate query title.
- 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 - Provide an appropriate query title.
- 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
- Provide an appropriate Query title.
Instructions – Creating Reports
Prepare two (2) reports as follows from queries #2 and #3 created above:
- 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.
We give our students 100% satisfaction with their assignments, which is one of the most important reasons students prefer us to other helpers. Our professional group and planners have more than ten years of rich experience. The only reason is that we successfully helped over 100000 students with their assignments on our inception days. Our expert group has more than 2200 professionals in different topics, and that is not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.
Place Order Now
Leave a Reply
Want to join the discussion?Feel free to contribute!