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

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.BackgroundThree 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 TablesInstructions for Table Creation:Create an Access Database with the title: Community Health and Wellness ClinicCreate an Access Database table with the title: ProvidersCreate a second Access Database table with the title: NursesCreate a third Access Database table with the title: PatientsCreate a fourth Access Database table with the title: Patient RecordsThe table Providers should have the following field names:Provider Last NameProvider First NameProvider IDAddressZip CodeOffice TelephoneMobile PhoneE-mail addressThe table Nurses should have the following field names:Nurse Last NameNurse First NameNurse IDAddressZip CodeOffice TelephoneMobile PhoneE-mail addressThe table Patients should have the following field names:Patient Last NamePatient First NameMedical Record NumberAddressZip CodeOffice TelephoneMobile PhoneE-mail addressThe table Patient Records should have the following field names:Account NumberMedical Record NumberProvider IDNurse IDDate AdmittedChief ComplaintRecord CriteriaSelect 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 RelationshipsInstructions for Establishing RelationshipsBegin 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 ReportsIn 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 QueriesCreate 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 NameNurse First NamePatient Last NamePatient First NameDate AdmittedChief ComplaintProvide 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 NameProvider IDNurse Last NameNurse IDMedical Record NumberAccount NumberPatient Last NameDate AdmittedChief ComplaintProvide an appropriate Query title.Instructions – Creating ReportsPrepare 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 NameUsing the query #3 create a summary report; group the contents under Provider Last Name.

Don't use plagiarized sources. Get Your Custom Essay on
Application: Creating and Using a Microsoft Access Database, Part 1 and Part 2
Just from $13/Page
Order Essay
Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 15% with the discount code ESSAYHELP