Design a Database for In-House Survey

[Guest]

I currently have a number of surveys that have been handed out to a number of
individuals. The results will be returned shortly and I have decided to use
Access to duplicate the actual survey so that I may keep track of all the
results.
The actual survey contains about 100 seperate questions. Should I just make
a Table with the following Fields (i.e. Name, Q1, Q2, Q3,Q4, ... Q100) and
use a Form to list all the questions and choose the appropriate answer?
I would then need to report and query some of the results (i.e. How many
people choose the value "Sometimes" for Q45, and so on)
Is this the best way to do such a project?

Thanks,

 

[Douglas J. Steele]

Definitely do NOT create a field with 100 fields like that!

For an example of the proper way to construct a survey, see Duane Hookom's
"At Your Survey"
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 97'
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

 

[John Vinson]

I currently have a number of surveys that have been handed out to a number of
individuals. The results will be returned shortly and I have decided to use
Access to duplicate the actual survey so that I may keep track of all the
results.
The actual survey contains about 100 seperate questions. Should I just make
a Table with the following Fields (i.e. Name, Q1, Q2, Q3,Q4, ... Q100) and
use a Form to list all the questions and choose the appropriate answer?

No. Storing data - a question number - in fieldnames is tempting but a
BAD idea. It would require rebuilding your entire database if you were
to run another survey, just for starters!

I would then need to report and query some of the results (i.e. How many
people choose the value "Sometimes" for Q45, and so on)
Is this the best way to do such a project?

Consider using Duane Hookum's excellent At Your Survey template:

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


John W. Vinson[MVP]