Separate surveys tables?

[dee]

My database is broken down as such:

1. Surveys
2. Clinical data collected for each person
3. Checklists

I have received info from Duane H. regarding the checklists, but wanted to
also bounce this off of the helpful people here. To me, the clinical forms
as just more survey, as they include the repondent ID, surveyor ID, then a
list of clinical measurements, such as blood pressure, etc., which are
recorded as answers.

Am I on the right track, or is there any reason to put the clinical surveys
in a separate table?

Thanks

 

[Jamie Collins]

My database is broken down as such:

1. Surveys
2. Clinical data collected for each person
3. Checklists

I have received info from Duane H. regarding the checklists, but wanted to
also bounce this off of the helpful people here. To me, the clinical forms
as just more survey, as they include the repondent ID, surveyor ID, then a
list of clinical measurements, such as blood pressure, etc., which are
recorded as answers.

Am I on the right track, or is there any reason to put the clinical surveys
in a separate table?

Sounds to me like it is clinical data, regardless of how it was
collected (survey, admission form, electronic transmission from
general practitioner, etc) with associated compliance issues.

Then again, if you are in the business of surveys then making sense of
the answers is someone else's business. Has your client given you
requirements we're not seeing? I'm guessing that certain someone else
may appreciate you purchasing tried and tested (industry standard?)
survey software, which, for example. may supply output in a known
format, rather than you rolling your own (for which you seem to need a
lot of hand-holding...) Or is this a prototype? A confidence-building
exercise? A homework assignment...?

Jamie.

--

 

[dee]

I am trying to gain a greater understanding of access through looking at AYS
and adapting it to an example I have.

I apologize if I seem as though I need a lot of hand holding, but was under
the, perhaps mistaken, impression that this group was here for that.

My goal is simply to learn Access in depth!