best practice design

[Guest]

I am creating a database in which users can enter answers to a questionaire.
(About 200 questions.) Most of the questions are multiple choice and I would
like to be able to provide drop downs. However, there are a bunch of
questions that are a combination of yes/no and then limited text choices that
need to be chosen if the answer to the first part of the question is "yes."
For instance:

Has this person accessed vocational supports (yes/no)? If so, how many times
in the last year (a.once, b.twice, c. three times, d. more than three times.)

I can't drop everything in one table because I'll exceed Access's
restriction on the number of fields in a single table. And I know it's not
good design anyway. But I don't know how to approach the design. If someone
could point me in the right direction I would appreciate it. Thanks.

 

[Douglas J. Steele]

Each question should be a separate record, not a separate field in a single
record.

For an idea of what a well-designed questionaire should look like, take a
look at Duane Hookom's "At Your Survey"
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'