Access Database

[Abigail]

OK, you Access whizzkids, help a dunce out. I am trying to
make up some way of logging and reporting the findings of
a questionnaire.

The questionnaire has two sections - the first section is
really straight forward - Job, Location, Hours worked, so
there is one response for each heading. Easy-peasy. Then
Section Two goes and messes it all up for me by having
multiple responses to each heading. There are four
headings - Activity, Log Status, Average Time Spent,
Average Frequency. One person could put four different
activities in..so...how do I set up the database so that
the activities are all entered but still all related to
the same person. Do I just make one table with lots of
columns? Or should I make related tables? Hope that makes
sense. I have a huge box of questionnaires to get through
for the beginning of next week and not really enough time
to get through the Complete Idiots Guide to Access if I am
not sure what I am looking for or barking up the wrong
tree!! Any advice much appreciated. I know the basic
workspace of Access having done single table inputting for
mail merges etc, so should understand advice given.

Thanks.

 

[Abigail]

I am posting my own reply - have worked it out guys!
Thanks anyway.

 

[Guest]

Hi Abigail

If I understand you right, it is possible that the same person could do several activities. Then I would suggest a table with the persons job, etc and a second table with the different activities, etc. because this would be more flexible in case the possible choices increase

You will need in the first table a unique identifier for each person which have to be added to the second table of course - this can be created by Access itself

In addition you could create special tables for the different choices in Activities, etc. This would help avoiding misspelling in the fields

Regard
Bernd