Microsoft Access and VBA Integration for Digital Records Management: A Case Study of BUMDes Sumber Sejahtera Pujon Kidul

Nunung Aliyati Fajer; Fahmi Muhammad Az Zuhri; Tri Istining Wardani; Rena Feri Wijayanti; Lelly Nisah

doi:10.63922/ijebir.v5i06.6746

Nunung Aliyati Fajer Lecturer, Business Administration Department, Politeknik Negeri Malang.
Fahmi Muhammad Az Zuhri Lecturer, Business Administration Department, Politeknik Negeri Malang.
Tri Istining Wardani Lecturer, Business Administration Department, Politeknik Negeri Malang.
Rena Feri Wijayanti Lecturer, Business Administration Department, Politeknik Negeri Malang.
Lelly Nisah Student, Business Administration Department, Politeknik Negeri Malang

DOI: https://doi.org/10.63922/ijebir.v5i06.6746

Keywords: Digital Archives, Microsoft Access, VBA, Records Management, BUMDes

Abstract

Digital archive management plays a role in supporting the administrative process and information availability in business organizations. This study aims to examine the integration of Microsoft Access and Visual Basic for Applications (VBA) in the management of digital archives in BUMDes Sumber Sejahtera Pujon Kidul. The research uses a case study approach with a descriptive-evaluative design. Data were obtained through observation of the archive management process and application testing using black-box testing. Microsoft Access was used to manage archive data, classification, and system settings, while Microsoft Word and VBA were used to generate outgoing letters based on predetermined templates. The test results showed that the application can support the management of incoming and outgoing letters, classification, storage, and retrieval of archives in a more structured manner. The integration of Microsoft Access and VBA also supports the uniformity of the process of making outgoing letters and organizing documents. The research concludes that the integration can support the management of digital archives and administrative processes in BUMDes Sumber Sejahtera Pujon Kidul.

References

Afifah, R., & Ismaya. (2025). Pengelolaan Arsip Dinamis Berbasis Elektronik Pascaimplementasi Sistem Informasi Administrasi Pejabat Pemerintahan New Version (SIAPP NV): Studi Kasus pada Biro Administrasi Pejabat Pemerintahan, Kementerian Sekretariat Negara. Khazanah: Jurnal Pengembangan Kearsipan, 8(2).
Alisa Alaina, Isti Prabawani, & Ode Merlim. (2023). Penyusunan Sistem Pengelolaan Kearsipan Digital Berbasis Microsoft Access Pada Bagian Sertifikasi PT Insurin Balikpapan. Jurnal Mahasiswa Kreatif, 1(3). https://doi.org/10.59581/jmk-widyakarya.v1i3.221
Amalia, A. T., & Panduwinata, L. F. (2022). Manajemen Arsip Elektronik (E-Arsip) Berbasis Microsoft Access Terhadap Efektivitas Penemuan Kembali Arsip Pada SMKN 4 Surabaya. Jurnal Pendidikan Administrasi Perkantoran (JPAP), 10(3). https://doi.org/10.26740/jpap.v10n3.p195-210
ANRI. (2021a). Peraturan Arsip Nasional Republik Indonesia Nomor 4 Tahun 2021 tentang Pedoman Penerapan Sistem Informasi Kearsipan Dinamis Terintegrasi. jdih.anri.go.id
ANRI. (2021b). Peraturan Arsip Nasional Republik Indonesia Nomor 6 Tahun 2021 tentang Pengelolaan Arsip Elektronik.
Ayo-Ogunlusi, V. A., & A. Ologbosere, O. (2025). Digital Records on Organizational Performance of Information Managers in Selected Public Tertiary Institutions in Ogun State, Nigeria. International Journal of Advances in Engineering and Management, 7(9). https://doi.org/10.35629/5252-0709203212
Caroline, D. A., Ismanto, B., & Rina, L. (2022). Implementation of digital archives using a dynamic archive information system. Jurnal Kajian Informasi & Perpustakaan, 10(2). https://doi.org/10.24198/jkip.v10i2.33203
Dwiyantoro, D. D., & Sri Junandi, S. J. (2021). Sistem Informasi Manajemen Arsip Dinamis Berbasis Microsoft Access pada Lembaga Pendidikan Dasar di Kota Pekanbaru Tahun 2020. Khazanah: Jurnal Pengembangan Kearsipan, 14(1). https://doi.org/10.22146/khazanah.56664
Lestari, D. D., Ningsih, N. I. R., Sopiah, S., Rahayu, S. D., & Islamy, F. J. (2022). OPTIMALISASI E-ARSIP BERBASIS MICROSOFT ACCESS PADA MASA PANDEMI COVID-19. Jurnal Pendidikan Manajemen Perkantoran, 7(2). https://doi.org/10.17509/jpm.v7i2.47052
Mursyidah, L., Sukmono, R., & Masithah, L. (2024). Transformation of Digital Archives Management: Case Study of Dynamic Archives Information System Implementation at SMA Negeri 2 Sidoarjo. Indonesian Journal of Public Administration Review, 1(4). https://doi.org/10.47134/par.v1i4.3890
Normah, N. (2017). Sistem Informasi Pengelolaan Administrasi Kearsipan Berbasis Teknologi Informasi dan Komunikasi dengan Efiling System. Jurnal Sistem Informasi, 6(1). https://doi.org/10.51998/jsi.v6i1.116
Suryani, Y., & Afifah, A. (2018). ARSIP ELEKTRONIK DALAM MENANGANI PENCATATAN SURAT MASUK DAN SURAT KELUAR DENGAN PROGRAM MICROSOFT ACCESS. JURNAL PENGABDIAN KEPADA MASYARAKAT, 24(1). https://doi.org/10.24114/jpkm.v24i1.9658