A Vehicle Rental Management System (VRMS) is a desktop application built using VB.Net with an MS Access database backend. This project automates vehicle rental operations, including vehicle management, customer booking, billing, and rental history tracking. It provides a user-friendly interface for administrators, staff, and customers, ensuring smooth and efficient rental operations.
The system includes the following key functionalities:
- Login and secure authentication.
- Add, update, or delete vehicle details (registration number, fuel type, AC/non-AC, category, seats, rent, etc.).
- View and manage all bookings.
- Check upcoming and past bookings.
- Generate reports for vehicles and rentals.
- Book vehicles based on availability.
- Input customer details for bookings.
- Automatic rent calculation based on duration and vehicle type.
- View booking history and upcoming reservations.
- Validation of all input fields using Regex to prevent incorrect data entry.
- Database connectivity with MS Access.
- Easy-to-use dashboard for navigation.
- Secure password management and reset functionality.
- Frontend & Backend: VB.Net
- Database: Microsoft Access
- Development Environment: Visual Studio
- Other Tools: Regex validation for form inputs
Before running the Vehicle Rental Management System, it is important to configure the database connection properly.
The project uses an MS Access database located in your system. You need to update the path of the database file in the connection string to match the location where you have saved the database on your computer.
In the project, the connection string is defined in connectionStr.vb:
Public Class connectionStr
Public Shared Function con_str()
' Update this path to the location of your vehicle_database.mdb file
Dim conn_str As String = "E:\jadwinder\Tech\Project\Vehicle_Rental\Final\WindowsApplication1\vehicle_database.mdb"
Return conn_str
End Function
End Class- Locate the vehicle_database.mdb file on your system.
- Open
connectionStr.vb. - Replace the existing path with the full path to your database file.
- Save the file and rebuild the project.
Testing ensures the system works reliably, securely, and efficiently:
-
Functional Testing:
Ensures all features like adding vehicles, booking, billing, and updating records work correctly. -
Performance Testing:
Checks system responsiveness under heavy usage (multiple bookings at the same time). -
Security Testing:
Protects customer and vehicle data using authentication, access control, and validation checks. -
User Acceptance Testing (UAT):
End-users test the system to ensure usability, accuracy, and overall satisfaction.
Importance of Testing:
- Ensures accurate operations, prevents errors in bookings or billing.
- Protects sensitive customer and vehicle data.
- Improves system efficiency and user satisfaction.
- Clone the repository:
git clone https://github.com/jadwinder/Vehicle_Rental_Management_System.git