Access 97 Database Reports-Sedation

Cancelled Posted Apr 13, 2007 Paid on delivery
Cancelled Paid on delivery

1. Aggregate Summary of Major Results- this report is correct. It filters and calculates correctly.

2. Patients with Adverse Outcomes- this report needs work. It shows the months and the data correctly, but where "Any Apparaent Adverse Event" is there is the number of cases with an adverse outcome and a percentage. The Number and the Percentage show for example (if you choose University all units for July 2006 to April 30 2007 the July 06- 2(1.9%) Sept 0(0%) <--- It is August that contains the zero but the Event header leaves out the month that does not contain data. I would like to see all the months listed for the date range selected. So, this would have July August (and the zero would be listed under the August). There will be no numbers underneath an item that is blank (meaning no data is submitted) or that has a zero. This report also needs to be able to be filtered with the report parameters selected.

[login to view URL] Variance- this report needs work. It shows the # of variances for all of the data in the database, it is not filtering for the date range and parameters selected. So, for example if you Choose University 1/1/2006-4/30/2007 (all units) you will see DR ID 2409 lists zero cases with a variance but 5 variance are listed. It looks like the variances are being pulled out of the database without the filter.

4. Review of Expected Process Elements- This report seems to be filtering correctly except I would like it to display all months in the data range specified even if there is no data (it would be the month with blank underneath).

5. I have a second database "Unit Level" with Unit Report for Physician, Unit Report for Nurse, and Unit Report for Outcomes that I need to replace the ones under the database "Test".

6. I need a report created and put in the drop down for the report selection with the parameters to include data entry report. I have a query listed "Data Entry Review", it just needs to be made into a report that can be found in the drop down selection with the parameters.

7. Finally, graphs are wanted to display each of the above reports (run charts for trending analysis). One graph should be "aggregate" of all radiology areas

the second graph should be a line graph, with each line representing a different diagnostic area. The metric should be: # variances reported/#total cases for month. If we put the aggregate data on one graph, that would mean we produce 3 flow graphs: MD aggregate & Nurse aggregate, MD by unit, Nurse by unit. If that last section makes sense to you thank goodness.. because I am having a hard time figuring out what this board is asking.

I had to delete data out of the database to get it to fit, and I couldn't upload the other database "UnitLevel" because of size.

Visual Basic

Project ID: #138526

About the project

7 proposals Remote project Active Apr 16, 2007

7 freelancers are bidding on average $91 for this job

ajay192

Please see PMB for details.

$80 USD in 1 day
(3 Reviews)
3.6
adekwa

Please see PMB for details

$100 USD in 3 days
(1 Review)
1.8
kamn1245

I am interested in this opportunity. I have about 9+ years experience working with access. Build many databases in access using visual basic & sql. Good experience with Excel too. I can help in automation of whole proj More

$100 USD in 1 day
(0 Reviews)
0.0
Infominez

Hello, we have gone through the project requirement and very much interested to take up the project. Please check PMB. Best Regards, Infominez Team.

$100 USD in 5 days
(0 Reviews)
0.0
JeffPerson

50% on contract signing and 50% for project completiom

$90 USD in 15 days
(0 Reviews)
0.0
prateekpronoc

Customer Account and Product Management System worked on this project that is why this job is easy for me. your project profile is quite similar to CAPM

$95 USD in 2 days
(0 Reviews)
0.0
MJIqbal

We have done such small projects pretty quickly. We always deliver in time a fully functional and accurate software. If you need proper reports look no further. M J Iqbal

$75 USD in 6 days
(0 Reviews)
0.0