Patient Treatment History

[Jo]

I need to write an Access db for my boss. They need to be able to enter
patient treatment info as they come in and then view the patient's
previous treatment in. If I'm pointed in the right direction, I'll be
fine. Please help!

The fields I have are: Patient, Date, Clinician, 4x lookup fields and 4
fields where you manually enter treatment data. He needs a form to
search for a patient and then display that patients treatment history.

Thank you

Jo

 

[Axel Dahmen]

How much are you willing to spend? ...either on an database tutorial or on a
consultant?

Axel Dahmen

 

[Jo]

Unfortunately they only spend on my salary and I have to get it right.
I've designed the db up to the point where I need to view a report on
the history (by treatment date). So, a little advice there would be
great!

 

[John Vinson]

I need to write an Access db for my boss. They need to be able to enter
patient treatment info as they come in and then view the patient's
previous treatment in. If I'm pointed in the right direction, I'll be
fine. Please help!

The fields I have are: Patient, Date, Clinician, 4x lookup fields and 4
fields where you manually enter treatment data. He needs a form to
search for a patient and then display that patients treatment history.

Are you prepared to comply with the UK's quite stringent legal
requirements for patient information privacy, database security, and
data validation? Do you understand all those legal requirements
(including the penalties for violations)? Do £5000 or larger fines
pique your concern?

Check into this (or warn your boss to do so) before you get too deep
into this project!

That said... Don't use Tables for *ANY* purpose other than debugging.
They're not designed for data entry, searching, or editing. You'll
need several tables: Patients, with a unique PatientID and
biographical data; Treatments; etc. etc.

Use Forms for interaction with your data. Most developers will tell
you not to use Lookup Fields - see
http://www.mvps.org/access/lookupfields.htm for a critique. By all
means use Lookups ("combo boxes") on your Form to enter the PatientID,
ClinicianID, and other controlled-vocuabulary fields. Access Forms
provide multiple tools for searching, data entry, and validation;
there's a learning curve to figuring out how to use them (a steeper
learning curve if you're developing a well-secured application for
confidential data) but it's quite doable.

John W. Vinson[MVP]

 

[John Vinson]

Unfortunately they only spend on my salary and I have to get it right.
I've designed the db up to the point where I need to view a report on
the history (by treatment date). So, a little advice there would be
great!

Please describe the structure of your tables. A Report based on a
query joining the tables appropriately will give you what you want -
but we don't know the structure of your tables so we cannot advise.

John W. Vinson[MVP]