I am a very new user tasked with designing a datbase to manage student records for a small (120 student) program.
My priority task is to create a form that will allow teachers to enter monthly attendance data, progress and grade data for each student enrolled in their courses (typically three). I would like them to be able to select their name from a combo box and then choose the week they wish to add the attendance for each student. They need to be able to access previous records to update if necessary.
I have (as far as I know) all the tables and relationships established. I just thought I would seek some advice before I began trying lots of different things before I stumbled upon the simplest and best way to do it.
Any and all suggestions are appreciated.
Thnaks in advance.
Take care,
Daryl