Sales and Collection - MS Access Application: A Comprehensive Reporting and Data Management Solution
Abstract
This study presents the development of a Sales and Collection System designed on the Microsoft Access platform to enhance financial management efficiency in small and medium-sized enterprises (SMEs). The system integrates relational database principles, SQL-based query processing, and Visual Basic for Applications (VBA) automation to streamline sales transactions, payment tracking, and reporting. Its architecture combines modular design, normalized data structures, and a user-oriented interface that simplifies data handling and supports real-time financial monitoring. Interactive drill-down reports transform static records into analytical insights, enabling managers to evaluate performance and prioritize collection activities effectively. The system demonstrates substantial improvements in workflow efficiency, data accuracy, and decision-making by reducing manual input, minimizing errors, and consolidating financial operations within a single environment. Despite inherent limitations in scalability, platform dependency, and cloud integration, the solution remains a practical and cost-effective option for SMEs with moderate data volumes. Future enhancements may include integration with accounting and e-commerce platforms, web-based accessibility, and mobile extensions to improve flexibility and responsiveness. Overall, the project illustrates how Microsoft Access can serve as a viable foundation for data-driven business management when supported by sound design, structured development practices, and user-centered implementation.
Article Discovery & Scholarly Lookup
DOI RegisteredAuthor Biographies
SourceCodester Community, India.
How to Cite
References
Total: 26 References- Addison-Wesley. (2013). Database design for mere mortals (3rd ed.). M. Hernandez.
- Ahn, E., Liu, N., Parekh, T., Patel, R., Baldacchino, T., Mullavey, T., … & Kim, J. (2021). A mobile app and dashboard for early detection of infectious disease outbreaks: Development study. JMIR Public Health and Surveillance, 7(3), e14837. https://doi.org/10.2196/14837
- Alexander, M., & Kusleika, D. (2018). Access 2019 Bible. Wiley.
- Andriani, W., Rosalina, E., Sriyunianti, F., Afrizon, F., & Aprila, D. (2023). Perancangan database akuntansi menggunakan Microsoft Access pada usaha konveksi Taylor Abadi. Jurnal Sains dan Informatika, 9(1), 30–36. https://doi.org/10.22216/jsi.v9i1.1643
- Barus, D., Silalahi, H., & Kurnia, B. (2024). Optimizing tax revenue through strategic management utilizing tax gap dashboard in Indonesia. Educoretax, 4(4), 526–540. https://doi.org/10.54957/educoretax.v4i4.804
Similar Articles
- Ndueso Walter, Automated Beer Parlour Billing System using VB.NET and MS Access Database , Journal Dekstop Application (JDA): Vol. 4 No. 1 (2025): June
- 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
- Katya Nanda, Information System for Distribution of Superior Livestock Assistance at BPTU-HPT Indrapuri, Aceh Besar , Journal Dekstop Application (JDA): Vol. 2 No. 2 (2023): December
- Khairul Rahmadi, Dewi Mulyati, Taufik Hidayat, Document Archiving Information System Design Using VB.NET, Banda Aceh Sharia Court , Journal Dekstop Application (JDA): Vol. 1 No. 2 (2022): 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
- Muhammad Riza, Design and Implementation of Laboratory Equipment Information System: A Case Study at SMK 1 Sigli , Journal Dekstop Application (JDA): Vol. 3 No. 1 (2024): June
- 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
- Andi Haikal, Ihsanudin, Dewi Suswati, Information System for Reporting the Provision, Procurement, and Distribution of Production Facilities at the Aceh Animal Health and Livestock Department , Journal Dekstop Application (JDA): Vol. 2 No. 1 (2023): June
- Nurbayani, Development of a Computer-Based Laboratory Equipment Record System at SMA Negeri 1 Mutiara, Pidei Regency , Journal Dekstop Application (JDA): Vol. 3 No. 2 (2024): December
- Janice Jane C. Flores-Alhaddad, Jojo Reyes, Development of Inventory Management System for Small and Medium Enterprises Using Client-Server Architecture , Journal Dekstop Application (JDA): Vol. 5 No. 1 (2026): June
You may also start an advanced similarity search for this article.