Microsoft Access “Doc-n-the-Box” Pharmacy

Закрыт

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. That is your job!

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. Use the data that the Doc-n-the-Box has provided for you in the file “HW 5 – Spring 2014 - 010 - Doc-n-the-Box - [url removed, login to view]” (which can be found in Blackboard) to complete the following tasks/requirements. (Note that all of these must be successfully accomplished to be able to receive full credit on the assignment.)

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. (2 pt)

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

4. Populate the database with the data provided in the Excel file. (2 pt)

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, for those individuals. (1 pt)

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) (1 pt)

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. (1 pt)

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. (1 pt)

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. (1 pt)

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. (1 pt)

Data File is provided separately.

Навыки: Microsoft Access

Показать больше: doc box pharmacy, access microsoft money 2004 database, use java access microsoft exchange, template access microsoft, chemicals database access microsoft access, student access microsoft grade management, web services access microsoft outlook java, word doc access macro, create word doc access database, access microsoft outlook calendar intranet, doc convert microsoft works word document, free website creator microsoft access microsoft outlook, interface microsoft access microsoft project, pharmacy project using access, access microsoft exchange java

ID проекта: #12138033

14 фрилансеров(-а) подали заявки на эту работу; средняя заявка - $31

paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Больше

$50 USD за 1 день
(63 отзывов(-а))
6.0
alaeddindhahri

Hi, I'm a professional Ms Access developer with strong background in developing and implementing databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I ha Больше

$35 USD за 2 дней(-я)
(7 отзывов(-а))
4.1
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ Больше

$30 USD за 3 дней(-я)
(15 отзывов(-а))
3.7
VladimirLilenko

Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and wit Больше

$30 USD за 0 дней(-я)
(16 отзывов(-а))
3.8
mauricemarinus

Hey... Doc-n-the-Box ... nice name. Ah.. I misread this.. it is an assignment. Dropped my price to $30. I can have this done for you very quickly. PS. You forgot to attach the files... Contact me to discuss Больше

$30 USD за 1 день
(3 отзывов(-а))
2.4
imdhanush

Hi, I have worked on many similar projects and I am very proficient with this. You can check my profile, I have already completed one task for my previous client. Please contact for further discussion. Best regards!!!

$20 USD за 1 день
(1 отзыв)
1.4
ksinghrajeev

Hello There, Here are some of my work examples. Project Report Automation - https://www.dropbox.com/s/tt0q9qhfq3s4izm/eBird%20FEP%20Plan%2012_Feb_15.xlsm?dl=0 Log Report Automation - https://www.dropbox.com/s/ Больше

$67 USD за 5 дней(-я)
(2 отзывов(-а))
1.1
psmashru

I am having experience of ms access of 4 years, and have done this type of queries creation

$20 USD за 1 день
(0 отзывов(-а))
0.0
dtbest9

Hi, I am a Malaysian base in Kuala Lumpur and I have working experience in Microsoft Access database ,programming and Microsoft Excel. My LinkedIn profile: https://www.linkedin.com/in/danieltke Please don't hes Больше

$35 USD за 10 дней(-я)
(0 отзывов(-а))
0.0
andreeanichifor

Hello. I would like to help you with your project. I had license to college in Access databases. I think I would handle it. Thank you.

$35 USD за 10 дней(-я)
(0 отзывов(-а))
0.0
imhdatabases

Hi There, Thank you for giving such a detailed list of your requirements it helps a great deal when bidders are deciding on which projects to bid on, knowing exactly what you require. My only concern about your proj Больше

$10 USD за 20 дней(-я)
(0 отзывов(-а))
0.0
sergioobici

I can start as soon as you realese the milestones, have you a deadline for the submission? . .

$30 USD за 0 дней(-я)
(0 отзывов(-а))
0.6
meeshusoft1

this is quite a simple project. I have developed various databases which are more complex than this.

$16 USD за 1 день
(0 отзывов(-а))
0.0
aaukaywah

I can finish your pharmacy project rapidly and in low budget. I use a easy, convenient and yet powerful tool which is based on Access and Excel. You can read more about it on http://baudb.com

$25 USD за 1 день
(0 отзывов(-а))
0.0