Member Avatar for Xiao_1

hi do you all have any info of student attendance checking system using VB with Microsoft access woth the simple, guide, referenc or simple code on this

  • 2 Contributors
  • 2 Replies
  • 98 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by Xiao_1

Dani AI

Generated

Good start. As suggested, keep student master data separate from attendance transactions — that makes queries and reporting far simpler. The minimal, practical pattern is: one table for students, one for class/sessions (one row per meeting/date), and one junction table that records a student’s status for a given session. That lets you track present/absent/late, support multiple classes per student, and avoid storing derived totals.

Practical tips for Access + VB:

  • Use numeric Autonumber keys for PK/FK relationships (better than text IDs). Store session date/time in a Date/Time field. Keep status as a small numeric code (lookup to a Status table) to avoid typos.
  • Build a front-end form that picks class and date, shows a continuous list of enrolled students with a checkbox or status selector, and creates the session row automatically the first time you mark attendance.
  • Use parameterized ADO/DAO commands in VB to insert/update the attendance junction table (upsert pattern). Compact & Repair regularly and split the database (back-end for data, front-end for forms/code) if multiple users access it.
  • Beware: Access is file-based. For more than a handful of concurrent writers, move the back-end to SQL Server or Azure to avoid corruption and locking issues.

For reports, don’t store monthly/yearly totals as separate tables unless you must — compute them with GROUP BY queries or saved queries and index the date and student ID columns for speed. Example (Access SQL style) to count presents in a month:

SELECT a.StudentRef, COUNT(*) AS Presents
FROM Attendance a
JOIN Sessions s ON a.SessionRef = s.SessionID
WHERE a.Status = 1
  AND s.SessionDate BETWEEN #2024-01-01# AND #2024-01-31#
GROUP BY a.StudentRef;

These patterns keep the model flexible and make the VB form logic simpler.

Recommended Answers

All 2 Replies

Member Avatar for Santanu.Das

Create multiple tables like StudentInformation, DailyAttendance, MonthlyAttendance, YearlyAttendance.

Field Structures :
StudentInformation :
StudID(Text)(Primary Key), StudName(Text), StudAddr(Text).........etc.

DailyAttendance
StudID(Text),AttdDate(Date)

MonthlyAttendance
StudID(Text),MonthName(Text),Year(Text),TotAttnd(Integer)

YearlyAttendance
StudID(Text),Year(Text),TotAttnd(Integer)

Hope, itshould help you.

Member Avatar for Xiao_1

Thank you..!!

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.