Re: Suvey Database Tables

Hi Dale,

I'm using AYS and am encountering a problem.

In the form I'm using to input the questions, I want to sort by 2 levels:
MainSection, then QuestionNo.

I know you had mentioned sort fields. Can you give me some more detailed
information on how to do this?

Many thanks
--
Thanks!

Dee


"Dale Fye" wrote:

Neither of the ones I talked about yesterday. Those two tables reflect all
the possible responses to all questions (tbl_Responses) and the available
options for each question (tbl_QuestionResponses).

The table that stores the results of the actual questionnaire (or survey) is
tbl_QuestionnaireResponses, and it contains fields(UserQuestionnaireID,
QuestionID, and ResponseID).

In this particular application, the same user may be given the same survey
multiple times so we have another table (tbl_UserQuestionnaires) that
contains fields (UserQuestionnaireID, UserID, QuestionnaireID,
CompletionDate, and a couple of other fields).

HTH
Dale

"dee" <dee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FF707A51-4B08-4ACB-A5D6-59C4D28E693F@xxxxxxxxxxxxxxxx
Hi Dale - thanks for your response.

I'm not clear on which table is which... which is the table that contains
the possible answers to the questions and which table contains the actual
answer that was chosen?

Can you also explain in more detail the sort field?

Thanks!

--
Thanks!

Dee


"Dale Fye" wrote:

dee,

In a survey database that I use, we have a responses table that has a
ResponseID, and the text of the response. Then we have a
QuestionResponses
table that has a QuestionID, ResponseID, and SortOrder fields, so that we
can
assign specific responses from the Response table to each question, and
identify the sequence of the responses.

HTH
Dale

--
Email address is not valid.
Please reply to newsgroup only.


"dee" wrote:

I have received great advice regarding my database. Am reading
Database
Design for Mere Mortals and have also downloaded "At Your Survey"
database,
both of which have been extremely useful.

I am in the process of constructing my tables, which, so far are
comprised
of (in general):

tblParticipants
Id PK, Participant Number, Last, First, Address, Phone, etc.

tblSurveys
ID PK, survey name, survey code

tblInterviewers
ID PK, name of interviewer, their code

tblFamilyRelationships
ID PK, relationship number, relationship (father, mother, brother,
cousin,
aunt, etc. in relationship with the head of household)

I now want to create a table that contains the questions and another
that
contains the possible responses to the questions.

Each question is denoted by the survey code, followed by Q1, Q2, etc.
That
is OK from what I have so far created...

The answers are numbered: 1 - Yes, 2- No, etc. However, answers may
also
be 1 - male, 2 - female, etc. In other words, 1, 2, 3, 4, 5, 6, etc.
of
possible answers that can be chosen are not always the same answers.
However, I do have answers 50, 51, 52 and 53 that are always the same
(n/a,
Doesn't know, etc.)

I am OK with inputting the questions, showing the questions numbers by
displaying the corresponding questionnaire code and question number.

However, how should I approach the content of the Responses table?

I hope this is somewhat clear!




--
Thanks!

Dee



.

Relevant Pages

  • RE: For Duane Hookom
    ... question then the new question prior to adding possible responses. ... "dee" wrote: ... When I add an additional question in the sub-form to any survey there is no ... "Duane Hookom" wrote: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Questionnaire
    ... "Basil" wrote in message ... > And what a great system At Your Survey is too... ... > - User interface populates both the normal respondents table as ... into the main responses table - with 1 record per answer. ...
    (microsoft.public.access.tablesdbdesign)
  • REPOST + Begging: Multiple Apps on UNIX?
    ... We originally posted this survey two days ago and have not received ... anywhere near the number of responses we desire. ... single UNIX systems? ... Of the UNIX servers you have knowledge of, ...
    (comp.sys.sun.admin)
  • REPOST + Begging: Multiple Apps on UNIX?
    ... We originally posted this survey two days ago and have not received ... anywhere near the number of responses we desire. ... single UNIX systems? ... Of the UNIX servers you have knowledge of, ...
    (comp.security.unix)
  • Re: Limit of 1050 columns for ANSI joins
    ... Many self joins have to be made to do online reporting and exporting data ... survey's responses, with each column being a response. ... everytime someone creates a survey, but that doesn't happen as often as ...
    (comp.databases.oracle.server)