Advice on creating a database to record repeated blood results over time

[jjo]

Hi



I'm new to Access and am sure that what I want to do is really very simple, but I can't work it out from my reading on the web.

I want to create a database of patients with a particular condition and record the results of a series of repeated blood tests over time.

I will want, I presume, a table of the basic details - name, identifier, diagnosis, etc and then a table (?) of the blood test results that I can add to over time - blood tests 1, 2, 3 etc recorded on date 1, 2 3 etc.

I want to be able to select a patient and bring up a form that allows me to input the latest blood results for that patient. Do the latest results simply go into the next columns in a table row or is there another way of doing it?

I will then want to look at the trends over time and averages/variability etc between patients.

Any advice gratefully received, or a pointer to an existing thread/example.

Many thanks.

[ranman256]

You need some study on db tables and relationships.
you need maybe 3 tables:
1 tPerson
PersonID,Name, address, etc.

2 tTests
TestID, TestDate, PersonID, TesterID

3 tResults
TestID,Chemical ,Result

The test date would be entered into tTests table. The results of various 'Chemicals' would have the result of YES/NO in the tResult table. You could even have a tChem table to supply the various chemicals names to be tested.

[orange]

Learn/research database concepts before jumping into Access.
See the links in this post for videos and tutorials that address database design.