Create an access database table with the title

Assignment Help Other Subject
Reference no: EM131143934

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

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.

1. Provide an appropriate query title.

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

Reference no: EM131143934

Questions Cloud

Determine the maximum stress in the wood : The 6 X 12-in. timber beam has been strengthened by bolting to it the steel reinforcement shown. The modulus of elasticity for wood is 1.8 X 106 psi and for steel is 29 X 106 psi.
Calculate the vibration response : A moving bar is traveling along the x axis with constant velocity and is suddenly stopped at the end at x = 0, so that the initial conditions are w(x, 0) = 0 and wt (x, 0) = v. Calculate the vibration response.
What some action that should be taken by safety practitioner : What are some actions that should be taken by a safety practitioner when an organization's safety culture starts to drift into a negative state? Provide examples that illustrate your point.
Calculate the natural frequencies and mode shapes : Calculate the natural frequencies and mode shapes of a shaft in torsion of shear modulus G, length l, polar inertia J, and density ρ that is free at x = 0 and connected to a disk of inertia J0 at x = l.
Create an access database table with the title : Create an Access Database table with the title: Providers. Create a second Access Database table with the title: Nurses.
Determine the maximum stress in the aluminum strip : A copper strip (Ec = 105 GPa) and an aluminum strip (Ea = 75 GPa) are bonded together to form the composite beam shown. Knowing that the beam is bent about a horizontal axis by a couple of moment M = 35 N.m,
Compute the test value : A health professional in Chicago wanted to determine if people in Chicago had similar feelings toward their health. - Compute the test value.
Complete the worksheet by extending amounts reported : Complete the worksheet by extending amounts reported in the adjusted trial balance to the appropriate columns in the work sheet. Do not total individualcolumns.
Compute zolas gross income under two assumptions : Zola collected $900 in taxable interest on certificate of deposit that she inherited from her aunt.- Compute Zola's gross income under two assumptions as to the state of residency of the couple.

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd