What tables and fields should I use?

  • Thread starter Thread starter Teddy
  • Start date Start date
T

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?
 
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?
 
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?
 
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)
 
Back
Top