problem with table normalization.any help most appresiated

[michael karabelas]

i have this table with students data including their
weekly wrades in order to be used in a form which
calculates totals over the month.(a1,b1,c1,d1.etc for 1st
week,a2,b2 for 2st week of the month etc)
The problem is that i have to have a form that calculates
totals over a 3 or 6 month period and for all the year. So
I tried to include more fields for every single month but
i couldn't since the 255 field limit.
The thing is that i want to have 12 different tables each
for every month that have the monthly grades of every
student,but when it comes to add a new student to the list
i wouldn't have to add his data to all the tables but only
to the main one which the other 12 tables will be linked
to.
Any suggestions will be mostly helpful.

 

[GVaught]

It might be simpler to download the database that Microsoft has on their
website Office Template page. Accessible through any Microsoft program under
the Help menu. The database is made specifically for teachers and input
grades over a period of time and calculating for you.

Check it out.
http://office.microsoft.com/templat...ID=CT063455541033&CTT=4&Origin=CT062100801033