What's the best way to accomplish this?

[Shek5150]

I do neuropsychological testing and on any given day I can administer
anywhere from 5 to 25-30 instruments/tests to a given patient. I think I
have a pretty good handle on setting up a database to to gather and "crunch"
the raw data; however, would it be possible to generate a comprehensive
report w/ "patient-x's" summary of results (assuming I have a separate table
for each instrument...thus resulting in numerous record sources???).

What is the best way to approach something like this?

Respectfully,

Steve

 

[Allen Browne]

The best way to do this is a relational database like Access would be to
build a suitable relational database structure.

The tables might be something like this:
- tblClient: one record for each person
- tblTestType: one record for each type of text.
- tblTestTypeDetail: one record for each component of each test type.
- tblClientTest: one record each time a client has a test.
- tblClientTestDetail: one record for each component of the client's test.

There will probably be much more to it than that, but hopefully that gives
you some idea of how to approach it. Using a correctly normalized schema is
absolutely crucial to the queryability of the data. (Certainly, 'a separate
table for each instrument' is not the right approach.)