Development of a Microsoft Access-Based Mail Automation System to Improve Student Digital Administration

Atika Salma; Dyah Aulia Rahma; Farida Fatkhur Rohmah; Fitrotul Awaliyah; Hibatullah ‘Aqil Syahrizal; Nina Farliana

doi:10.61987/jemr.v5i4.2545

Authors

Atika Salma Universtas Negeri Semarang
Dyah Aulia Rahma Universitas Negeri Semarang
Farida Fatkhur Rohmah Universitas Negeri Semarang
Fitrotul Awaliyah Universitas Negeri Semarang
Hibatullah ‘Aqil Syahrizal Universitas Negeri Semarang
Nina Farliana Universitas Negeri Semarang

DOI:

https://doi.org/10.61987/jemr.v5i4.2545

Keywords:

Mail Automation, Microsoft Access, Digital Administration, Digital Competence

Abstract

This study aims to develop and evaluate a Microsoft Access-based mail automation system to improve administrative efficiency and students’ digital administration competence. The research employed a Research and Development (R&D) approach adapted from the Borg and Gall model, consisting of needs analysis, product design, expert validation, limited testing, field testing, implementation, and evaluation stages. Data were collected through questionnaires, expert validation sheets, and competency assessments administered before and after system implementation. The results indicated that the developed system was categorized as highly feasible based on expert evaluations in archive management and information technology. Furthermore, students’ digital administration competence increased from a pretest mean score of 3.05 to a posttest mean score of 4.45. Statistical analysis revealed a significant effect of system utilization on competency improvement, with an R² value of 0.512 and p < 0.0001. The system also contributed to reducing administrative errors, accelerating correspondence processes, and improving document organization. These findings imply that mail automation systems can support digital transformation initiatives by strengthening administrative efficiency, technological literacy, and digital competence within student organizations and other educational administrative environments.

References

Abubakar. (2023). Development of an Information System for Student Data Management at Mts.S Krueng Seumideun, Pidie Regency. Journal Dekstop Application (JDA). https://doi.org/10.59431/jda.v2i2.522

Ahmad, I. F., Setiawati, F. A., Prihatin, R. P., & Fitriyah, Q. F. (2024). Technology-Based Learning Effect on the Learning Outcomes of Indonesian Students: A Meta-Analysis. International Journal of Evaluation and Research in Education, 13(2). https://doi.org/10.11591/ijere.v13i2.25383

Asqia, M. (2023). Development of a Web-Based Correspondence Information System to Enhance Administrative Services in Higher Education. The Indonesian Journal of Computer Science, 12(6). https://doi.org/10.33022/ijcs.v12i6.3521

Chugh, R., Turnbull, D., Cowling, M. A., Vanderburg, R., & Vanderburg, M. A. (2023). Implementing Educational Technology in Higher Education Institutions: A Review of Technologies, Stakeholder Perceptions, Frameworks and Metrics. Education and Information Technologies, 28(12), 16403–16429. https://doi.org/10.1007/s10639-023-11846-x

Fatihah, N. R., Natasyah, S., Iswandi, R. N., Zhafira, R. N., & Nasution, D. (2024). Design and Building of Web-Based Letter Archives Management in the Medan Mayor's Office. Journal of Information Technology, Computer Science and Electrical Engineering, 1(1), 61–69.

Febrianto, A. S., & Nurwaqiah, P. (2023). Pemanfaatan Sistem Otomatisasi Kantor dalam Menunjang Efektivitas Kinerja Karyawan pada PT Kereta Api Indonesia Persero. Coopetition: Jurnal Ilmiah Manajemen, 14(2). https://doi.org/10.32670/coopetition.v14i2.3218

Gall, M. D., Borg, W. R., & Gall, J. P. (2007). Educational Research: An Introduction (8th ed.). Pearson.

Habibah, A. N., & Setiawan, H. (2025). Implementasi Manajemen Sistem Informasi Kearsipan Surat Masuk dan Surat Keluar di SMA Bina Muda Cicalengka. Shaut Al-Maktabah: Jurnal Perpustakaan, Arsip dan Dokumentasi. https://doi.org/10.37108/shaut.v17i1.1826

Hakiki, M., Surjono, H. D., Fadli, R., Budiman, R. D. A., Ramadhani, W., Habibie, Z. R., Suhardiman, S., & Hidayah, Y. (2023). Enhancing Practicality of Web-Based Mobile Learning in Operating System Course: A Developmental Study. International Journal of Interactive Mobile Technologies, 17(19). https://doi.org/10.3991/ijim.v17i19.42389

Imaniyati, N., Sobandi, A., & Adman, A. (2025). Optimizing Electronic Archive Management Through Information and Communication Technology for Educational SDGs Advancement. Jurnal Cakrawala Pendidikan, 44(3), 714–729. https://doi.org/10.21831/cp.v44i3.88764

Jannah, K., Wulandari, S. S., & Hariyati, H. (2024). Development of an Electronic Archive System Application (STAR App) as Archival Learning Media at IPIEMS Vocational High School Surabaya City. Electronic Journal of Education, Social Economics and Technology, 5(2), 35–43. https://doi.org/10.33122/ejeset.v5i2.224

Jaya, M. Y. R., Tuala, R. P., Putri, D. C., & Alamsyah, Y. A. (2026). Digital Transformation in School Administration: Enhancing Correspondence and Archival Systems. Journal of Educational Management Research, 5(4), 3836–3848.

Khan, N. A., Rashid, K. A., Siddiqi, A. M. U., Khalid, M. N., Ahmed, M., & Hamdaoui, R. (2025). Development of Intelligent Student Information System. Asian Journal of Basic Science & Research, 7(1), 1–9. https://doi.org/10.38177/AJBSR.2025.7101

Kusnadi, K., Hatta, M., Brotosaputro, G., Amri, A., & Harris, S. (2025). Information Technology and Its Impact on Modern Classroom Dynamics: A Computer Science Perspective. Aptisi Transactions on Technopreneurship, 7(1), 282–293. https://doi.org/10.34306/att.v7i1.523

Labibah, L., Qomaruddin, Q., Ahmad, N. F., & Mahfudloh, R. I. (2025). Digital-Based Management of Incoming and Outgoing Mail Archiving at Educational Institution. Mudir: Jurnal Manajemen Pendidikan, 7(2), 339–343. https://doi.org/10.55352/mudir.v7i2.1735

Laudon, K. C., & Laudon, J. P. (2020). Management Information Systems: Managing the Digital Firm (16th ed.). Pearson.

Lestari, D. D., Ika, N., Ningsih, R., Sopiah, S., & Rahayu, S. D. (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

Liu, C. (2024). Automating Student Assessment Using Digital Data to Improve Education Management Effectiveness in Higher Education Institutions. Education and Information Technologies, 29(2), 1885–1901. https://doi.org/10.1007/s10639-023-11898-z

Liu, T., Luo, Y. T., Pang, P. C.-I., & Kan, H. Y. (2025). Exploring the Impact of Information and Communication Technology on Educational Administration: A Systematic Scoping Review. Education Sciences, 15(9), 1114. https://doi.org/10.3390/educsci15091114

Mahardi, T. A., Kriatiadi, D. D. P., Setiawan, Y. A., & Albar, F. M. (2024). Perancangan Sistem Informasi Surat Menyurat Berbasis Web pada Kampus STMIK Kuwera. Jurnal Sistem Informasi dan Teknologi (Sintek), 4(1), 19–25. https://doi.org/10.56995/sintek.v1i4.65

Mulyo, B. M. (2021). Implementation of Management Information System Website-Based Letter Archives. JEECS (Journal of Electrical Engineering and Computer Sciences), 6(1), 963–968. https://doi.org/10.54732/jeecs.v6i1.184

Nasution, S. D. K., Karnati, N., & Rugaiyah, R. (2025). School Administration Transformation: Improving the Performance of Principals, Administrators, and Science Teachers With a Management Information System (SIMA) Model. Jurnal Ilmiah Ilmu Terapan Universitas Jambi, 9(1), 36–52. https://doi.org/10.22437/jiituj.v9i1.38739

Nugraha, M. F., Sulistiani, Y., & Rahayu, A. (2023). Design and Build of an Information System for Management of Incoming and Outgoing Mail Archives Based on a Website at the Bandung Subdivre Logistics Affairs Agency (BULOG). International Journal of Research in Community Services, 4(4), 153–164. https://doi.org/10.46336/ijrcs.v4i4.510

Pasaribu, A. (2022). Perancangan Sistem Informasi Surat Masuk dan Keluar di Dinas Perumahan dan Kawasan Permukiman Berbasis Web dan Menggunakan PHP dan MySQL [Undergraduate thesis]. Universitas Pembangunan Panca Budi. http://eprints.pancabudi.ac.id/id/eprint/47

Putri, F. N., & Pahlevi, T. (2023). Developing Microsoft Access-Based E-Siska Learning Media for Vocational High School Students. Jurnal Pendidikan Administrasi Perkantoran (JPAP), 11(3), 147–159.

Saputra, D., Silvana, H., & Khoerunnisa, L. (2024). Advantages and Disadvantages of Technological Implementation in Archive Systems. Record and Library Journal, 10(2), 388–412. https://doi.org/10.20473/rlj.V10-I2.2024.388-412

Sari, R. Y., Subandi, A., & Irsyad, I. (2024). Pengaruh Penggunaan Sistem Informasi Manajemen Berbasis Digital terhadap Efisiensi Administrasi Pendidikan. Academy of Social Science and Global Citizenship Journal, 4(1), 21–29. https://doi.org/10.47200/aossagcj.v4i1.2389

Sembiring, E. (2025). Implementation of the Incoming and Outgoing Mail Management Information System Application at STMIK Neumann Indonesia. Jurnal Komputer Teknologi Informasi Sistem Informasi (JUKTISI), 4(2), 751–758. https://doi.org/10.62712/juktisi.v4i2.519

Trina, A. S., Faslah, R., & Adha, M. A. (2025). Electronic Archive Learning Media Based on PHPRAD on Digital Archiving Material. Jurnal Pendidikan Ekonomi, Perkantoran, dan Akuntansi, 6(1), 203–213. https://doi.org/10.21009/jpepa.0601.18

Trirahayu, Y. E., Sumartiningsih, S., & Laksito, W. (2022). Development of Microsoft Access-Based Electronic Records Management Information System (E-Archives) in Postgraduate. Educational Management, 11(2), 307–323.

Wulandari, D. A., Agustina, Y., Nurabadi, A., Andriningrum, H., Putri, A. F., Amelia, T., Harisman, A. S. M., & Zahro, Z. R. (2020). Development of Microsoft Access-Based E-Archive Learning Media Applications on Archival Subjects for 10th Grade Office Administration Students. In Proceedings of the 1st International Conference on Information Technology and Education (ICITE 2020) (pp. 186–191). Atlantis Press. https://doi.org/10.2991/assehr.k.201214.234