No I am not an expert, despite what it says here in the forum. I was like you, starting off and learning at the same time. I made mistakes (still do
), but try to learn from them. Even though I do not use Access much these days, I am still keen to learn using it.
I was hesitant in suggesting adding a year field, as whilst that would perhaps solve your problem now, I would just be handing you a bigger shovel to dig yourself deeper into problems.
As I am not an expert it would take me almost as long as you to set up the DB correctly, however I have tried to give you a start with the attached. Which is how I would have started out. get the structure correct, BEFORE creating forms, reports etc.
It still needs work as I do not know if the exam grade should be with the lesson or the PersonLessons, depending on whether that is the grade that must be attained or student grade of the lesson/exam?
I've attached my ERD from my first DB. That links table contains nothing but
LINKS to the other tables, but that allows any ship on any date with any rank and any crewmember.
That then allows me to show data as can be seen @
http://www.bibby-gazette.co.uk/
No duplication involved.
HTH