I write databases for schools so in principle I can assist.
However I am aware you have several active threads related to this on AccessForums.net and at least one on Utter Access. You should have mentioned that.
In fact you have been referred to a thread on AccessForums where I gave a detailed account of part of my db related to assessments.
My username there is ridders52.
The link is http://www.accessforums.net/showthre...858#post360858
See post 12
You can download a demo database from my website -click on link in my signature line below.
It contains example data for a fictitious school.
Its an accde file so you can't view the code but it may give you some ideas
With regard to your relationships window it looks similar in complexity to my main schools database.
However there too much on display for me to make any detailed comments at this point
If you wish to ask a more targeted question, that's fine.
However, follow the etiquette related to cross posting on each site.
That is explain that you are doing so and provide a link.
EDIT - just read plog's comments and agree with every word