Can Access administer a TEST?????

cliffsimms

Registered User.
Local time
Today, 05:11
Joined
Sep 28, 2000
Messages
18
What I would like to do is design 30 questions for a test, which only 10 questions would be used for each test given to a student.
What I would like to know is, if Access could logically select random questions from a pole of questions to develop a different test for each student?
And when the student takes the test could Access grade and give a recommendation on what to read based on what they got wrong???
 
Yes Access can do this. I would use the OnOpen event of the form to generate the question number for the relevant fields to fill from. Use the Rnd function to generate the question number
Eg: Question = 30 * Rnd + 1
I would then use the code to verify that the number has not been used before or you will get duplicate questions.
I guess that the answers would have to be multiple choice which would then allow you to create tables which have recommended reading material depending on which incorrect choice has been made.

HTH

Simon
 

Users who are viewing this thread

Back
Top Bottom