Help complete the Excel VBA and Access

Closed Posted Apr 10, 2014 Paid on delivery
Closed

Problem I (65 Points): Clinic ([url removed, login to view], [url removed, login to view], [url removed, login to view], and [url removed, login to view])

Dr. Anderson has asked you to design an Access database to track patients and the nurse practitioner they see at the clinic. You want to make sure that you follow standard database guidelines so that the database can be imported into an electronic medical record system at a later date.

Currently, Dr. Anderson keeps patient and nurse practitioner addresses in Word tables, while maintaining financial information in Excel spreadsheets. She also has a list of which patients see which nurse practitioners as their primary care provider. Patients Aalya, Caleb, Emily, James Palmer, and Nasir all see Mariana Silva, the paediatric nurse practitioner (PNP). Nurse Practitioner ID 12 has patients Craig Childs, Denise Hixson, James and Sabrina Rodriguez, Aamera Siddiqui, Susan Winn, and Sunja Yun. Mr. Blanchard, Mr. Dikeos, and Mr. and Mrs. Varga all visit NP Williams. Tricia Ferrando is the Family Nurse Practitioner (FNP) for the following patients: L125, P245, P246, S341, and W385. Nurse practitioner Grace Upton does not have any assigned patients

Instructions Part 2:

1. Answer the following questions using the Patient Info table and including the Patients’ first and last names, City, State, Previous Balance, and Current Balance fields. Save each query.

a) Which patients are located in WI State? Save the query as 2-A Query.

b) Which patients have first names beginning with the letter ‘A’ and ending with letter ‘a’? Save the query as 2-B Query.

c) Which patients have a postal code of 55819 and live at “31 Aspen Lake Dr.”? (The Postal Code field should not appear in the results.) Save the query as 2-C Query.

d) Which patients have current charges of $125? Save the query as 2-D Query.

e) Which patients have a previous balance less than $100? Save the query as 2-E Query.

f) Which patients have current charges of less than $100 and have a previous balance greater than $120? Save the query as 2-F Query.

g) Which patients live in MN state or have a previous balance greater than $250? Save the query as 2-G Query.

h) Sort the patients so that those with the greatest previous balance appear at the top and then display only the top 5% in the query results. Save the query as 2-H Query.

i) Sort the Patient Info table by city and omit duplicates. Save the query as Patient City Query.

2. Join the Patient table and the Nurse Practitioner table. Include the NP ID from the Nurse Practitioner table and the Patient ID, patient first and last names, current charges, and previous balance from the Patient table. Sort the records in ascending order by patient last name within the NP ID. Make sure that all nurse practitioners are included, regardless of whether they have any patients. Save the query as NP-Patient Query. Export the NP-Patient Query to Excel and save the export steps.

3. Use the NP-Patient Query and the Report Wizard to create a report. Format the report to fit on one page. Save the report as NP-Patient Report.

4. Create a query using the Patient Info table and include the Patient ID, patient first and last names, current charges, and previous balance fields. Create a calculated field that adds the current charges to the previous balance. Add the caption, Total Due, to the field. Save the query as Patient Total Due Query.

5. Create a query to calculate the maximum, minimum and average current charges for all patients. Save the query as Patient Average Query.

6. Calculate the average and maximum previous balance for all patients who live in MI State. Save the query as Patient AvgMaxMI Query.

7. Calculate the average current charges and average previous balance by postal code and save the Patient Average PC Query.

Client needs it done within 24 hrs
Partly completion is accepted
Need previous work sample
Freelancer needs to check the detailed requirement in attached file:Final project (Winter 2014).pdf
Thanks

Data Entry Data Processing Database Administration Excel Microsoft Access

Project ID: #5790082

About the project

21 proposals Remote project Active May 17, 2014

21 freelancers are bidding on average $13/hour for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$14 USD / hour
(330 Reviews)
7.6
vikas0903

A proposal has not yet been provided

$16 USD / hour
(39 Reviews)
5.7
elboukharimu

Hi, I'm very interested helping you on your MS Access assignment, I have more then 7 years of experience on SQL, SQL Server, and database administration, modeling, optimizing and manipulating, please do not hesitate to More

$25 USD / hour
(24 Reviews)
5.2
cijagani

I am specialize in C++,C#.net,ASP.Net,JAVA, PHP, MySQL, Wordpress, Web Designing and framework like CodeIgniter. my aim to deliver quality products to our customers within specified deadline. i strongly believe in More

$12 USD / hour
(11 Reviews)
4.2
pnjadhav

I am available right now. In my total 13 IT years of experience I have done lots of with project management.I am a expert Database Architect.I have done lots of database design and development for desktop and web based More

$30 USD / hour
(4 Reviews)
4.1
sathyasingh1991

* OM SAI RAM * Respected Sir/Mam, I have read the project completely and I have understood my responsibilities (If awarded) clearly. To tell more about myself, I am dedicated and sincere in working on the pro More

$8 USD / hour
(9 Reviews)
3.5
swarm22

Hello , I am ms access database expert with +4 year experiences. To Provide Quality , Accurate , Modular And Professional Developer. Thanks & Regards HGDumaswala

$8 USD / hour
(13 Reviews)
3.0
anomanpk

A proposal has not yet been provided

$12 USD / hour
(3 Reviews)
2.6
TypingMachine

Dear Sir, I'm quite interested by your project. I am programmer with sincere and capable. I have developed many project. Particular, I have rich experience in Excel and Access VBA. I can provide you the More

$8 USD / hour
(3 Reviews)
2.4
udul1975

Hi, I am willing to do this work for you. I will do it within 24 hours. Two days back I did a project similar to this and I can hand it over to you for reference. Lets discuss and continue with it. Thank you. More

$8 USD / hour
(2 Reviews)
1.6
neel13191

Hi, We are a team of 4 highly skilled professionals in JAVA,VB6,VBA,.net,Oracle,My SQL,SQL server,Teradata,SSIS,SSAS,Oracle Data Integrator,PHP and many more technologies. We guarantee the best quality and suppor More

$11 USD / hour
(1 Review)
2.3
miyagivw

Hi, I would love to assist with this. Its well within my skills to finish of quickly. Awaiting your positive response. please feel free to ask me if you need more info. Sincere Regards, Albert

$12 USD / hour
(2 Reviews)
0.9
dvpatel100

Hi, I have very good experience working with database. I am professionally IT engineer and I am working with sql,access and Excel. I am comfortable with all three , I have mentioned. I have very good profil More

$12 USD / hour
(0 Reviews)
0.0
praudsam

I can work on this. If you are interested send me a message at praudsam at gmail dot com I have done many projects like this.

$12 USD / hour
(0 Reviews)
0.0
papageorgis

Hello Mrs Idd117, I've been programming (stand-alone and web) for almost 10 years now, even though I am new in freelancer.com. I am at your disposal for any clarifications. Thank you in advance for your time. More

$12 USD / hour
(0 Reviews)
0.0
bosonsacademy

A proposal has not yet been provided

$12 USD / hour
(0 Reviews)
0.0
Soheluits40

A proposal has not yet been provided

$11 USD / hour
(0 Reviews)
0.0
maitriparekh

The requirement is easy. If get it clearly documented, the project is very easy. On completion of the project, the task expected out of the excel will be done in not more than few minutes.

$13 USD / hour
(0 Reviews)
0.0
Geom517

Hi, You have posted a very interesting project. You must known that the database must be organized with non-redundant 7 tables: PatientInformation, PatientFinancial, NurseInformation, NurseFinancial, PatientAndNurse More

$17 USD / hour
(0 Reviews)
0.0
frech4791

I have vast experience with MS Access and with the skills I have learned over the years I can deliver this project for you. The instructions in the PDF are pretty straight forward and will not pose any major challen More

$12 USD / hour
(0 Reviews)
0.0