[kmclain]

I have created the following tables per a response from Scottgem at to another user asking about creating a Access Database for a survey. My database has 26 questions with answers range being not very true to verry true with a couple simple yes no answers.

Where I am stumped is how to display this survey in a form for entering all of the information. Date completed, the couselor id, the group id and the questions. The questions are area based. Ie some questions deal with the couselor, others with the group interaction, and finally with the overall program.

The a volunteer enters the information from a paper form, and I would like to mimic the paper as close as possible, and still collect the information. Report wise I need to get averages for responses by Group, Counselor, and Program. A date range would be nice as well.

[ScottGem]

Ok Your structure is off here. I'm not sure what you want. The questions table contains the questions. The responses table either contains the actual response to the survey or info about who was responding any when. The answers table contains either the correct answers or the responses. Its just not clear which way you are going.

[kmclain]

Ok, I see what you mean.

I want to enter information from a paper survey dealing with client satisfaction.

My structure was trying to build off the advise you gave in a previous question, answer.

I need to create reports that show how well a counselor, the group, and overal program are rated. I need one Form to capture this data.

The data captured in paper form is competition date, the couselor's name and the group ID. Clients answer 26 questions, rating on a scale of 1 - 4 or yes/no. The last four questions have a comment box.

I am asking for advise on how to structure this database for a survey. i.e. a table for questions? A table for?? I have done several database's in the past, including complicated VBA coding, but I have never done a survey. I have not done surveys.

Thank-you for responding to the previous questions so quickly.

[ScottGem]

Ok, You need at least four tables here:
TblQuestions
QuestionID (PK Autonumber)
Question

TblRespondents
RespondentID
FName
LName
etc.

TblResponses
ResponseID (PK Autonumber)
RespondentID (FK)
ResponseDate

TblAnswers
AnswerID (PK Autonumber)
ResponseID (FK)
QuestionID (FK)
Answer

TblRespondents contains info about the person responding to the survey. TblResponses contains info about the Response to the survey, the Respondent, date, etc. tblAnswers contains the answers given for each question in the specfied response.

You would have a main form bound to tblResponse and the subform bound to tblAnswers. Against you can pre append a record for each question with the ResponseID as a FK or you can add them as you go along. You would then enter the answers in a subform.