I'm relatively new to Access so am unsure if i'm on the right lines with my system, but here goes:

The system should be able to have new records of students input, and their grades recorded.

At present I have it laid out as follows:

-tbl Pupil
--Pupil ID (pk)
--Surname
--Forename
--Year
--Address
--Phone Number
--Parent's e-mail

-tbl Present Grades
--Pupil ID
--Grade ID (pk)
--Subject
--Term
--Grade

-tbl Subjects
--Subject ID
--Name



Any advice on relationships between the tables would be appreciated. Thanks in advance.

Seems OK except that you should be holding SubjectID not Subject in tblPresentGrades. It may be more appropriate to hold ParentEmail in a separate table in case you have to deal with siblings.

You have a one to many relationship between tblPupil and tblPresentGrades, and between tblPresentGrades and tblSubject.