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.