How to create a survey database

[Scott Gomer]

I'm new but have a basic knowledge of Access. Here's my dilema - I have a
survey with several types of responses. I can figure out the tables for
simple yes/no questions or "pick from the list". My problem is setting up a
table for a question with multiple responses. In this case, we're polling a
radio/TV audience about the times they're tuned in. I have set up each
question as a separate table but don't know how to link them all together so
I can create an input form and run queries. Any help will be greatly
appreciated - thanks!

 

[Scott Gomer]

I forgot to give an example. We ask when the audience watches TV. They can
check any box (for example M-F 8pm to 10pm and Saturdays 6pm to 8pm and
Sundays all blocks from 11am to 8pm). We also ask them where they watch TV
and they can give several possible replies.

 

[John Vinson]

On Wed, 19 Jan 2005 08:15:02 -0800, "Scott Gomer" <Scott

I'm new but have a basic knowledge of Access. Here's my dilema - I have a
survey with several types of responses. I can figure out the tables for
simple yes/no questions or "pick from the list". My problem is setting up a
table for a question with multiple responses. In this case, we're polling a
radio/TV audience about the times they're tuned in. I have set up each
question as a separate table but don't know how to link them all together so
I can create an input form and run queries. Any help will be greatly
appreciated - thanks!

Whoa. You're WAY off track. If your survey had 229 questions (and yes
I've seen such surveys) you'ld need a totally unwieldy 229 tables!
Data should be stored *in tables*, not in table names!

Consider a totally different design. Duane Hookum has an excellent
Survey sample database at

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

This uses a table of Questions related one-to-many to a table of
Answers, allows for single or for multiple-answer questions, has
sample forms, and so on. It's an excellent teaching tool as well as a
very capable application in its own right.

John W. Vinson[MVP]