Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started