Database Implementation to Improve Transaction Recording Efficiency of Soeka Dimsum MSMEs Using Entity Relationship Charts
Downloads
This study examines the application of Microsoft Access as a recording system in Soeka Dimsum MSMEs which previously still used the manual method. The purpose of the study is to show how the design of an Entity Relationship Chart-based database can improve efficiency in managing financial data, stock of goods, and revenue according to the required period. The research method used was qualitative descriptive through direct data collection at MSME locations, observation of the recording process, and interviews with business owners. The results of the study show that manual recording makes it difficult for owners to obtain data in real-time and in a structured manner. The implementation of Microsoft Access has proven to be able to simplify the recording flow so that it is more accessible and ultimately increases the efficiency of the data collection process in Soeka Dimsum MSMEs. This practical database solution enables MSME owners to make faster, data-driven business decisions while significantly reducing time spent on administrative tasks, thereby allowing more focus on core business operations and growth strategies.
Afiifah, K., Azzahra, ZF, & Anggoro, AD (2022). Analysis of Entity-Relationship Diagram Techniques in Database Design: A Literature Review. Intech , 3 (2), 70–74. https://doi.org/10.54895/intech.v3i2.1682
Abubakar, R. (2021). Introduction to Research Methodology. In SUKA-Press UIN Sunan Kalijaga (Vol. 1).
Ambasht, A. (2023). Real-Time Data Integration and Analytics: Empowering Data-Driven Decision Making. International Journal of Computer Trends and Technology , 71 (7), 8–14. https://doi.org/10.14445/22312803/ijctt-v71i7p102
Anggita, SD (2018). Database Planning Process for Outpatient Medical Record System at Community Health Center. It (Informatic Technique) Journal , 6 (2), 111. https://doi.org/10.22303/it.6.2.2018.111-123
Anggraeni, D., Zikra Syah, A., Informasi, S., & Royal Kisaran, S. (2018). Tips And Tricks For Building Relationship And Query In Database. Journal of Community Service) Royal ISSN , 1 (2).
Article, I. (2023). Design of Microsoft Access-Based Inventory and Sales System for Koko Tua MSME . 4 (4), 4323–4334.
Economics Puspa Dewi Yulianty, S., & Jufri, A. (2022). Empirical Debate: Principles of Qualitative and Quantitative Methods for Research . 2013 .
Gefri, RI, Fatiyah Dzihni Mudhiah, Jannah, NR, Nazwa Livia Maulisa, Abiyyu Ramadhan Putra Setiawan, Indah Andriyani Siregar, & Derry Dardanella. (2025). Digitalization of Pakuan Milkshake MSME Data Management Through the Microsoft Access Database System. Applied Social Journal , 3 (1), 73–83. https://doi.org/10.29244/jstr.3.1.73-83
Hidayat, APH, Faza Ridhar Rahman, A., Khairani Marisda, A., Arhab, G., Cahya Kamila, N., Rizki Prabowo, R., & Husen Santosa, S. (2024). Use of Databases to Manage Sales Results Data at the KDH Sancang Coffee Shop. Journal of Applied Science, Technology & Humanities , 1 (1), 11–18. https://doi.org/10.62535/hx4h5d16
Huda, NF, & Sembiring, EE (2022). Designing a Financial Report Accounting Information System Application Using Microsoft Access 2016 (Case Study at PT Maju Industri Indonesia) . 7 , 106–120.
Irawan, S., Rumondang Sinaga, A., Kartinawati, A., Hidayat, AP, Dardanella, D., Santosa, SH, Indrawan, P., Apriliani, F., Yusri, D., Wijaya, H., Pangestu, FJ, & Rahmawati, N. (2024). Forecasting Demand for Sandals at Mulyaharja MSMEs in Bogor City. Journal of Systems and Industrial Engineering , 05 (02), 120–131.
Kemasan, D., & Usaha, B. (2025). Optimizing Visual Identity Strengthening Through Logo Creation and . 6 (2), 375–383. https://doi.org/10.47065/jpm.v6i2.2776
Pajak, E., Global, P., Dwifanty, DJ, Leobisa, JN, Bernoli, AA, Tje, E., Dima, Y., Jl, A., & Yani, A. (2025). Contribution of MSMEs to the Indonesian Economy and Opportunities and Challenges in the Digitalization Era Widya Mandira Catholic University, Indonesia . 2 .
Pamungkas, CA (2020). Introduction to Database Systems . INDONUSA PUBLISHER.
Permana, I., Ariyanto, EE, Oktavianus Tampubolon, JN, Hanan, H., & Kuswandi, ED (2025). Database Implementation in the Sa'Arina Gambang Bread MSME Using Microsoft Access. Journal of Information Systems Management and Digital Business , 2 (2), 91–102. https://doi.org/10.70248/jismdb.v2i2.1489
Prayudha, A., Husen, S., Siskandar, R., Dardanella, D., & Ferro, P. (2025). Determination of stock in inbound logistics based on optimal order quantity through Smart Application for Chicken Egg Stock (SAFCES) . 11 (1).
Razaluddin, M., & Evayani, E. (2019). Designing an Inventory Information System Using Microsoft Access. Scientific Journal of Accounting Economics Students , 4 (2), 325–333. https://doi.org/10.24815/jimeka.v4i2.12261
Walidain, CT, Gaffar, MR, & Pramono, TD (2022). Design and Development of a Microsoft Access-Based Inventory Information System (Case Study on Deu Magaza) . 1 , 51–67.
Walidain, CT, Rizal Gaffar, M., Pramono, TD, Firmansyah, Y., Niaga, JA, & Bandung, N. (nd). Design and Development of a Microsoft Access-Based Inventory Information System (Case Study at Deu Magaza). In Applied Business and Administration Journal (Vol. 1).
Copyright (c) 2025 Adiba Alia Jamilah, Rini Ambarwati, Tanisha Avriani Putri Setiawan, Maitsa Ullinnuha, Dimas Junianto
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
