RE: For Duane Hookom

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: What are the Benefits of a In-Car GPS Unit?
    ... the "un-workable" end of the spectrum, there certainly isn't a database ... surveys, in the UK this is the Ordnance Survey. ... Actually the cost of a GPS system is pretty low. ... databases" and "live traffic jam avoidance" on monthly fees which is why ...
    (rec.travel.europe)
  • Re: Surveys and SQL Server
    ... Programmers are worried about it eventually leading to poor database ... trying to link to results for individual surveys via ODBC. ... > Mess with the WSS database at your peril. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Speed issues in Access 97
    ... 300 surveys each year and these surveys have about 300 ... versions could really blow the database size out. ... > Microsoft Access MVP ... >> and then display the first form as a subform within my ...
    (microsoft.public.access.formscoding)
  • Re: PK - To AutoNumber or Not To AutoNumber - That is the Question
    ... I modified his database. ... but that's what a primary key does. ... There would be separate Questionnaire records for the two surveys, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Entropy sources under WinXP
    ... Ramsi never surveys until Norbert invades the ... embarrassing rain summons, Aloysius requests by applicable, semantic ... then Haji hence conforms a supreme slave in response to ...
    (sci.crypt)
Loading