Biulding Questionairs

[ajdesigns]

I have produced a questionair in a form with approx 50 questions with multible choice answers with "A,B or C"as the answer.
I want about 50/60 people to complete this questionair, then I want to compile thier answers in a table so that I can see how they answered each question and who had the most correct answers . How can this be done. If anyone could tell me I would be very gratefull.
Yours
AJD.

 

[Brambojr]

I am not the "hack" others in this room are, but it seems to me you are talking about creating a form and a table. The form would save the data to the table.

Now the table would need at least 51 columns - name and each answer.
Then on the form they would type their full name and proceed to the questions. Beneath each question would be an "option group" - it's on your toobar.
Link each option group to the proper column of the table.
Option gorups give numeric answers but done properly 1 would be "A" and so on. You could then create queries and reports to do as you will with the information.

 

[braindead2]

I need to disagree with Bambajor. Absolutly do not create a 50 column table It would become a query nightmare.
create tables something like this instead (rough structure)

namestbl (tracks who took survey)
name dateoftest surveyid etc...

questiontbl (holds the 50 questions)
questionnumber question correctanswer

surveytbl (tracks who took the test and how they answered each question)
surveyid questionnumber answer

create a form with the name information
and a subform based on a query that includes the questions with their answers to each question. The key fields here are surveyid and questionnumber
you can compare their answer to the correct answer and manipulate the data how ever you want.
Remember Access is a relational database. This is a quick and perhaps confusing post. See database normilization.