Attendance System using RFID in VB.Net and mySQL

Attendance System using RFID in VB.Net and mySQL

Attendance System using RFID in VB.Net and mySQL is a system where it uses the radio frequency ID technology. This system gets the attendance of incoming and out coming of students inside and outside of the school.

The Attendance Monitoring System is a software-based system with simple functions that can be learned quickly. This is very useful for keeping track of and monitoring student attendance on campus.

The teacher can keep track of the pupils’ attendance by scanning their ID with RFID technology. Due to the amount of time required for teachers to obtain the essential data from pupils, you can save a lot of effort and time by using this approach.

You may also rest certain that the data is secure, and it’s a really effective way to track student attendance. This is made up of Visual Basic 2015, Microsoft Access Database, and Bunifu Frameworks to assist flatten and modernize your desktop application.

Abstract

In today’s world, attendance is a major concern for each foundation. A paper-based approach is the traditional way of admitting attendance.

Students’ failure to sign the attendance paper, lecturers overlooking the attendance list in the study hall, and students signing or marking illegally for a truant are only a few of the issues.

It is vital to depart from the traditional system and to bring better solutions to the difficulties that are now being addressed.

The Internet of Things (IoT) is one of the most important tools for resolving the problem. This study examines the creation and implementation of an IoT attendance system based on the RFID principle.

Radio Frequency Identification (RFID) is a fairly advanced technology for automatic attendance systems, according to this investigation, and it provides significantly improved accuracy and performance than older paper-based systems.

Furthermore, it has been determined that, even if RFID is utilized, a second verification method is critical in reducing cheating and enhancing reliability.

Finally, each of the systems covered in this research has its unique set of benefits and drawbacks. Some features are beneficial to some systems while others are not.

To solve this, a hybrid model is required, which must ensure that the system is more secure, reliable, low-cost, and performs better.

In this case, the “RFID four tire system with biometrics” might be utilized in conjunction with a sufficient number of RFID tag readers and finger print devices to ensure the system’s security and reliability.

System Features:

1. Sends SMS to parents of students (depending on the registered contact number upon enrolling).
2. Sends SMS to the faculty and employees of the school upon logging in, logging out, lunch in and lunch out.
3. Time restriction upon tapping continuously of RFID (5 minute time interval)

In order for the Attendance System using RFID in VB.Net and mySQL to be fully functional, you need to purchase or have in hand a RFID scanner with sample RFID’s.

Attendance System using RFID in VB.Net and mySQL is dedicated for schools and universities, any other institutions may not be suited for the system.

Watch here before you proceed with a sample Attendance monitoring system used in school activities.

RAR Extraction Password:

Password: luffypirates

For questions or any other concerns or thesis/capstone creation with documentation, you can contact me through the following:

E-Mail: [email protected]

Facebook: facebook.com/kirk.lavapiez

Contact No.: +639771069640

To download the source code, click here.

Ian Hero L. Lavapiez

BSIT Graduate

System Analyst and Developer

Related topic(s) that you may like:

• Voting System Source Code using VB.Net and mySQL
• Complete Award Automated Recording System

Technology stack and requirements

To run this VB.NET project, you need the following on your development machine:

• Visual Studio 2019 or later. The free Community Edition is enough for building, debugging, and running the project.
• .NET Framework 4.7.2 or higher. Most Windows 10 and 11 systems have it preinstalled through Windows Update.
• MySQL Server 8.0 or MSSQL Express 2019. Choose whichever your capstone panel prefers; both work with VB.NET data adapters.
• MySQL Connector/NET or SqlClient library. Add via NuGet Package Manager inside Visual Studio.
• Crystal Reports (optional). Required only if the project generates printable reports; install the runtime redistributable.

Installing the source code

The download link contains a ZIP archive with the full solution. Extract and set up in five steps:

1. Extract the archive to a folder outside Program Files (avoids permission issues).
2. Open the .sln file in Visual Studio. It loads the full solution with all forms and modules.
3. Restore NuGet packages. Right-click the solution then Restore NuGet Packages if prompted.
4. Import the database. Locate the .sql file in the archive and import via phpMyAdmin (MySQL) or SQL Server Management Studio.
5. Update the connection string in App.config or module code to match your local database name, user, and password.

How to use this project for your BSIT capstone

This VB.NET project maps cleanly to standard BSIT capstone documentation. Suggested chapter alignment:

• Chapter 1 (Introduction). Discuss the problem the system solves in real-world context. Cite Philippine business or academic use cases where a manual process could be replaced.
• Chapter 2 (Review of Related Literature). Compare this system’s features against 5-10 similar published projects. Cite journals like IJERT or IEEE Access for academic-standard sources.
• Chapter 3 (Methodology). Include Use Case Diagram, Data Flow Diagram, Entity Relationship Diagram, and Activity Diagram covering all major workflows in the system.
• Chapter 4 (Results and Discussion). Screenshot each module of the running system with a caption explaining what data it processes and which user role interacts with it.
• Chapter 5 (Conclusion and Recommendations). Identify features that could be added in a Version 2, such as web dashboard, mobile app, or REST API export.

Modules typical of Attendance System using RFID

• Employee master data. CRUD forms for employee profile, position, salary rate, and hire date.
• Attendance logging. Time-in / time-out entries via biometric device, RFID card, or manual entry.
• Payroll processing. Compute basic pay, overtime, deductions (SSS, PhilHealth, Pag-IBIG), and net pay per period.
• Leave management. Application, approval workflow, and running leave-credit balance per employee.
• Reports. Daily time record (DTR), payslip generation, monthly summary, and government-mandated forms.
• User management. Role-based access (HR, Payroll Officer, Supervisor, Employee self-service).

Common enhancements for capstone review

• SMS notification. Send late-arrival alerts to the employee’s registered mobile via a Semaphore or Twilio integration.
• Biometric device support. Integrate with a ZKTeco or Suprema time-and-attendance device via SDK.
• Web dashboard. Add an ASP.NET dashboard so managers can view attendance from any browser.
• Government compliance reports. Auto-generate SSS R3, PhilHealth RF-1, and BIR 1601-C forms in the correct format.