RE: For Duane Hookom

Duane, I am trying to use your survey database to better understand it.

I may be blond and really tired, but I don't see the buttons on the Survey
Design to delete the survey and all related questions, as mentioned in the
accompanying Word document.

Am I missing something? Help!

--
Thanks!

Dee


"Duane Hookom" wrote:

It's up to you where you want to store the information. You could actually
add questions that would allow storing the phone number, address, etc. If
this is information that may be used in more than one survey, I would
consider placing the information in a separate table and link it to
tblSrvRespns.

--
Duane Hookom
Microsoft Access MVP


"dee" wrote:

I am working with your forms and thing are coming along. A question would be:

Your tblSrvRespns contains only SrvID, RspnsID and RspnsName. My question is:

I have a lot more data for each respondent - phone number, address, etc.,
etc. They are identified more by a number than a name, BTW. Should I
include all of this in the tblsSrvRspns or have a separate table that is
related to this one?
--
Thanks!

Dee


"Duane Hookom" wrote:

Check the On Current event of the subform where the answers are entered:
<code>
Rspns.Requery
Me![Rspns].LimitToList = Me!LmtLst
If Me![RspnsType] = 1 Then
Me![Rspns].RowSourceType = "Value List"
Me![Rspns].RowSource = "Yes;No"
Else
Me![Rspns].RowSourceType = "Table/Query"
Me![Rspns].RowSource = "SELECT tblResponsesList.Rspns FROM
tblResponsesList WHERE
((tblResponsesList.QstnID=[Forms]![frmSurveyResponses]![sfrmResponses].[Form]![QstnID]));"
End If
If IsNull(Me![RspnsValid]) Then
Me![Rspns].ValidationRule = ""
Me![Rspns].ValidationText = ""
Else
Me![Rspns].ValidationRule = Me![RspnsValid]
Me![Rspns].ValidationText = Me![RspnsValid]
End If
</code>
--
Duane Hookom
Microsoft Access MVP


"dee" wrote:

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
.

Loading