Simple Student Enrollment System in MS Access Using VB.Net

This source code is all about Simple Enrollment System in MS Access Using VB.Net student enrollment system enables students to enroll into their subjects prior to the commencement of their semesters.

Easy-to-use enrollment mechanism! This technique attempts to reduce everyone’s effort and stress during the enrollment process. This is a user-friendly system, which means that anyone can use it, especially its functionality.

There will be no more time-consuming manual enrolment transactions because this automated enrolment system is so much better.

It can assist save time, money, and worry. Microsoft Visual Studio 2015 and Microsoft Access Database are used in this system.

Features of the System:

• Admin Login
• Manage User Accounts
• Add Students
• Add Subjects
• Subject Fees
• Manage Students

Log in as Admin Credentials:

User: A
Pass: A

You are welcome to download the source code and edit it as you see fit. The source code is divided into two versions: one is the original version written with Microsoft Visual Studio 2015, and the other is an improved version that allows the project to operate with Microsoft Visual Studio 2019. Follow the steps below to complete the project.

How to run the student enrollment system:

Requirements:

• Microsoft Visual Studio 2015 or 2019 can be downloaded and installed.
• Visual Studio is a program developed by Microsoft.
• Microsoft Office or Microsoft Access Database Engine should be downloaded and installed.
• Crystal Reports can be downloaded and installed.
• Execute the Project
• The zip file should be downloaded and extracted (download button is located below)
• In the extracted file, look for the “EnrollmentSystemII.sln” file.
• Using your Microsft Visual Studio software, open the solution or “.sln” file.
• To start the project, use the “F5” key on your keyboard.

If you have any comments or suggestions about the Simple Student Enrollment System in MS Access Using VB.Net Please Message us Directly:

Download Source code here:

Other articles you might read also:

• Online Bus Reservation System using Mysql in PHP
• Complete Hotel Management System
• Online Ordering 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 Simple Student Enrollment System in MS Access Using VB.Net

• Student information. Personal info, guardian details, enrollment status, and program of study.
• Enrollment / registration. Term-by-term subject selection with prerequisite checking.
• Grading system. Teacher input for quiz, exam, and project scores with weighted average computation.
• Report card generation. Printable grade slip and transcript of records.
• Library / borrowing (optional). Track book borrowing, return date, and fine computation.
• Announcements and news. Post school-wide bulletins visible from the login screen.

Common enhancements for capstone review

• Online portal. Add ASP.NET web portal so parents and students see grades from home.
• SMS grade notification. Auto-send new-grade alerts to the parent’s registered mobile number.
• Digital ID card generation. Print student ID with photo, QR code, and academic year.
• Alumni tracking. Extend the database to include post-graduation contact info and current employer.

Project timeline estimate for BSIT capstone

Typical BSIT capstone teams complete a VB.NET project of this scope in one full academic semester. Suggested timeline:

• Weeks 1-2. Requirements gathering, interview with the target user or institution, and initial documentation of Chapter 1.
• Weeks 3-4. Design phase: use case diagram, DFD, ER diagram, and mockup screens on paper or Figma.
• Weeks 5-8. Core development: database schema in MySQL, main forms in Visual Studio, CRUD operations.
• Weeks 9-11. Reports, printing, and user roles. Test with actual sample data from the target institution.
• Weeks 12-13. Documentation: finalize Chapter 3 methodology, Chapter 4 screenshots, and Chapter 5 conclusion.
• Week 14. Mock defense with adviser, corrections, and final panel presentation.

Panel questions this project typically gets

Prepare answers to these questions before your capstone defense — panel members ask them almost every time:

• What existing systems are similar and how is yours different? Prepare a comparison table showing 3-5 alternatives (usually commercial products or older thesis work) and the specific gaps your project addresses.
• How do you validate data entry to prevent bad input? Walk through the validation logic on 2-3 key forms, showing regex checks, range validation, and required-field enforcement.
• How does the system handle concurrent access? Explain your database transaction strategy — SQL locking, timestamps, or optimistic concurrency.
• What is your backup and disaster recovery plan? Have a documented backup schedule (daily, weekly) and a restore-from-backup demo ready.
• How would you deploy this in production? Explain the Windows installer, database setup script, and how updates would be delivered.

Deployment options after the defense

Once you graduate, this system can be extended into a real product with these deployment paths:

• Local Windows install. Package with Visual Studio’s built-in ClickOnce installer for small businesses that only need one computer.
• Multi-terminal LAN. Host MySQL on one server PC and let 3-5 client PCs connect over the office network.
• Cloud migration. Move the database to Azure SQL or AWS RDS and keep the Windows Forms front-end for existing users.
• Web rewrite. Rebuild the front-end in ASP.NET Core or React while keeping the same database and business logic.

Common defense pitfalls to avoid

• Empty database. Always pre-populate 20-50 realistic sample records so demos are meaningful — an empty grid looks unfinished.
• Missing error handling. Panel members love breaking your system. Wrap every database call in Try/Catch and show user-friendly error messages.
• No printable output. Every capstone panel expects at least one printable report. Add a Print Preview form.
• Untested login. Prepare a demo Admin user, a demo Encoder user, and confirm both work before showing the panel.
• No backup demo. Have a scripted database-backup and restore demo ready in case the panel asks.

Where to get help while building

• itsourcecode.com free downloads. Browse other VB.NET projects for similar patterns and code examples.
• Microsoft Learn VB.NET docs. The official reference for language syntax and .NET class libraries.
• Stack Overflow VB.NET tag. Fastest place to get unstuck on a specific error message.
• YouTube capstone walkthroughs. Search for demos of similar systems to see how other students structure their defense.
• Your adviser. Regular check-ins keep the project on track and surface issues early rather than at defense day.