Database Design Question

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?

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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steve Voorhees" wrote in message
...
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?

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

"Steve Voorhees" wrote:

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?