RE: For Duane Hookom

I am trying to figure out the "limit to list" field. I have many anwers
that are not limited to list - the respondent may select one of the list
answers, or may write their own answer.

Can you point me in the right direction regarding how to handle this? You
mentioned having the "limit to list" field in your questions table, which I
see fine. However, I'm looking for how you use this in a data entry form,
but can't seem to figure it out.

Thanks!
--
Thanks!

Dee


"Duane Hookom" wrote:

You should be able to just stick with the forms for entering your survey
design. Everything you should need to do to encorporate your survey should be
available from the survey design form.
--
Duane Hookom
Microsoft Access MVP


"dee" wrote:

Hi again,

I guess some of my confusion comes from the fact that your database is set
up to create the surveys, etc., whereas I am starting mine from scratch.

I am trying to understand the role of each table to start with and which
tables are not necessary for me, in view of the fact that users won't be
setting up surveys.

The purpose of the database is to input the data from surveys that have been
completed over the summer. We will take the hard copy and input via forms to
the various tables.

For detailed statistics, we will be exporting to another software.

Thank you so very much for your assistance.

--
Thanks!

Dee


"Duane Hookom" wrote:

I don't believe I store the answer_id in the tbl_responses since I often
allow free text entry. I have a "limit to list" field in my questions table
that I use in my data entry form. Using the answer_id assumes all possible
answers for each question will be in the tbl_answers.

I have some fields in my table of questions that I could use for additional
functionality. For instance, if I required a numeric response type, then I
would know that I could average or total the field.

Is qstnaire_code unique in tbl_questionnaires? Otherwise I would use
qstnaire_id in tbl_questions.

Each answer from each participant for each question for each survey will
create a new record in the responses table.

You could use the levels much as I have to group questions.
--
Duane Hookom
Microsoft Access MVP


"dee" wrote:

I have downloaded your excellent survey database.

I am building a survey database from scratch and am still in the planning on
paper stage.

My tables are as follows:

tbl_questionnaires
qstnaire_id (PK)
qstnaire_name
qstnaire_code
qstnaire_description

tbl_participants
ppt_id (PK)
ppt_no
ppt_given_name
ppt_family_name
ppt_id_no
ppt_date_of_birth
ppt_gender
pregnant
rltnshp_to_hd_of_hshld
ppt_house_no
ppt_phone_no

tbl_questions
question_id (PK)
qstnaire_code (FK)
question_number
question_text

tbl_answers
answer_id
answer_no
question_id (FK)
answer

tbl_responses
response_id (PK)
question_id (FK)
answer_id (FK)
participant_id (FK)
qstnaire_date
qstnaire_start_time

tbl_interviewers
interviewer_id (PK)
interviewer_no
Interviewer_given_name
Interviewer_family_name

tbl_household_relationships
hshld_relationship_id (PK)
hshld_relationship_category (FK)
hshld_relationship_no
hshld_relationship_description

The questions are made up of the qstnaire_code field and 1, 2, 3, etc.
There are no sub questions.

While many questions limit the answer to one listed, some require text
reponse from the individual being interviewed.

The possible answers are numbered 1, 2, 3, etc., but may be 1 - male, 2 -
female on one question and 1 - Yes, 2 - No on another, etc. There are two or
three numbers that may appear that are always the same: 50 - NR and 51 -
Don't know. These answers are always numbered 50 and 51, even if they follow
answers 1, 2, 3, 4 (50, 51).

My questions, at the moment are:

1. Does my structure, so far, look sound?
2. Why in your tblQuestions do you have RespnsType, RspnsLength, etc. I
would hav thought they would be in the Reponses table.
3. I assume that I will need a record for each and every response to each
and every question.
4. I have headings at the beginning of sets of questions with the various
questionnaires - Section 1 "xxx", followed by questions pertaining to that
section, etc. Would I include that as a level in my tblQuestions?

Any guidance would be GREATLY appreciated!

Thank you so much!


--
Thanks!

Dee
.

Relevant Pages

  • RE: For Duane Hookom
    ... I have been working away and my database is really coming along nicely. ... "Duane Hookom" wrote: ... question then the new question prior to adding possible responses. ... When I add an additional question in the sub-form to any survey there is no ...
    (microsoft.public.access.tablesdbdesign)
  • RE: For Duane Hookom
    ... What I am trying to do, though, is create my own database through trying to ... "Duane Hookom" wrote: ... Everything you should need to do to encorporate your survey should be ... For instance, if I required a numeric response type, then I ...
    (microsoft.public.access.tablesdbdesign)
  • RE: For Duane Hookom
    ... I am actually working with your database - unchanged. ... When I add an additional question in the sub-form to any survey there is no ... "Duane Hookom" wrote: ... we one respondent mentioned in reply to a question I had posted. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: using lookup fields in queries
    ... I have been trying to deal with a potential survey for most of the day. ... I keep returning to Duane Hookom's survey database to try and figure it out ... I have pretty much imitated his form and subform for response entry. ... It's clear that you didn't actually work with Duane's sample database. ...
    (microsoft.public.access.queries)
  • 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)
Loading