Our medical office wants to create a database to allow us to follow patients' long-term data.? Data included would be the basic demographics for each patient, as well as cumulative laboratory test results.? We typically see our patients in the office every 2-4 months so each patient accumulates a lot of lab results over time.
Also, we need to be able to generate simple easy-to-read graphs to give to our patients to demonstrate the trend in their lab results over time.? Many of our patients have HIV infection, and so we are monitoring specific lab tests such as CD4 count, Viral load, etc.
There is a commercial program out there ("Lab Tracker"), but it does not appear to be customizable so that we can create fields that are specific for our office.
We have approximately 1500 patients to follow.? We have Microsoft Access 2007 and we have a little experience with that, so we could use that program unless there are better options out there.