Access DB to store and grade exam results (1 Viewer)

Hi!

I am creating an access database where the results to an exam will be entered (multiple choice exam so nothing fancy), and in turn they will be graded. I have searched and the closest thing I have come to this is the survey DB with a field for each question. However since this is a exam rather than having "no right answer" this answer needs to be compared with a key. So my question is as follows:

What table structure is ideal for this? ( I have yet to find a way to compare rows )

I appreciate any help on this you can offer,

Joseph Cohen

I would make a table for the key exam and have another table for the student exams

That's what I have done so far, however I have no way of comparing the rows. Would I have to have an SQL Query comparing each individual question?

Something like this.

Thanks for the reply, i ended up building a module that would grade, now i'm stuck at the macro which is limited to how many parameters you can pass =/