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

Rajan Kumar

doi:10.59431/jda.v4i2.664

Quick Links

Journal

Home: Journal Home
Current: Current Issue
Archives: All Issues
News: Announcements
Search: Search Articles

About

About: About Journal
Team: Editorial Team
Reviewers: Reviewer Team
Indexing: Indexed In

For Authors

Guidelines: Author Guidelines
Submit: Submit Article
Fees: Publication Fees

Policies

Ethics: Publication Ethics
Review: Reviewer Guide
Access: Open Access
Contact: Contact Us

081377790601
journal@msti-indonesia.com
Mon - Sat: 08:00 - 15:00

Articles

PDF

Articles

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

Rajan Kumar

View Author Affiliations

Rajan Kumar: SourceCodester Community, India

DOI:

https://doi.org/10.59431/jda.v4i2.664

Published:

December 12, 2025

Pages:

58-67

126

Views

76

Downloads

Article Metrics

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

Author Biographies

Rajan Kumar

SourceCodester Community

SourceCodester Community, India.

Article Identifiers

Article Title: Sales and Collection - MS Access Application: A Comprehensive Reporting and Data Management Solution
DOI: 10.59431/jda.v4i2.664
Publication Date: 2025-12-12

Journal: Journal Dekstop Application (JDA)
Volume: 4
Issue: 2
Pages: 58-67

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

Article Statistics

Downloads

Download data is not yet available.

Issue Information

Article Details

Volume:	4
Issue:	2
Year:	2025
Published:	2025-12-12
Pages:	58-67
Section:	Articles

View Full Issue

Additional Information

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