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

Sales and Collection - MS Access Application: A Comprehensive Reporting and Data Management Solution

  • 1* SourceCodester Community

* Corresponding Author: Rajan Kumar

Open Access
DOI
https://doi.org/10.59431/jda.v4i2.664
Published
Pages
58-67

Issue

Vol. 4 No. 2 (2025)

Journal Dekstop Application (JDA)
December

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.

Keywords

Microsoft Access Sales Management Accounts Receivable SME Digitization Database Application

How to Cite

Kumar, R. (2025). Sales and Collection - MS Access Application: A Comprehensive Reporting and Data Management Solution. Journal Dekstop Application (JDA), 4(2), 58-67. https://doi.org/10.59431/jda.v4i2.664

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
  • Dharmawan, W. (2025). Penerapan model rapid application development dalam pembuatan sistem informasi akuntansi penjualan dan pembelian berbasis web. Jurnal Sistem Informasi Akuntansi, 6(1), 65–73. https://doi.org/10.31294/justian.v6i1.8803
  • Farida, Y., & Desinaini, L. (2021). Designing a Microsoft Access-based administration letters and archives system at BPJS of Employment Regional Office of East Java. Matrix: Jurnal Manajemen Teknologi dan Informatika, 11(1), 42–54. https://doi.org/10.31940/matrix.v11i1.2334
  • Gill, A., Kang, P., & Amiraslany, A. (2022). Information technology investment and working capital management efficiency: Evidence from India survey data. South Asian Journal of Business Studies, 12(4), 559–574. https://doi.org/10.1108/sajbs-06-2021-0239
  • Gupta, V., & Batra, S. (2016). Entrepreneurial orientation and firm performance in Indian SMEs: Universal and contingency perspectives. International Small Business Journal: Researching Entrepreneurship, 34(5), 660–682. https://doi.org/10.1177/0266242615577708
  • Hidayat, A., Rahman, A., Marisda, A., Arhab, G., Kamila, N., Prabowo, R., … & Santosa, S. (2024). Use of databases to manage sales results data at the KDH Sancang Coffee Shop. JASTH, 1(1), 11–18. https://doi.org/10.62535/hx4h5d16
  • Kaur, P., Kaur, N., & Kanojia, P. (2021). Firm innovation and access to finance: Firm-level evidence from India. Journal of Financial Economic Policy, 14(1), 93–112. https://doi.org/10.1108/jfep-07-2020-0161
  • Longenecker, J., Petty, J., Palich, L., & Hoy, F. (2016). Small business management. Cengage Learning.
  • Microsoft Corporation. (n.d.). Microsoft Access documentation. https://support.microsoft.com/access
  • Microsoft Docs. (n.d.). Access developer reference. https://docs.microsoft.com/office/vba/api/overview/access
  • Msomi, T., & Kandolo, K. (2023). Sustaining small and medium-sized enterprises through financial awareness and access to digital finance in South Africa. Investment Management and Financial Innovations, 20(1), 317–327. https://doi.org/10.21511/imfi.20(1).2023.27
  • Nasrallah, C., Wilson, C., Hamblin, A., Hariz, C., Young, C., Li, J., … & Schmajuk, G. (2024). Patient perceptions of an electronic health record-based rheumatoid arthritis outcomes dashboard: A mixed-methods study. BMC Medical Informatics and Decision Making, 24(1). https://doi.org/10.1186/s12911-024-02696-9
  • Praharaj, S., Solís, P., & Wentz, E. (2022). Deploying geospatial visualization dashboards to combat the socioeconomic impacts of COVID-19. Environment and Planning B: Urban Analytics and City Science, 50(5), 1262–1279. https://doi.org/10.1177/23998083221142863
  • Rabiei, R., Bastani, P., Ahmadi, H., Dehghan, S., & Almasi, S. (2024). Developing public health surveillance dashboards: A scoping review on the design principles. BMC Public Health, 24(1). https://doi.org/10.1186/s12889-024-17841-2
  • Romney, M. B., & Steinbart, P. J. (2017). Accounting information systems (14th ed.). Pearson.
  • Sarhan, A., Rokne, J., & Alhajj, R. (2018). Integrating flexibility and fuzziness into a question-driven query model. Information Sciences, 430–431, 349–377. https://doi.org/10.1016/j.ins.2017.11.049
  • Shamim, T., & Ahmad, N. (2025). Mapping the intellectual landscape of digital financial inclusion, MSMEs and entrepreneurship in India. SEDME (Small Enterprises Development Management & Extension Journal), 52(3), 314–330. https://doi.org/10.1177/09708464251363283
  • Sin, C., Kim, H., Im, H., Ock, M., & Koh, S. (2023). Development and pilot study of “Smart Cancer Care”: A platform for managing side effects of chemotherapy. BMC Health Services Research, 23(1). https://doi.org/10.1186/s12913-023-09871-0
  • Stahlman, G., Yanovitzky, I., & Kim, M. (2024). Design, application, and actionability of US public health data dashboards: Scoping review (preprint). https://doi.org/10.2196/preprints.65283
  • Stahlman, G., Yanovitzky, I., & Kim, M. (2025). Design, application, and actionability of US public health data dashboards: Scoping review. Journal of Medical Internet Research, 27, e65283. https://doi.org/10.2196/65283
  • VBA and Macros for Microsoft Access. (2018). B. Jelen & T. Syrstad. Que Publishing.
  • Zaçaj, O., Beliu, E., Raço, E., Haxhi, K., & Hila, K. (2022). Comparative approach of tracking COVID-19 in Balkan countries using interactive web-based dashboard. Interdisciplinary Perspectives on Infectious Diseases, 2022, 1–6. https://doi.org/10.1155/2022/8627956

Author Biographies

  • Rajan Kumar, SourceCodester Community

    SourceCodester Community, India.

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