Management of data on patients admitted to different internal medicine units, to make statistics on them, in order to present results to the mutuals (medical insurances).
The application had been started by the doctors themselves, in a domestic way. Our job was to enlarge the data, improve the presentation and make more statistics.
The program has a search engine for patients, which allows you to find them by last name or report number:
The patient card is divided into several sections shown below. Personal Data:
Administrative Data:
Backgrounds:
Diagnostics:
Complications:
Complementary tests:
Other information:
and the writing of the Medical Report. This report can be made from various templates (which are edited in the auxiliary files) and can be printed using Word, to achieve a better presentation, or from the Access itself:
With the entered data, Statistical Data are obtained by different criteria, and are printed in reports with lists and groupings of patients according to criteria, also by means of pie or bar graphs (we only show an example):
In addition we made a section of lists for the management with the Mutuals:
The application also has an auxiliary files section (masters):
Application made with Access. To use this application it is necessary to have the MS Access program. The application is made in Spanish language. Note: The data inserted in the images are fictitious.
