defining patient follow up

[Diego B]

Hi,

I am defining an Access DB for clinical research purposes.
I have builded 7 Tables (patients, history, ECG, Lab...) all related
through pt_ID
and joined in a form.
I need also to configure the follow up for these patients.
What is the best way to do that with Access ?

Thank you in advance

Diego

 

[Allen Browne]

There are *many* questions you need to ask before you can decide on the best
data structure.

A basic Appointment table would have fields:
AppointID AutoNumber primary key
PatientID foreign key to Patient.PatientID (who appointment
is for)
DoctorID foreign key to your staff table (who appointment is
with)
AppointDateTime when the appointment is.
Duration number of minutes the appointment is scheduled to
take.
LocationID where the patient's appointment is.
AppointTypeID what type of appointment (ECG test, ...)
VisitID which previous visit this appointment follow up.
(optional)
PatientComment text to print on the patient's appointment card.
DoctorComment text to print on the doctor's appointment list for the
day.