Re: How to work with 'multiple response sets' in Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

OK, Tina, let's suppose all my questions are boolean and let's work with
simple checkboxes.

"tina" wrote:

comments inline.

"Wim" <Wim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F51F1D7A-17D1-4EA2-BD5F-60DEF777BD44@xxxxxxxxxxxxxxxx
Hi Tina,

That was a real lesson on data base design; very, very useful! Thank you
very much.

you're very welcome, glad it helped. :)

I studied your remarks on the structure of the database in parallel with
Duane Hookom's sample database, and that was really useful.
The structure is complex, but it gets simpler if I have only one survey
(then I don't need the Surveys table), and simpler still if all my
questions
are of the true/false type (because then I don't need the Options table) -
am
I correct?

yes, i'd agree with both of those statements. you'll need a table to store
each *survey* response, one record per response, a table listing all the
questions, and a table to store each answer to each question for each survey
response.

I understand that transferring the data from a spreadsheet style table to
the normalized database has to be done one column a time; I had hoped that
there would be a shortcut, but alas!

yeah, it's a bear - but then data migration usually is!


Now for my third question. After having normalized my database, following
your suggestions, I want my users to be able to go on answering my 60
questions as if nothing has changed, simply by clicking on a number
(between
0 and 60) of radio buttons. So what do I have to do to make that work, now
that my 60 questions are no longer linked to separate fields?

since you mention radio buttons, and True/False answer options, i'm guessing
that you envision two radio buttons to answer each question - one button for
True and the other button for False. to me, that implies that you want to
know whether or not each question is answered, or not, because the user
would have the choice of selecting the True option, or the False option, or
neither one. on the other hand, if you use a checkbox for each question, and
store the values in a Boolean (Yes/No) field in the answers table, then any
question that is not True is automatically False - there are essentially no
unanswered questions, because a skipped question has a False value - and so
there is actually no need to store the False answers, only the True answers.

i can tell you how to handle either scenario using a subform, and in fact
that's probably what i'd use myself - i'm way too lazy to do it
programmatically unless i absolutely have to! but i don't want to get into
specifics until i know which data scenario fits your purpose. post back and
let me know, please, and we'll go from there.

hth



.

Relevant Pages

  • Re: TRUE is 0 is FALSE
    ... An explicit literal - in string form - for boolean values don't seem ... equivalent simpler code that does not store a boolean in a variable. ... it will reflect the exit status of the last command in the ... the prominent shells support some form ...
    (comp.unix.shell)
  • Re: How to work with multiple response sets in Access
    ... Duane Hookom's sample database, ... but it gets simpler if I have only one survey ... each *survey* response, one record per response, a table listing all the ... and a table to store each answer to each question for each survey ...
    (microsoft.public.access.tablesdbdesign)
  • Re: At-your-survey db. Using a temp table for customised forms.
    ... You should study the "at your survey" database in more detail. ... and it doesnt put questions in variable numbers of ... > So I was thinking that perhaps I don't have to store ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Adding A Value To A Field Using Checkboxes
    ... So you can't store the value in the query. ... With a Frame Number being compulsory and duplicate frame ... then only the checkboxes will be counted for that record. ...
    (microsoft.public.access.queries)
  • Re: Crash saving boolean value to RS (Row cannot be located...)
    ... Brendan Reynolds ... > Close RecordSet ... > The issue I'm dealing with is that I was attempting to store the Gender ... >> What if you give the Boolean field a default value. ...
    (microsoft.public.data.ado)