What tables and fields should I use?

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?

Teddy,

Have a look at...
http://www.rogersaccesslibrary.com/f...osts.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

"Teddy" wrote in message
...
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?

Search on 'Survey' for templates.

--
Build a little, test a little.


"Teddy" wrote:

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?

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?

"KARL DEWEY" wrote:

Search on 'Survey' for templates.

--
Build a little, test a little.


"Teddy" wrote:

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?

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?

"KARL DEWEY" wrote:

Explain a little about how you plan on using the question and answer data.

--
Build a little, test a little.


"Teddy" wrote:

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?

"KARL DEWEY" wrote:

Search on 'Survey' for templates.

--
Build a little, test a little.


"Teddy" wrote:

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?

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



"Teddy" wrote in message
...
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?

"KARL DEWEY" wrote:

Explain a little about how you plan on using the question and answer
data.

--
Build a little, test a little.


"Teddy" wrote:

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?

"KARL DEWEY" wrote:

Search on 'Survey' for templates.

--
Build a little, test a little.


"Teddy" wrote:

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?