Käynnissä

Microsoft Access Data Analysis

I need these requirements completed exactly as specified within three days. I will send you the data sheet once the job is accepted.

I am willing to pay $15 for this project.

--------------------------------------------------------------------

In central Fairfax, VA, is a relatively new small medical practice lovingly known as the “Doc-n-the-Box.” There is also a pharmacy affiliated with the medical practice. Although meticulous and professional, recordkeeping at the pharmacy is a bit inefficient since it is done manually. Recordkeeping costs have been rising in recent months as additional people have been hired to meet stricter industry regulations regarding the Health Insurance Portability and Accountability Act (HIPAA) and because of state regulations that affect the sale, storage, and dispensing of prescription drugs. Although the Doc-n-the-Box has succeeded in automating some of the data management for the pharmacy in an Excel spreadsheet, a more substantial change, i.e., a move to Microsoft Access, is needed to properly maintain and store data.

Individuals who use the Doc-n-the-Box can request prescriptions at the pharmacy, either by presenting a written order from a doctor or asking for a refill of an existing prescription. The pharmacist adds this request to the system by getting the required information to fill it, including information about the drug, the individual’s name, the individual’s health plan, and the prescribing doctor.

Requirements:

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

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

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

Once this is done, perform the following data-analysis tasks (i.e., queries) using Access. (Use the generic name for the queries when you save them, e.g., Query 1, Query 2, etc.):

Query 1 – Create an alphabetized list of the female patients who have used the Doc-n-the-Box. Your output should include the Last Name, First Name, Patient ID#, Phone, Date of Birth, and allergies, if any.

Query 2 – Create a list of patients and the drug(s) that has/have been prescribed for them. Your output should include the Patient’s Last Name, Patient’s First Name, Patient ID #, Drug Name, UPN, Instructions, Number of Refills Authorized, and Rx Expiration Date. Sort it by Rx Expiration date with the expiration furthest out on top (descending).

Query 3 – Create a list of the Health Plans with a list of individuals for each plan. Your output should include the Health Plan Name, Health Plan ID#, Patient Last Name, Patient First Name, and Patient ID#. This list should be alphabetized by Health Plan Name, and alphabetized by Patient Last Name within each Health Plan category.

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

Query 5 – Create a list of Patients who received prescriptions between May 1, 2012 and December 31, 2012. Your output should be organized by Patient’s Last Name, Patient’s First Name, Prescription Date (in ascending order), Expiration Date, Patient ID#, Doctor’s 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.

Taidot: Data Analytics, tiedonsyöttö, tietojenkäsittely, Excel, Microsoft Access

Näytä lisää: why use access, how to use access with excel, when to use access instead of excel, benefits of access over excel, access vs excel pros and cons, why would you use a spreadsheet over a database?, difference between ms excel and ms access in tabular form, excel vs access differences, access data analysis, microsoft excel data analysis and business modeling templates, microsoft access data entry forms, microsoft access data entry form, data analysis report code microsoft access, microsoft access survey analysis, microsoft access data modification

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #15675413

Myönnetty käyttäjälle:

biplobhosain

I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills. Relevant Skills and Experience Data Analytics, Data Entry, Data Processing, Excel, Microsoft Ac Lisää

15 $ USD 1 päivässä
(0 arvostelua)
0.0

9 freelancers are bidding on average $18 for this job

25 $ USD 1 päivässä
(0 arvostelua)
0.0
15 $ USD 1 päivässä
(0 arvostelua)
0.0
degea

I have experience in setting Mysql and writing queries for it ! Relevant Skills and Experience Mysql Proposed Milestones $15 USD - Setting mysql server and creating tables $20 USD - Writing the 6 queries you mentione Lisää

35 $ USD 4 päivässä
(0 arvostelua)
0.0
20 $ USD 1 päivässä
(0 arvostelua)
0.0
guptaharshita90

Hi you will find that the work done by me exceeds your expectations. I do this professionally and have joined freelancer for side income.

15 $ USD 2 päivässä
(0 arvostelua)
0.0
20 $ USD 1 päivässä
(0 arvostelua)
0.0
10 $ USD 2 päivässä
(0 arvostelua)
0.0
mohdlatief

Hello, My name is latief a certified  lead generation expert,got 6+ years of experience in lead generation. I have designed a tool that makes use of API technologies and i use that to generate leads. I am fully exper Lisää

10 $ USD 3 päivässä
(0 arvostelua)
0.0