Automated Beer Parlour Billing System using VB.NET and MS Access Database
Abstract
The growing need for precision and efficiency in hospitality management has driven small and medium-sized businesses to adopt digital billing solutions. This study presents the design and implementation of an Automated Beer Parlour Billing System developed using Visual Basic .NET and Microsoft Access. The system replaces error-prone manual billing methods by integrating automated billing, inventory control, and sales tracking into a unified desktop platform. Development followed a structured methodology encompassing requirement analysis, modular programming, and systematic testing to ensure functional accuracy and security. The system architecture employs a two-tier client–server model, featuring a presentation layer for user interaction and a data access layer for database operations, enabling consistent real-time data flow. Key modules—Login, Product Management, Point of Sale (POS), Receipt Generation, Sales Reporting, and User Management—collectively enhance operational speed, billing accuracy, and accountability.
Implementation results show that automation significantly improved transaction efficiency, reduced human error, and strengthened inventory management. The interface design promotes usability, requiring minimal technical expertise while supporting role-based access and encrypted authentication. Evaluation confirmed compatibility across multiple Windows environments and reliable performance even on low-specification systems. Discussion highlights that the system’s modular structure not only simplifies maintenance but also aligns with modern design principles for small-scale business software. Although limited by its desktop architecture and database scalability, the system offers a robust foundation for future web or cloud migration. Overall, the project demonstrates that cost-effective technologies like VB.NET and Microsoft Access can deliver practical, scalable automation for small businesses—enhancing accuracy, transparency, and decision-making in hospitality operations.
Article Discovery & Scholarly Lookup
DOI RegisteredAuthor Biographies
LeastPayProject, Nigeria.
How to Cite
References
Total: 11 References- Anusuya, M. (2025). Billsmart: An automated grocery billing system using YOLO. International Journal of Scientific Research in Engineering and Management, 9(5), 1–9. https://doi.org/10.55041/ijsrem48556
- Bhise, S. (2025). Electricity billing system. International Journal of Scientific Research in Engineering and Management, 9(5), 1–9. https://doi.org/10.55041/ijsrem47243
- Bhuravane, A., Chaudhari, A., Dedhia, P., & Jagtap, K. (2025). Pavti Pustak (The invoice application). International Journal of Advanced Research in Science, Communication and Technology, 664–670. https://doi.org/10.48175/ijarsct-25188
- Johnson, M., & Smith, R. (2019). Database design for business applications. Tech Publishing.
- Kabra, K., Choudhary, B., Mule, V., Thakur, H., & Jadhav, P. (2023). Automation of Krishi market system and real-time price display system. International Journal of Advanced Research in Science, Communication and Technology, 314–320. https://doi.org/10.48175/ijarsct-9213
Similar Articles
- Thabrani Putra, Death Reporting Information System at the Camat Office in Manggeng, Aceh Barat Daya District , Journal Dekstop Application (JDA): Vol. 2 No. 2 (2023): December
- M. Yasir Aulia, Development of a Water Bill Arrears Information System Based on Microsoft Access and Visual Basic 6.0 for PDAM Tirta Mon Krueng Baro , Journal Dekstop Application (JDA): Vol. 3 No. 1 (2024): June
- Trust Moyo, Transport Management System for Africa University: A Web-Based Solution for Fleet Operations , Journal Dekstop Application (JDA): Vol. 4 No. 2 (2025): December
- Adegoke Taiwo Bashir, College Attendance System (CAS) in VB.NET and MSSQL: A Comprehensive Management Solution , Journal Dekstop Application (JDA): Vol. 4 No. 1 (2025): June
- Nguyen Thi Huong, Nguyen Van Minh, Tran Thi Lan, Design and Implementation of Employee Attendance and Payroll Information System Using Desktop-Based Application , Journal Dekstop Application (JDA): Vol. 5 No. 1 (2026): June
- Rajan Kumar, Sales and Collection - MS Access Application: A Comprehensive Reporting and Data Management Solution , Journal Dekstop Application (JDA): Vol. 4 No. 2 (2025): December
- Zia Fadhli, Munawir, Case Witness Data Management Information System at the Military Court I-01 Banda Aceh , Journal Dekstop Application (JDA): Vol. 2 No. 1 (2023): June
- Janobe Janobe, Development of Budget Management System Using Visual Basic .NET and MySQL Database: A Desktop Application for Personal Financial Tracking , Journal Dekstop Application (JDA): Vol. 4 No. 1 (2025): June
- Claudisnei Claudisnei, Parking System: A Comprehensive Management Solution for Small Parking Facilities , Journal Dekstop Application (JDA): Vol. 4 No. 1 (2025): June
- Herman, Mukhtar, Ihsanuddin, Ice Block Production Manufacturing Information System, Perum Perikanan Indonesia, Banda Aceh , Journal Dekstop Application (JDA): Vol. 1 No. 2 (2022): December
You may also start an advanced similarity search for this article.