Re: Questionnaire

From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 03/30/04 

Date: Mon, 29 Mar 2004 21:46:02 -0600

At Your Survey allows free text in any answer if that's how you want to
define your survey question. This doesn't work well for grabbing statistics.
If you want both a "lookup" value and a text value for each question, you
could add another field to the responses table.

An interface that displays option buttons and differing labels per question
would be a bit difficult. You could possibly append the questions with the
labels to a less normalized table structure for temporary user interface. 

-- 
Duane Hookom
MS Access MVP
--
"Basil" <anonymous@discussions.microsoft.com> wrote in message
news:CF1FD561-E518-4DEB-B8F8-58681E2DD93B@microsoft.com...
> I've actually looked at Duane's db a fair bit - very impressive, but I
think the amazing job he has done on making the design process so globally
accessible compromises the detail I want to include in this one - eg I don't
want comboboxes - I need the form to have option buttons etc - looking the
same as the hard copy questionnaire the db is based on.
>
> What are your thoughts on my design idea and whether I should incorporate
the free text field in a seperate table?
>
> Thanks loads for your time by the way Roger.
>
> Basil
>
>      ----- Roger Carlson wrote: -----
>
>      Duane Hookom has an excellent questionaire database called
AtYourSurvey,
>      which is free for the askingl.  You should take a look at it and
compare it
>      to yours.  You may just want to use it.  I have used it several times
as is.
>      You can download it from here:
>      http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
>
>      -- 
>      --Roger Carlson
>        www.rogersaccesslibrary.com
>        Reply to: Roger dot Carlson at Spectrum-Health dot Org
>
>      "Basil" <anonymous@discussions.microsoft.com> wrote in message
>      news:2F65CA0E-8753-4112-9020-312F2624F722@microsoft.com...
>      > Hiya, you may notice a post from me lower down (in
'access.forms')... it
>      was about the front end design and how to link data from a form to
tables.
>      I am working on a questionnaire entry and analysis database which is
taken
>      from a hard copy questionnaire circulated.
>      >> What I want to ask about here (so far in a very long winded way!)
is more
>      about the general db design.
>      >> I have investigated (thanx mr google!) different table
>      layouts/relationships, and think I'm close, but I need a little shove
to get
>      me there:
>      >> My current thought is that I will use 4 tables:
>      >> Table 1 - [Questions]:
>      > QID (primary key)
>      > Question Text
>      >> Table 2 - [Question Answers]:
>      > QID (primary key - duplicates allowed)
>      > Answer Value (primary key - duplicates allowed)
>      > Value description
>      >> (eg:
>      > QID    Answer Value     Value Description
>      > 1       -1                      Yes
>      > 1       0                       No
>      > 2       1                       Not satisfactory
>      > 2       2                       Satisfactory
>      > 2       3                       More than satisfactory)
>      >> Table 3 - [Respondents]:
>      > RID (primary key)
>      > Forename
>      > Surname
>      > Location
>      > Date
>      >> Table 4 - [Responses]:
>      > RID (primary key - duplicates allowed)
>      > QID (primary key - duplicates allowed)
>      > Answer Value (i.e. this is the response to the question for that
>      respondent - represented by a stored value)
>      >>> In this way, for example if the questionnaire has 10 questions,
each
>      respondent would occupy 10 records in table 4 (1 for each question).
>      >> Now I think this would work fine... but only if a value could be
assigned
>      to each question - which it can't.
>      >> There is a free text field on the questionnaire which can't be
stored as a
>      value.  How can I do this - my simple minded thought is to create a
seperate
>      table (with only 2 fields - [RID] and [freetext response]) to hold
this
>      data.
>      >> Questions:
>      > 1. Would this generally be a good layout for the database?  What
would you
>      suggest if not?
>      > 2. Is there an alternative to using a 'value' for every possible
response
>      (table 2)
>      > 3. How can I incorporate a free text answer?
>      >> Thank you so much for reading through all of this, I really
appreciate you
>      spending time trying to help me (I'm trying to do a bit helping
others, but
>      I'm no MVP!).
>      >> Baz
>
>
>