What tables and fields should I use?

[Teddy]

I am looking for database design help with my tables and fields.

I have 75 questions, but I will continue to add more. I plan on giving at
least 100 answers to each question. As a result I want to be able to keep a
record of all the answers I give for a particular question.

How many tables would you recommend I use? and what fields should be in each
table?

 

[Gina Whipp]

Teddy,

Have a look at...
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[KARL DEWEY]

Search on 'Survey' for templates.

 

[Teddy]

Hi Karl. Thanks for the tip. That's a great idea. However, I should have
been more specific. My answers and my questions are going to be long and
require a memo format. That's being said would you still recommend that same
'Survey' format?

 

[Teddy]

I want to analyze the answers I give for trends/patterns. In other words I
want to see how often I am giving similar answers for the same questions.

The end result I am looking for with this database is as follows. I would
like, using VBA code, to create a macro that will present a random question
from the table in one field of the formand have the other field in the form
be a textbox (memo format) where I can answer the question and then have it
stored with all the other answers I gave for that question. After the data
is entered the process will continue with another question until I exit the
macro, probably using a button on the form. To begin with though, I am
looking for an appropriate table/field design that make sense for this
project. What do you think?

 

[Steve]

Hello Teddy,

The design of the database deoends on how you plan to analyze the answers
you give for trends/patterns and what comprises a similar answer for the
same question. Have you thoroughly thought this out? Can you provide
details.

Steve
(e-mail address removed)