I've looked at many examples of Survey databases out there, but I am still having difficulty coming up with a solution to my issue.
I am writing a database for employees to take a survey on and so then i can store and analyze the data.
i have 3 tables tblUser, tblQuestions, and tblAnswers
All questions are stored in the tblQuestions table (QuestionId, and Question)
All answers are stored in the tblAnswers table (AnswerID, UserID, QuestionID, and Answer)
The easy way to setup the database from here would be a form/subform realtionship where the subform is an optiongroup. This works great if all of your survey answers apply to every question. (i.e. Strongly AGree, Agree, Neutral, Disagree, Strongly Disagree)
However i want to provide a unique answer group to each question posed, including a couple questions that will require free text responses.
Now...I know I could create a table that has a field for every single question I am posing (and that may be the route I have to take), but I really like the idea of having my questions table seperate.
So...Is there a way where I could create a form where I pose a question based on a question from the question table (I would actually use a query) and create a custom option group to capture the answer? Keep in mind the answers will still all be stores as numeric values, except the freetext questions.
I would preferably like to group multiple questions per viewable form as well. For example: The first 4 questions are all releated, so they all appear at the same time on screen on one form, the user completes those 4 questions, and clicks a command button which closes that form and opens another for with the next 4 questions.
Thanks in advance for any insight.
I am writing a database for employees to take a survey on and so then i can store and analyze the data.
i have 3 tables tblUser, tblQuestions, and tblAnswers
All questions are stored in the tblQuestions table (QuestionId, and Question)
All answers are stored in the tblAnswers table (AnswerID, UserID, QuestionID, and Answer)
The easy way to setup the database from here would be a form/subform realtionship where the subform is an optiongroup. This works great if all of your survey answers apply to every question. (i.e. Strongly AGree, Agree, Neutral, Disagree, Strongly Disagree)
However i want to provide a unique answer group to each question posed, including a couple questions that will require free text responses.
Now...I know I could create a table that has a field for every single question I am posing (and that may be the route I have to take), but I really like the idea of having my questions table seperate.
So...Is there a way where I could create a form where I pose a question based on a question from the question table (I would actually use a query) and create a custom option group to capture the answer? Keep in mind the answers will still all be stores as numeric values, except the freetext questions.
I would preferably like to group multiple questions per viewable form as well. For example: The first 4 questions are all releated, so they all appear at the same time on screen on one form, the user completes those 4 questions, and clicks a command button which closes that form and opens another for with the next 4 questions.
Thanks in advance for any insight.
