Thanks... I kind of get it now!
Going forward, I would first go backwards and fix those tables. Have a look here...
http://www.access-diva.com/dm7.html
This is just an example to show more of what we should be seeing for Table structure.
I realized you inherited this database but what you inherited was a database that thinks its an Excel Spreadsheet on steroids. Fixing that will make a lot of things easier, including adding a new Student.
Wow, you are good. Currently some of this is tracked using a basic excel workbook and I am trying to streamline that process as well as include all of the things that my office tracks. Let me take a look at this link and I'll get started on fixing things.