 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / January 2005How to create a survey database
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! 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. > 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 [quoted text clipped - 4 lines] > I can create an input form and run queries. Any help will be greatly > appreciated - thanks! >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 [quoted text clipped - 4 lines] >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%20Your%20Sur vey%202000' 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] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.