Patient database

[emarq]

I am using Access 2003 for the first time and learning how to develop a
patient database for a non-profit program.

I've created a table that contains the names and personal information of
each patient participating in our program. My problem is this: I would like
to create a subform for each patient that lists their appointment history but
I don't know how to create a relationship between the patient and their
appointment history (which at the same time will allow me to enter more than
one entry).

Please help!

 

[Jeff Boyce]

If "relational" and "normalization" are unfamiliar terms, plan to spend some
time coming up to speed on them before expecting to get good use from
Access.

It sounds like you are describing one entity ([Patient]) that can have
zero-to-many records of [Appointment]. In a relational database, you'd need
two tables, related one-to-many. This would require that the Primary Key
from the [Patient] table row be included in the record/row in the related
[Appointment] table.

If that didn't make sense, go back to the first sentence and start your
studies!

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Daniel Pineault]

Well, this should be a 1 to Many relationship.

Your patient Table should be something similar to
Patient_Id
Patient_FirstName
Patient_LastName
.....

So you would construct an appointment table similar to:
Appt_Id
Patient_Id
Appt_DateTime
.....

Linking your relationship between the 2 Patient_Id fields.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[John W. Vinson]

I am using Access 2003 for the first time and learning how to develop a
patient database for a non-profit program.

I've created a table that contains the names and personal information of
each patient participating in our program. My problem is this: I would like
to create a subform for each patient that lists their appointment history but
I don't know how to create a relationship between the patient and their
appointment history (which at the same time will allow me to enter more than
one entry).

Please help!

Take a look at these resources, especially the tutorials:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


Do note, however, that any database containing patient medical data is covered
by the extremely stringent HIPAA laws. You may want to read up on these;
$50,000 fines are not fun to deal with! Some would argue that Access simply
doesn't have good enough data security for ANY patient information database.