school grades database

[lockstock]

Hi,

I'm building a db for all the grades of my pupils of the class.

So i want to be able to make a 'new exam' that consists of different questions (in text)

Then all those questions must come on a report so that a can print an overview of all the the test, questions, and grades of one single pupil.
But when i change a question it has to be able to change on every pulis report.

Access is pretty new to me, so i was only able to make a db design that could make the report for me, but had a problem the make the edited questions change on every pipils report.

Can anyone here give me some hints to make this work?


Thanks

[ranman256]

You'd have a tPupil table and a tTest table and a tGrade table.

tPupil
------
pupilID. (Autonumber)
FirstName
LastName
etc

tTest
-------
testID (auto)
TestDate
Subject

tTestQ
------
testID (long)
Q# (Integer) question#
Q. Question
A. Answer


tGrades
------
pupilID (long)
testID. (Long)
Grade

[lockstock]

thanks for the help,

if i'm right you made a scheme where the grades are now for each pupil for each test? But what i'm trying to accomplish is the grades for each pupil for every single question.

[lockstock]

..And still able to edit the questions for each test