creating a quiz in Access 200

[smith7255]

I would like to create a quiz in Access 2000 for end users to take a required annual test. I don't want to be the one each year entering the information so I am looking for a way for the "super user" to enter the questions in. Once an employee enters their name and department, I want the questions to display and have them answer true or false. Now, the number of questions will vary. I am having trouble with associating the primary key for the employee with the questions. Because of that once the questions are answered one time, the answers display again when I pull that form up. I am used to using forms and subforms for adding new information. My problem now is creating the EmployeeID and associating it with questions that already exist and then the employee updating that with the answer. Is this making sense? Can anyone offer any suggestions?

 

[fneily]

You may want to read the following:
ACC2000: Sample Table Design to Support Questionnaire Applications

http://support.microsoft.com/kb/q209493/

Also, did you do a search on "quiz" or "survey" in the Access forums? I thought I saw a question like this before.

 

[mdProgrammer]

I've done something like this.

I would create a table of questions, and a table of answers that references a user (or student, or survey taker) table. The form should be a continous form that shows all questions for that user to answer. In another menu, you can add/disable (rather than outright delete, which is better if you want to see a history) questions without having to redo the form every single time.