Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help converting Excel Data to Access Create a Microsoft Access database for the Doc-n-the-Box pharmacy. Create the table(s), field(s), data type(s), primary key(s), etc.

Need help converting Excel Data to Access

Create a Microsoft Access database for the Doc-n-the-Box pharmacy.

Create the table(s), field(s), data type(s), primary key(s), etc. for the database and populate it with the data provided in the Excel file.

Create the relationship(s) between/among the tables, as appropriate.

Query 4 Create a list of Prescriptions with 2 (two) authorized refills. Your output should include UPN, Drug Name, # Refills Authorized, Patient Last Name, Patient First Name, Doctors (Last) Name, Doctor ID#, and Doctors Phone Number.

Query 5 Create a list of Patients who received prescriptions between June 1, 2011 and September 30, 2011. Your output should be organized by Patients Last Name, Patients First Name, Prescription Date (in ascending order), Expiration Date, Patient ID#, Doctors Last Name, Doctor ID#, Drug Name, and UPN.

Query 6 Create a list of drugs that have been prescribed between January 1, 2012 and December 31, 2012. Your output should be organized by UPN (ascending), Plan ID#, Plan Name (ascending) and date of prescription.

Patient ID First Name Last Name Phone Date of Birth Gender Health Plan Allergies
19 Dusty Springfield (435) 693-1212 4/5/1990 F H0971 Codeine derivatives, merperidine
10 Jonathan Cardenas (928) 551-5547 8/22/1994 M H1695 Peanuts
23 Jennifer Holiday (928) 888-3545 11/21/1989 F H1205
18 Anders Kroll (505) 499-6541 9/11/1994 M H10119 Penicillin
14 Mary Ambrose (435) 444-1233 4/15/1990 F H10119 Shellfish
15 Gina Mercado (970) 514-3212 6/17/1989 F H0971 Morphine
4 Steven Nuggent (435) 122-4545 10/12/1986 M H1941 Penicillin
11 Paula Hargus (505) 744-1889 6/11/1990 F H1205
22 Jose Hargus (505) 498-6478 6/30/1987 M H1695 Morphine, morphine derivatives
24 Kimberley Smith (928) 647-2477 1/16/1989 F H10119
20 Kevin Bacon (435) 477-8989 6/22/1990 M H1941
21 Cesar Romero (970) 631-2222 1/14/1987 M H3410 Peanuts
1 Ted Williams (970) 644-1214 12/11/1994 M H0971 Pine Tar
17 Maria Gabel (970) 223-4157 8/12/1990 F H1205 Penicillin
8 Sonia Cardenas (928) 551-5547 4/12/1988 F H3410 Penicillin, cephalosporins
25 Anton Scallia (515) 246-4579 6/22/1984 M H4567 Heart Medication
26 John Hopkins (202) 456-7891 6/13/1992 M H4567 Chicken
27 Amy Wolf (212) 789-1456 9/13/1992 F H9785 Codeine derivatives, merperidine
28 Diane Keaton (456) 789-1456 12/12/1990 F H4567

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Illuminated

Authors: Catherine M. Ricardo

1st Edition

0763733148, 978-0763733148

More Books

Students also viewed these Databases questions