I am new to Microsoft Access. My supervisor wants me to create database to track student's attendance. As the year progresses, we will need to see the amount of students' absences. I looked up this previous discussion:
https://bytes.com/topic/access/answers/489019-tracking-daily-attendance-ms-access
I have also viewed other sites and still cannot find what I am looking for.
Because I am so new, I don't even know how to begin with this. I have created one table with each student's basic information: Last name, First name, Grade, Phone Number, Address, etc.
How do I create this separate table to track daily attendance? How do I track amount of student absences?