Test / Survey
Hey all, I'm trying to design a Test / Survey database.
I have posted regarding this problem before if it looks familiar to you.
Please look at the .jpg attached
I have looked at some previous survey/tests design posted on this forum and had a good table design based off of a Pat Hartman suggestion. Now i am wanting more out of the database and need more advanced options.
The main problem is how to tell which answer/OptionDetail is the correct answer for both Surveys and Tests. Maybe it would be better to separate the two? All suggestions welcomed.
Case Survey
Here is what i am trying to do. When a user decides to make a new question for a survey they will have to choose what type of question the question will be. For example say the user wants to make a survey with a answer grid question. They would choose Answer Grid from the tquestionstypeMaster combobox. Then they would have the option of choosing a type of answer grid (Satisfy3) from the tQuestionTypeOptionsMaster combo box. Say the user chose Satisfy3 then they would be presented with a list of all possible answers that the test taker would see for the Satisfy3 choice ( Very Satisfied, Somewhat Satisfied, Not Satisfied).
This is what i want as far as the survey section goes.
Case Test
A user decides to make a new question for a test they will have to choose what type of question the question will be. For example say the user wants to make a test with a Multiple Choice question. They would choose Multiple Choice from the tquestionstypeMaster combobox. Then they would have the option of choosing a type of answer grid (Single Answer, Multiple Answer) from the tQuestionTypeOptionsMaster combo box. Now comes the part where im stuck. I have to somehow get the Multiple choice selections that the test maker is entering into the tAnswers table and figure out how to tell the program to look at tAnswers insted of tQuestionTypeOptionsMasterDetails when the test taker opens up the form. I also need to figure out how to tell which multiple choice selection is the correct answer.
I hope this makes sense to everyone.
Thanks Hooks
Hey all, I'm trying to design a Test / Survey database.
I have posted regarding this problem before if it looks familiar to you.
Please look at the .jpg attached
I have looked at some previous survey/tests design posted on this forum and had a good table design based off of a Pat Hartman suggestion. Now i am wanting more out of the database and need more advanced options.
The main problem is how to tell which answer/OptionDetail is the correct answer for both Surveys and Tests. Maybe it would be better to separate the two? All suggestions welcomed.
Case Survey
Here is what i am trying to do. When a user decides to make a new question for a survey they will have to choose what type of question the question will be. For example say the user wants to make a survey with a answer grid question. They would choose Answer Grid from the tquestionstypeMaster combobox. Then they would have the option of choosing a type of answer grid (Satisfy3) from the tQuestionTypeOptionsMaster combo box. Say the user chose Satisfy3 then they would be presented with a list of all possible answers that the test taker would see for the Satisfy3 choice ( Very Satisfied, Somewhat Satisfied, Not Satisfied).
This is what i want as far as the survey section goes.
Case Test
A user decides to make a new question for a test they will have to choose what type of question the question will be. For example say the user wants to make a test with a Multiple Choice question. They would choose Multiple Choice from the tquestionstypeMaster combobox. Then they would have the option of choosing a type of answer grid (Single Answer, Multiple Answer) from the tQuestionTypeOptionsMaster combo box. Now comes the part where im stuck. I have to somehow get the Multiple choice selections that the test maker is entering into the tAnswers table and figure out how to tell the program to look at tAnswers insted of tQuestionTypeOptionsMasterDetails when the test taker opens up the form. I also need to figure out how to tell which multiple choice selection is the correct answer.
I hope this makes sense to everyone.
Thanks Hooks
Attachments
Last edited:
