Prev: Need template or "how to" for tracking daily/hourly animal act
Next: Best Practice
From: Steve on 10 Dec 2009 11:16
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
santus(a)penn.com


"Teddy" <Teddy(a)discussions.microsoft.com> wrote in message
news:7C9745FB-EF73-4AF1-9408-54FF1F575015(a)microsoft.com...
>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?
>> > > >


First  |  Prev  | 
Pages: 1 2
Prev: Need template or "how to" for tracking daily/hourly animal act
Next: Best Practice