student-attendance-management-system

---

📋 Table of Contents

• Overview
• Demo Video
• Tech Stack
• Features
• Screenshots
• Installation
• Developer Notes
• Contributing
• License
• Copyrights

---

🎯 Overview

✨ Student Attendance Management System (SAMS) is a Windows desktop application built with Visual Basic 6 and Microsoft SQL Server Express to help educational institutions manage attendance efficiently. It delivers a user-friendly interface with clear navigation for admins and students, guiding them through tasks like adding records or marking attendance in just a few clicks. It offers a one-click installer that sets up the application and database automatically, clear role-based dashboards for administrators and students, fast attendance marking, and detailed reporting. With its modular design and simple workflows, SAMS makes tracking attendance straightforward and reliable. Experience a seamless and complete attendance management solution designed for real-world academic use.

---

🎥 Demo Video

▶️ Click the thumbnail above to watch the full SAMS project demo on YouTube.

📘 This demo video provides a complete walkthrough of the SAMS project, including installation, login flow, dashboard features, and attendance tracking. If you're new to the project or need a quick understanding of how it works, we recommend watching the video before proceeding with installation or development.

---

🛠 Tech Stack

The SAMS application is built using classic technologies suited for reliable offline desktop systems:

• Programming Language: Visual Basic 6.0
• Database: Microsoft SQL Server Express 2022
• Installer: Inno Setup (via sams_installer.iss)
• Architecture: MDI (Multiple Document Interface) design
• Database Connectivity: ADODB
• Setup Automation: Batch script–based SQL database restoration during first run

---

✨ Features

SAMS is equipped with powerful and practical modules tailored for managing student attendance in educational institutions. Below is a breakdown of its key capabilities:

👨‍🏫 Admin Panel Features

• 🔐 Secure login authentication with validation for each admin
• 👨‍🎓 Add, edit, and manage student records with photo upload
• 👥 Add/edit/delete admin users with full details
• 🗓️ Mark daily attendance for all students from one interface
• 🔄 Update or delete existing records as needed

👨‍🎓 User Dashboard Features

• 📆 View detailed attendance reports by selected date
• 📊 Access per-student and full class attendance summaries
• 📄 Generate reports for: Student Details, Admin Details, Date-wise Attendance, Overall Attendance
• 🎨 Color-coded status labels for better readability (e.g., green for present, red for absent)
• 📋 Interactive report viewer with export-ready formatting

⚙️ Application Features

• 💾 First-launch automated database creation and restoration via batch script
• 📦 One-click installer that bundles SQL Server and runtime dependencies
• 🪟 MDI (Multi-Document Interface) for multitasking within the app
• 📚 Built-in help/documentation section (PDF)
• 🔒 Form tracking system to prevent multiple instances of the same window

---

🖼️ Screenshots

Below are complete interface screenshots from the SAMS application, covering all key modules and workflows — including login, admin controls, student management, attendance marking, user dashboard, and detailed reports.

📌 This gallery includes all major forms and features of the project to give a full visual understanding of how SAMS works.

---

🚀 Installation

Follow these steps to install and run the SAMS application on your Windows system:

1. Download the Installer

   • Go to the Releases section.
   • Download the latest version of SAMS_Setup.exe.

2. Run the Installer

   • Double-click SAMS_Setup.exe.
   • It will install the application, SQL Server Express (if not already installed), and restore the SAMS database automatically.

3. Launch the Application

   • Use the desktop shortcut or Start menu to open the app.
   • Log in using the default admin credentials and begin exploring the application's features.

4. Need Help?

   • 📺 Refer to the Demo Video above for a full walkthrough of installation and usage.

💡 No manual database setup is required — everything is bundled with the installer for a seamless experience.

---

🧑‍💻 Developer Notes

If you are a developer and wish to rebuild or customize the SAMS installer, complete instructions are available in:

📁 Package/RebuildInstructions.md

This includes:

• How to clone the repo
• Where to download the full external installer package
• Folder structure required to compile
• Steps to build the SAMS_Setup.exe using Inno Setup

⚠️ End users do not need this. This is only for those who want to audit or regenerate the installer manually.

---

🤝 Contributing

Contributions are welcome!

If you'd like to improve this project, fix issues, or suggest new features:

1. Fork the repository
2. Create a new branch for your changes
3. Submit a pull request with a clear explanation

You can also open issues for bugs, ideas, or questions.
Thank you for helping make SAMS better!

---

📜 License

This project is licensed under the CC BY-NC 4.0 License.
You may use and modify this code for personal or educational purposes—see LICENSE for full details.

---

©️ Copyrights

© 2025 Prashanth Kumar G. All rights reserved.
Unauthorized commercial use or redistribution is prohibited without prior written consent.

---