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?

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.