Survey Database

[Kristin]

Hi,
I am hoping someone can help, or direct me to a site that
can offer help. I am currently working on developing an
Access database for a large community survey (we'll be
seeking input from over 400 people). I am accustomed to
doing small survey databases (about 20 questions) but this
survey is over 100 questions and so I don't want to mess
things up. I often do one table, with lookup columns for
the fields containing certain responses, or a yes/no field
for questions that can have multiple selections (I'll do
one field for each possible selection). The only fields I
would normally have for these "one table databases" is
Survey ID (autonumber) and then the question fields
(either lookup, yes/no, text, memo etc). Because this is
such a large survey, I think I need to do different tables
for Questions, Answers, and responses, but am not sure how
to do this exactly. For example, I thought I could do
Questions Table: questionid and question; Answers Table:
questionid, answerid, answer; Responses Table: questionid,
answerid. But some of the answers (i.e. Very good, poor
etc) are possible selections for many of the questions. If
anyone has any advice, I'd greatly appreciate it! I do not
go into the background of Access to develop the visual
basic codes or anything; all I do are
tables/forms/queries/reports. Nothing fancy so I'll
need "simple" instructions....!!!! Thank you so much to
anyone who can help me...
Kristin

 

[Joan Wild]

Check out 'At your survey' sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Kelvin]

I would suggest grouping your tables by the type of answer.

tblQuestions: QuestionID, Question, AnswerType
tblYesNo: QuestionID, AnswerYesNo
tblMChoice: QuestionID, AnswerMChoice
tblText: QuestionID, AnswerText

You can then create a form for the question and a subform for the answer.
You can change the subform based on the answer type so that the correct
answer can be put in. Or just create a form for each answer type. This
will work better if the questions are group by type. Questions 1-10 are
Yes/No, 11-20 are Multiple Choice, etc... Otherwise you will need to use
the subform method which can be a little tricky if you are not very familiar
with access.

Kelvin

 

[Kristin]

-----Original Message-----
Check out 'At your survey' sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hooko
m,Duane

--
Joan Wild
Microsoft Access MVP




.
Thanks!! I'm printing/studying this stuff as

we "speak"...!