Design database to track Survey Results

[kirstenlargent]

I need help setting up an Access database to be able to input and analyze survey results.

I want the user to be able to enter the survey results into a form that will list the 10 questions, each with 4 possible responses. I want to have a report that will list each question and the percent for each response.
How can I best set up my tables to accomplish this?

I tried a main table with Name, Question #, and Response #, so each record was for a user’s response to a particular question. I had 3 other related tables with employee data, Question Text, and Response Text. My reports worked ok, but I couldn’t get a decent input form –
The form I came up with was based on the Employee data table, with the main survey data as a subform. But when completing the survey data in the subform, the user had to enter the question number in one field and the answer number in the next field. I would like the user to only have to enter the answer number. So it would list the 10 questions automatically, and the user would input the answers, instead of the user being faced with a blank datasheet and having to enter each question and answer number.

Am I not seeing the forest for the trees?
Thanks for any help you can give me!

 

[Onyxpurr]

I have written quite a bit of databases and believe me, survey databases are a pain in the patoush.

So my best experience?

Create two tables...
tblQuestions with fldQuestionID, fldQuestion

tblAnswers with fldAnswerID, fldCustomerID, fldQuestionID, and fldAnswer

Then, if it is a user driven database, create a macro for a certain event that will populate (append) the questionids and customerid into the table (maybe when the user logs in).

Hope that helps!!