Hello sir,
I am creating student attendance tracking system in asp.net.
With attendance i need to track students attendance every day and want to generate charts with those data.
Charts for Daily Attendance report, Weekly Report, and monthly Report.
For this how to design database in msaccess?
You could do this with three tables!
1. Student Table
2. Calendar Table
3. Attendance Table
Insert all student records in the student table.
Insert all working days and holidays in the calendar.
With the third table you have a choice.
You can choose to insert both present & absent students.
You could choose to insert only the absent students (assuming that everyone else who doesn't have a record was present for that day).
The structure of the table would be:
Studentid,
Date,
Status (Status "P" for present "a" for absent).
Student Table
StudentID
StudentName
Calender Table
Working Date
Holiday
Attendance Table
StudentID
CalendarID
Attendance
