Application: Creating and Using a Microsoft Access Database, Part 1 and Part 2

User Generated

ivamnor

Programming

Description

Assignment Scenario Premise:
Community Health and Wellness Clinic offers preventive and traditional medical care. In your role as Nurse Informaticist, you will help Community Health develop a new database system.

Background
Three years ago, primary care providers John Anderson and Melanie Miller decided to combine their individual practices to form Community Health and Wellness Clinic. They wanted to concentrate on preventive medicine by helping patients maintain health and wellness. Dr. Anderson recently asked you to work with him as an IT consultant. He wants you to help Community Health develop an Access database system that will support the clinic’s operation and future growth.

Part 1 – Creating Tables

Instructions for Table Creation:

  • Create an Access Database with the title: Community Health and Wellness Clinic
  • Create an Access Database table with the title: Providers
  • Create a second Access Database table with the title: Nurses
  • Create a third Access Database table with the title: Patients
  • Create a fourth Access Database table with the title: Patient Records

The table Providers should have the following field names:

  • Provider Last Name
  • Provider First Name
  • Provider ID
  • Address
  • Zip Code
  • Office Telephone
  • Mobile Phone
  • E-mail address

The table Nurses should have the following field names:

  • Nurse Last Name
  • Nurse First Name
  • Nurse ID
  • Address
  • Zip Code
  • Office Telephone
  • Mobile Phone
  • E-mail address

The table Patients should have the following field names:

  • Patient Last Name
  • Patient First Name
  • Medical Record Number
  • Address
  • Zip Code
  • Office Telephone
  • Mobile Phone
  • E-mail address

The table Patient Records should have the following field names:

  • Account Number
  • Medical Record Number
  • Provider ID
  • Nurse ID
  • Date Admitted
  • Chief Complaint

Record Criteria

  • Select the appropriate data type for each field in each table.
  • Select the primary key for each table.
  • Create ten (10) realistic database records for each of the tables. You may be creative as you enter the information in each field, but ensure that your entries are valid. For example, do not enter ABCDE into every field in an entry—include realistic names, numbers, etc.
  • As you create 10 records for the PATIENT RECORDS table, make sure that the information in the Medical Record Number, Provider ID, and Nurse ID fields corresponds to previous information you entered into the PROVIDERS, NURSES, and PATIENTS tables. This will ensure that when you establish relationships and run queries, you will return meaningful results.
Note: A patient can have more than one record in PATIENT RECORDS because patients can have many visits to the clinic.

Part 2 – Establishing Relationships

Instructions for Establishing Relationships

Begin by reviewing how to establish relationships in Microsoft Access. Next, using the tables that were developed in Part 1 of the assignment and using Access:

  • Create a relationship between PROVIDERS and PATIENT RECORDS.
  • Create a relationship between PATIENTS and PATIENT RECORDS.
  • Create a relationship between NURSES and PATIENT RECORDS.

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)
    • 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
    • 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
    • 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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Communit...


Anonymous
I use Studypool every time I need help studying, and it never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags