Help Needed Please On Access Design

[tsy]

Hi guys!

Need some help here. For a patient record system for a clinic done in
Access. First, I assumed that a nurse enters the details of the new
patient into the form. It is then printed as a report for the doctor to
write his consultation comments and prescriptions.( Can the form itself
be printed out instead?). Then the nurse enters these consultation
comments back into the form. This ends the procedure. If the same
patient comes in for consultation again, we need to search his record
from the database and it has to be displayed. Where and how to display
this? Can I display it in a form? Because the nurse needs to input the
new date of consultation for the patient and print out the record of
the patient which includes his previous consultation report and a space
for the doctor to write his new consultation report. Hence, the space
must be a sort of a string of continuous consultation reports. If this
is accomodated in a field titled 'comments', would there be enough
space to fit, say, 20 string of consultation reports, each of a maximum
of 250 words. I am finding it fairly hard to do this. Hope a kind soul
might enlighten me in the possibility of doing this. Thanking all of
you in advance!

 

[tina]

suggest you consider creating a separate "child" table for
consultation comments. perhaps four fields:

AutoNumber (as primary key)
PatientID (primary key field from patient table, as
foreign key)
ConsultationDate (date field)
ConsultationNotes (text or memo field)

you can use a subform to show existing consultation notes
and allow a new record to be added on each patient's visit.
similarly, a subreport can list all of the patient's
existing consultation notes for the doctor's review when
he writes additional notes on each visit.

hth

-----Original Message-----
Hi guys!

Need some help here. For a patient record system for a clinic done in
Access. First, I assumed that a nurse enters the details of the new
patient into the form. It is then printed as a report for the doctor to
write his consultation comments and prescriptions.( Can the form itself
be printed out instead?). Then the nurse enters these consultation
comments back into the form. This ends the procedure. If the same
patient comes in for consultation again, we need to search his record
from the database and it has to be displayed. Where and how to display
this? Can I display it in a form? Because the nurse needs to input the
new date of consultation for the patient and print out the record of
the patient which includes his previous consultation report and a space
for the doctor to write his new consultation report. Hence, the space
must be a sort of a string of continuous consultation reports. If this
is accomodated in a field titled 'comments', would there be enough
space to fit, say, 20 string of consultation reports, each of a maximum
of 250 words. I am finding it fairly hard to do this. Hope a kind soul
might enlighten me in the possibility of doing this. Thanking all of
you in advance!



------------------------------------------------

 

[Bogdan Zamfir]

Hi,

You need to setup two tables, one for patient record, and one for
consultations.

Patient table will have a key field (it can be an autonumber field), which
will be filled automatically by Access when you add a new record. With this
ID you can unique identify every patient.

The second table will be Consultations. It will have at least three fields:
Consultation ID (autonumber), PatientID long (which is a foreigh key, who
let you link consultation table with patient table), and consultation
details (a memo field, where doctor can enter as much text as he / she wants
about the consultation)

You might also want to add few more fields to Consutations table (like
consultation date and maybe time, and some other specific info, like price,
if you want to make also a billing system).

Then, for first consultation you should add two records (one in patient
table and one in Consultation), and at further consultations you only have
to add records to Consultation table. Of course, for each consultation
record you add you have to fill in patientID field with the ID of the
patient the consultation is for.

If you need any more help on this, don't hesitate to contact me.

HTH,
Bogdan

________________________
Freelance developer