Em Andamento

Sedation Microsoft Access 97 Report Project

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.

[url removed, login to view] 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.

Habilidades: Visual Basic

Ver mais: what is upload mean, what is meaning of data entry, what is graphs, what is data entry test, what is a data entry test like, what graph, what does entry mean, what does data entry mean, what are graphs, visual work flow, university radiology, the review board, the metric line, test review board, test board, representing graphs, representing data in graphs, range query, project work example, on line data entry test, number data entry test, microsoft number, meaning of data entry work, hard graphs, graph graphs

Acerca do Empregador:
( 8 comentários ) Malvern, United States

ID do Projeto: #138886

Premiar a:

skyztechnologies

Hi, Please check PM Thanks.

$150 USD em 2 dias
(1 Comentário)
2.7

3 freelancers estão ofertando em média $167 para este trabalho

asaikiran1979

Hi, I am an expert in MS-Access. See my PM. Thank you.

$250 USD in 5 dias
(4 Comentários)
2.6
elmoe01

Looking forward to collaborating with you. Thank you.

$100 USD in 15 dias
(1 Comentário)
0.0