Design a Database for In-House Survey

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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?
Click to expand...

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?
Click to expand...

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]
 
Back
Top