Survey Table Design

[Guest]

I am creating a survey and need help with the table design. The survey will
consist of about 20 to 30 questions. Each question will have several options
for an answer, ranging from 2 to 5 options. Some questions will be Yes/No.
I would like to have the answers appear on the form as option buttons. I was
thinking about having one table for the questions and one for the answers.
Not all questions will have the same number of answer options and each
question may have a different type of answer (i.e., numbers, Yes/No,text)
Ultimately I would like to use option groups on my forms. Right now, I can
get this to work by using a list box for my answers, but can’t get it to work
using an option group. Any help would be appreciated.

 

[John Vinson]

I am creating a survey and need help with the table design. The survey will
consist of about 20 to 30 questions. Each question will have several options
for an answer, ranging from 2 to 5 options. Some questions will be Yes/No.
I would like to have the answers appear on the form as option buttons. I was
thinking about having one table for the questions and one for the answers.
Not all questions will have the same number of answer options and each
question may have a different type of answer (i.e., numbers, Yes/No,text)
Ultimately I would like to use option groups on my forms. Right now, I can
get this to work by using a list box for my answers, but can’t get it to work
using an option group. Any help would be appreciated.

Duane Hookum has an excellent survey database: see

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

and select the "At Your Survey" link.

John W. Vinson[MVP]

 

[Jamie Collins]

I am creating a survey and need help with the table design.

I once spent a day on a beach in Corsica writing a spreadsheet to
render simple gin rummy scores as a scoreboard using the Hollywood
scoring system. The PDA only supported the usual spreadsheet functions;
I recall using a lot of 'lookups'. When done the things was completely
useless because the time to recalculate the sheet took longer than a
hand of rummy. Still, it was a fun project to take on, the limitations
of the platform being the main challenge, and coming up with a
solution, even if impractical, gave a good sense of achievement. Like
some of the local mountains, the motivation was, 'Because it's there'.
[BTW please don't visit Corsica: I don't want you 'orrible lot going
there and spoiling the place <g>.]

A survey application in a SQL DBMS may be a fun challenge, especially
if someone else is footing the bill. However, the sensible (cost
effective?) approach is, "Buy, not build," especially (forgive me for
being blunt , when you need help with something as fundamental as the
table design.

Try googling the words 'survey' and 'software'.

Jamie.

--