Database Design Question

[Guest]

I have designed a few databases for my work. I have been recently assigned a
new one that has me a little stumped. I am looking for some suggestions as
to how to go about this.
Essentially, we have a training department that does training in the various
aspects of the job. In the various classes, the "students" take a midterm
exam to gauge the level of retention of the training midpoint in the class.
Then at the end of the class, they need to take a final exam.
My department director would like the "students" to be able to take the
exams using Access, since 99% of the questions are either multiple choice,
yes/no, true/false, or fill in the blank, and Access would be able to
"auto-grade" the tests, essentially.
I am at a loss, basically, as to the layout. The "student" information
table would be the easy part. I am unsure of how to create the tables that
would have the questions, depending on the class and whether it is a midterm
or final, with the answer choices attached.
Any suggestions?

 

[Allen Browne]

Take a look at Duane Hookom's database for handling surverys at:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

The structure you need for exams is similar to what he suggests for surveys.

 

[Guest]

You will need to make sure that your data is secure so that students cannot
manipulate the answers directly in the tables. Just something to think about
since its relatively easy to break into an Access database and update the
tables directly.

Dorian