Academic year in gradebook

[lima]

Hello everyone,


I have this simple gradebook in ms access from microsoft website.It registers Students names,assignment and grades in a particular class but the only problem I'm having is that when a teacher is done with a particular class in an Academic Year(2013), by 2014 he cannot go back to that same class(ID) and register new Students to that same class(ID) except he deletes previous data in that same class(ID). How can i add an "Academic Year" table to keep track of every years data.
Bellow is the link to the original file
http://office.microsoft.com/en-au/te...i:TC001018407|

[June7]

The Classes table already has a field for Year (which, btw, is a bad name because Year is a reserved word). With this arrangement, need to add class records for each year, even if all other class info remains same.

[lima]

Thanks June7, but each new record in the class table create a new class_ID. So if I am to return to the same class another year I will have to create a new class_ID different from previous year's class_ID but same class name and can my report be grouped base on year_ID which is unvailable in the database?
I'm only a beginner and trying to create a gradebook to be used by different classes at different years I don't know if another sample is available and I will welcome any suggestion.

[June7]

Yes, would need new records with new class_ID. And yes, report can be grouped or filtered by year by including the Year field in report queries.

All of the reports except for Students include the Class table in their RecordSource. Most include all fields but are not using Year in the report layout.

[lima]

Thanks june7 I will try it the way you suggested. Thanks