Prev: Need template or "how to" for tracking daily/hourly animal act
Next: Best Practice
From: Teddy on 7 Dec 2009 21:21
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?

From: Gina Whipp on 8 Dec 2009 00:47
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

"Teddy" <Teddy(a)discussions.microsoft.com> wrote in message
news:A4D34D68-A643-4A99-975B-7BD0EAFA20E0(a)microsoft.com...
>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?
>


From: KARL DEWEY on 8 Dec 2009 10:39
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?
>
From: Teddy on 8 Dec 2009 18:41
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?
> >
From: Teddy on 9 Dec 2009 22:24
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?
> > > >
 |  Next  |  Last
Pages: 1 2
Prev: Need template or "how to" for tracking daily/hourly animal act
Next: Best Practice