Skip to main content
journal@msti-indonesia.com 081377790601
Register
Articles

Automated Beer Parlour Billing System using VB.NET and MS Access Database

  • 1* LeastPayProject

* Corresponding Author: Ndueso Walter

Open Access
DOI
https://doi.org/10.59431/jda.v4i1.657
Published
Pages
1-8

Issue

Vol. 4 No. 1 (2025)

Journal Dekstop Application (JDA)
June

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.

Keywords

Automated Billing Hospitality Management Visual Basic .NET Point Of Sale System Small Business Automation

How to Cite

Walter, N. (2025). Automated Beer Parlour Billing System using VB.NET and MS Access Database. Journal Dekstop Application (JDA), 4(1), 1-8. https://doi.org/10.59431/jda.v4i1.657

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
  • Korneev, A., Devin, A., Mirsaitov, G., & Knyazev, M. (2014). Functional structure of the automated system of the choice of optimum production modes. Theoretical & Applied Science, 29–34. https://doi.org/10.15863/tas.2014.02.10.4
  • Microsoft Corporation. (n.d.). Microsoft Visual Basic .NET documentation. Retrieved from https://docs.microsoft.com/en-us/dotnet/visual-basic/
  • Microsoft Corporation. (n.d.). Microsoft Access Database Engine documentation.
  • Retail Technology Review. (2020). Point of sale systems: A practical guide.
  • Smith, J. (2018). Visual Basic .NET programming: From problem analysis to program design. Course Technology.
  • Small business automation: Strategies and solutions. (2021). Business Technology Journal.

Author Biographies

  • Ndueso Walter, LeastPayProject

    LeastPayProject, Nigeria.

License

Copyright (c) 2025 Journal Dekstop Application (JDA)

This is an open-access journal. All articles are distributed under the terms of the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

Under this license, you are free to:

  • Share: Copy and redistribute the material in any medium or format.
  • Adapt: Remix, transform, and build upon the material for any purpose, even commercially.

Attribution Requirements:
You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.

Copyright and Retention:
Authors retain copyright without restrictions and grant this journal the right of first publication under an open-access model. The journal retains non-exclusive publishing rights for archiving, indexing, and scholarly dissemination.

Usage Statistics