Microsoft Access work for Client -- 2

已关闭

描述

I need someone able to perform the tasks below PERFECTLY. Or else the milestone will not be released. If you're chosen, I will send you the data sheet to begin work.

I need this job done as soon as possible, (24 hours tops)

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. Use the data that the Doc-n-the-Box has provided for you in the file

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.

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

4. Populate the database with the data provided in the Excel file.

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.

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.

It is a fairly easy task, so I'm only willing to pay $15 for this job.

技能: 数据输入, 数据处理, 微软Access

查看更多: certificate error work email microsoft outlook web access, work order microsoft access, free website creator microsoft access microsoft outlook, interface microsoft access microsoft project, php work access database, work order microsoft database, complete project work access, proofread work done microsoft word 2003, java sip client wifi access, word document work access integrer, vpn providing client web access linux vps, work access database php, create client login access web site, microsoft ias system requirements, access microsoft exchange java

Project ID: #12150576

19 freelancers are bidding on average $53 for this job

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 更多

$100 USD in 1 day
(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 更多

$35 USD 在3天内
(16条评论)
3.7
$111 USD 在5天内
(0条评论)
0.0
$30 USD 在10天内
(0条评论)
0.0
$50 USD 在2天内
(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 更多

$97 USD 在10天内
(0条评论)
0.0
jonathanpradas

I've read the instructions and seems fairly easy. Let's talk about the specific by messaging me. I've been using access for my personal and professional needs so I can do this task easily. P.S. can't pick less than 30$ 更多

$30 USD in 1 day
(0条评论)
0.0
$35 USD 在3天内
(0条评论)
0.0
smathukumilli

I take my job seriously and see to it that the job is completed in the shortest time and well before dead line and is error free. This has helped me build long-term relations with my clients.

$55 USD 在3天内
(0条评论)
0.0
Mamun80

Dear Concern, I am Electrical and Electronic Engineer. I am very good in Microsoft office application especially in Excel, MS word, visio, power point, etc. I have manage large database in Alcatel-Lucent, Ericsson, Pa 更多

$72 USD 在3天内
(0条评论)
0.0
sergioobici

30 $ is the minum that the bidding system allows. . .

$30 USD 在2天内
(0条评论)
0.6
haisotma

I created a database using access for the university I am currently working. They needed a database that had information such as room number, professors name, what kind of laboratory, bio-safety level, etc and later cr 更多

$72 USD 在3天内
(0条评论)
0.0
skola8585

Having 10+ Years core experience in MS Access/SQL, So for me it would be a quick piece of cake with quality delivery.

$30 USD in 1 day
(0条评论)
0.0
lohithshivaram

I'm a Database Engineer. Need I say more? Shoot a mail to lohithshivaram021*at*gmail*com* if you decide to go ahead. I might not be online here. Respond ASAP. Cheers.

$30 USD in 1 day
(0条评论)
0.0
$66 USD 在6天内
(0条评论)
0.0
gggggary1

Can only go as low as $30 since that's the lowest Freelancer allows. I have experience in creating optimal, normalized databases as well as queries. I also have experience importing excel data into a database.

$30 USD in 1 day
(0条评论)
0.0
datasolution01

Dear Sir, I have read your job description. I have proper experience about many data entry, research, internet research, market research, information research, data collection, data input, MS word, Excel sheet, power 更多

$72 USD 在2天内
(1条评论)
0.0
DaddyWarbucks

Since 2001, I have specialized in designing, developing, upgrading, and maintaining MS Access databases, specializing in MS Access, SQL, Visual Basic, and SQL Server. Since 2007, I have developed hundreds of different 更多

$30 USD 在3天内
(0条评论)
0.0
$30 USD 在3天内
(0条评论)
0.0