Perancangan dan Pembuatan Aplikasi Sistem Kearsipan Elektronik Berbasis Microsoft Access pada Unit Simpan Pinjam Koperasi Warga Polban (KWP) : Pengabdian

Tresna Karomatan; Marwansyah Marwansyah

doi:10.31004/jerkin.v3i4.877

Authors

Tresna Karomatan Politeknik Negeri Bandung
Marwansyah Politeknik Negeri Bandung

DOI:

https://doi.org/10.31004/jerkin.v3i4.877

Keywords:

Electronic Archiving System, Microsoft Access, Digital Transformation, Koperasi Warga Polban

Abstract

This study aimed to develop an electronic archiving system application based on Microsoft Access for the Savings and Loan Unit of Koperasi Warga Polban (KWP), which had previously encountered various challenges in managing manual archives, such as limited storage space, search times reaching 10–15 minutes per document, and risks of document loss or damage. The system was designed using the waterfall method through several stages, starting from needs analysis, system design—covering the creation of use case diagrams to map user interactions, flowcharts to visualize workflows, and entity relationship diagrams (ERD) for database structure. At the implementation stage, key features were developed, including input forms for incoming and outgoing mail, document management for savings and loans, archiving of internal and legal documents, and a search feature that enabled document retrieval in under one minute. The system testing results showed an improvement in work efficiency with a reduction in search time by up to 93%, increased data accuracy through automated validation, and enhanced data security with authentication systems and routine backup mechanisms. Evaluation through comparative tests and interviews with administrative staff regarding high user satisfaction with the ease of the interface, completeness of features, and stability of the system.

References

Afifah, Yoyet, E., & Agustin, N. (2022). Rancangan Sistem Penyimpanan Arsip Surat Puskesmas Dengan Microsoft Access.

Alda, Sari, N., Anggraini, N., Afriani, V., & Zakariah, M. A. (2020). Pengembangan Sistem Keuangan Berbasis Microsoft Access pada Nasabah Koperasi Syariah Di Kolaka. https://id.wikipedia.org/wiki/Microsoft_Access

Amalia, A. T., & Panduwinata, L. F. (2022). Sistem Informasi Manajemen Arsip Elektronik (E-Arsip) Berbasis Microsoft Access Terhadap Efektivitas Penemuan Kembali Arsip Pada SMKN 4 Surabaya. https://journal.unesa.ac.id/index.php/jpap

Aryoko, H. (2022). Tata Kelola Penyimpanan Arsip Di Yayasan Pendidikan Belitung Berehun. 3.

Dwiyantoro, & Junandi, S. (2021). Sistem Informasi Manajemen Arsip Dinamis Berbasis Microsoft Access pada Lembaga Pendidikan Dasar di Kota Pekanbaru Tahun 2020. Jurnal Pengembangan Kearsipan, 14.

Hartini, D., Setiawardani, M., & Sutisna, M. (2022). Development Of Electronic Applications Based On Microsoft Access In Koperasi Inti Bandung. In RMSJ (Vol. 1, Issue 1).

Latuapo, S. J., Fredriksz, G., Wijaya, F., Niaga, A., Politeknik, D., & Ambon, N. (2023). Penataan Arsip Pada Kantor Desa Negeri Larike. Jurnal Administrasi Terapan, 2(2).

Martini, T. (2021). Pengelolaan Arsip Elektronik. Jurnal Komputer Bisnis.

Pratama, R. (2022). Archives are information: definition, principles, and relation. Jurnal Kearsipan, 17(2). https://doi.org/10.46836/jk.v17i2.254

Pricillia, T., & Zulfachmi. (2021). Perbandingan Metode Pengembangan Perangkat Lunak (Waterfall, Prototype, RAD). Jurnal Bangkit Indonesia, X.

Putra, W. I., & Nelisa, M. (2020). Pengelolaan Arsip Elektronik di Unit Kearsipan PT Semen Padang-Wido.

Ramadhan, J. A., Haniva, D. T., & Suharso, A. (2023). Systematic Literature Review Penggunaan Metodologi Pengembangan Sistem Informasi Waterfall, Agile, dan Hybrid. In Journal Information Engineering and Educational Technology (Vol. 07).

Riefnaldi, A. R., Aranta, A., & Muaidi, M. (2021). Pembuatan Sistem Informasi Pengarsipan Surat Pada Kantor Desa Sandik Berbasis Website (a Web-Based Mail Filing Information System at the Sandik Village Office). http://begawe.unram.ac.id/index.php/JBTI/

Sari, R. Yusma., & Zulaikha, S. R. (2020). Pengelolaan Arsip di Dinas Perpustakaan dan Kearsipan Daerah Kabupaten Sambas Provinsi Kalimantan Barat. Jurnal Pustaka Ilmiah, 6.

Simbolon, F. Z., Izhari, F., & Sitorus, Z. (2024). Implementasi Sistem Arsip Elektronik Dalam Meningkatkan Efisiensi Operasional Di Smk Gelora Jaya Nusantara Medan. Jurnal Minfo Polgan, 13(2), 1582–1589. https://doi.org/10.33395/jmp.v13i2.14157

Wibowo, M. H., Ulum, F., Penulis, N., Muhammad, K. :, & Wibowo, H. (2023). Sistem Informasi Koperasi Simpan Pinjam Berbasis Website pada PRIMKOPPABRI Bandar Lampung. 4(1), 22–27. https://doi.org/10.33365/jtsi.v4i1.2434

Yuniasih, & Irawan, B. (2018). Analisis Manajemen Kearsipan di Kantor Kecamatan Jagakarsa Kota Jakarta Selatan. Jurnal Ilmiah Untuk Mewujudkan Masyarakat Madani, 5.

Zainuddin, Z. I., Taryana, A., Nuryanto, Y., & Sandjaya, T. (2023). Penyimpanan Arsip Digital Di Record Center Ibnu Sina Universitas Padjajaran (Vol. 6).