question about tables

[Miguel Vivar]

I have a question about tables. I have a very large questionnaire with a lot
of questions, so I wonder if I should break this questions into different
tables, or should I put all questions in only one table. These questions do
not have relate one to another so I don't think I could create a relationship
between tables.

Miguel

 

[Jcraig713]

I am not sure how you have your database set up but I would not think you
need to seperate them onto different tables as when you start query's and
reports on the results, you would then have to tie them together somehow
using a primary key field. I think you should keep the questions in one main
table. It is good idea to think out what data you intend to pull from your
database. Knowing this will help you set up table design etc.

 

[John Spencer]

Duane Hookom has a sample survey database at

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

This fully functional application uses a small collection of tables,
queries, forms, reports, and code to manage multiple surveys. Users can
create a survey, define questions, enter pre-defined answers, limit to list,
report results, create crosstabs, and other features without changing the
design of any objects.

This is a good sample of how to set up a normalized survey database. In
many cases it is fully functional without the need to do any modifications
to the structure of the tables, forms, and reports.

All you need to do is add and delete records to change it for your survey.

 

[John Vinson]

I have a question about tables. I have a very large questionnaire with a lot
of questions, so I wonder if I should break this questions into different
tables, or should I put all questions in only one table. These questions do
not have relate one to another so I don't think I could create a relationship
between tables.

Miguel

If you're thinking of having one field per question... don't.

Instead, take a look at a properly normalized design: Duane Hookum's
excellent "At Your Survey" database. Download it from

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

John W. Vinson[MVP]