Survey Database

[Steve]

Hello

I'm trying to create a survey database. There will be,
say, 10 questions. Some of the questions will have
responses where several items can be checked, some
questions where only one response can be checked, and
some will have an "other" response, requiring the user to
type something into a text box.

I don't know how to set up the tables and relationships
for a DB like this. I have designed many DBs over the
years, but for some reason, this one has me stumped.

Any help would be greatly appreciated.

 

[John Vinson]

Hello

I'm trying to create a survey database. There will be,
say, 10 questions. Some of the questions will have
responses where several items can be checked, some
questions where only one response can be checked, and
some will have an "other" response, requiring the user to
type something into a text box.

I don't know how to set up the tables and relationships
for a DB like this. I have designed many DBs over the
years, but for some reason, this one has me stumped.

Any help would be greatly appreciated.

Check out Duane Hookum's "At Your Survey" database:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'