Please tell me how to make class register ms access way. Is there a template that can be used in MS Access that allows tracking of student attendance, to what class, and teacher? If so, where can I find them? Is it in the program itself or does it have to be downloaded?
Dear user,
For your class attendance register, I recommend you to make three tables on Ms Access, names of tables should be date, students and attendance. The students table should consist of the following fields/columns:
Student ID
Student Name
The values of the date table should be from 1-31. It does not need any field.
The attendance table should have the following fields:
Class Name
Date ID
Student ID
Present Yes/No
Hope this will help you.
Thank you.
