Daily Task: Take attendance daily.
Goal: automate more.
Currently done every day:
I enter the current date, the student ID# (primary key from student table) which pulls basic demographic, and then I enter numbers 3, 2, or 1 for how many classes they attended that day. Done for each student daily.
I have the following in my db:
A Table of All students. An attendance table for historical data. Most students attend 3 classes a day; however some may attend 2 and on a rare occasion, maybe 1 class per day. A query of active students (say I've got 10 active students) that is related to the attendance table.
Hope to get:
A full class roster form....of the 10 students, with the date auto defaulted to "today"....and a default number of 3 in each attendance field. If the student does less than 3, I will manually change those numbers.(rare) Then I want the attendance information to go to the attendance table.
Thank you in advance.