What tables and fields should I use?


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?
 
Ad

Advertisements

T

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?
 
T

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?
 
Ad

Advertisements

S

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)
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top