Form design for questionnaire

[Tom_F]

To comp.databases.ms-access --

I have a questionnaire for which I would like to design a MIcrosoft
Access form. I understand that the proper Access table structure would
be:

Respondent_ID Question_ID Response
101 1 Yes
101 2 No
101 3 Yes
102 1 Yes
102 3 No

But -- it is not clear how I could design an Access form that would
allow easy data entry.

On the other hand, using the "wrong" table structure:

Respondent_ID Question_1 Question_2 Question_3
101 Yes No Yes
102 Yes No

it is easy to design a form where one can enter all the information for
one Respondent on one screen -- i.e. very much like the paper
questionnaire, with everything for one person on the same sheet of
paper. And one does not have to fill in the Question_ID -- it is
already on the screen since it is a field name.

Of course, the situation gets really dire when there are more than 255
fields (the Access limit) to deal with, and one cannot easily do it the
"wrong" way any more!

So -- how could I design a useful data entry form for the "correct"
table design -- the first one listed above? Thanks very much! Best,

--Tom F.

[Tom]

Take a look at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane

It will either get you started on the right track of doing your own, or
you can just use Duane's.

Tom
Tom_F wrote:

To comp.databases.ms-access --

I have a questionnaire for which I would like to design a MIcrosoft
Access form. I understand that the proper Access table structure would
be:

[MGFoster]

Usually, one uses a subform to hold the responses. The main form would
hold the Respondent's info.

Duane Hookum has an example survey DB on his website. Look at that for
and example of how to do it.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Tom_F wrote:

To comp.databases.ms-access --

I have a questionnaire for which I would like to design a MIcrosoft
Access form. I understand that the proper Access table structure would
be:

Respondent_ID Question_ID Response
101 1 Yes
101 2 No
101 3 Yes
102 1 Yes
102 3 No

But -- it is not clear how I could design an Access form that would
allow easy data entry.

On the other hand, using the "wrong" table structure:

Respondent_ID Question_1 Question_2 Question_3
101 Yes No Yes
102 Yes No

it is easy to design a form where one can enter all the information for
one Respondent on one screen -- i.e. very much like the paper
questionnaire, with everything for one person on the same sheet of
paper. And one does not have to fill in the Question_ID -- it is
already on the screen since it is a field name.

Of course, the situation gets really dire when there are more than 255
fields (the Access limit) to deal with, and one cannot easily do it the
"wrong" way any more!

So -- how could I design a useful data entry form for the "correct"
table design -- the first one listed above? Thanks very much! Best,

[Tom_F]

Thanks for the pointer to Duane Hookum's DB! I've downloaded it and
will study.... Best,

--Tom F.