Desain Aplikasi Database Sistem Informasi Akuntansi Sekolah pada Yayasan Ainur Rahmah

Firman Surya; Elfitri Santi; Fera Sriyunianti; Randy Heriyanto

doi:10.30630/jam.v18i1.215

Firman Surya Jurusan Akuntansi Politeknik Negeri Padang
Elfitri Santi Jurusan Akuntansi Politeknik Negeri Padang
Fera Sriyunianti Jurusan Akuntansi Politeknik Negeri Padang
Randy Heriyanto Jurusan Akuntansi Politeknik Negeri Padang

DOI: https://doi.org/10.30630/jam.v18i1.215

Keywords: AIS, Application, Database, Microsoft Access, VBA

Abstract

This study aims to develop an accounting information system database application for Ainur Rahmah Foundation school in West Pasaman, West Sumatra Province. The problem faced by the Ainur Rahmah Foundation is the absent of an information system to manage student data, tuition fees, admission of new students, receipt and disbursement of cash, purchase and use of consumables, acquisition and depreciation of fixed assets. The developed accounting information system database application consists of two main subsystems, namely the back-end and front-end. The back-end system uses DBMS MySQL Server 8.0 while the front-end system is developed using Microsoft Access 2010. Application modules and reports are developed on the front-end using the Visual Basic for Application programming language which is available in Microsoft Access database tools. Applications that have been developed are then tested for use by users to find out if there are errors and adjustments that must be made. After making adjustments based on the user trial stage, the application can be accepted by users and can be operated according to needs.

References

Eliyanora, Surya, F., & Ihsan, H. (2016). Penyajian Laporan Keuangan Sekolah Berbasis Database pada Sekolah Dhuafa. Akuntansi Dan Manajemen, 11(1), 18-24. https://doi.org/10.30630/jam.v11i1.96

Irda Rosita, Eliyanora, & Diyah Hastiyahsari. (1). Merancang Aplikasi Database Keuangan untuk Pengelolaan Keuangan Pembangkit Listrik Tenaga Mikrohidro (PLTMh). Akuntansi Dan Manajemen, 13(1), 112-118. https://doi.org/10.30630/jam.v13i1.34

Martin, J. (1991). Rapid Application Development. MacMillan Publishing Company.

Romney, M. B., & Steinbart, P. J. (2017). Accounting Information Systems.

Rosalina, E., Andriani, W., Wirahadi, A., Sriyuniati, F., & Handayani, D. (2020). Excel For Accounting Untuk Penyusunan Laporan Keuangan Pada Yayasan Panti Asuhan. Akuntansi Dan Manajemen, 15(1), 102-107. https://doi.org/10.30630/jam.v15i1.61

Rosita, I., Surya, F., & Eliyanora. (2015). Administrasi Keuangan untuk Baitul Mal wat Tamwil (BMT). Akuntansi Dan Manajemen, 10(1), 1-12. https://doi.org/10.30630/jam.v10i1.107

Sukartini, Surya, F., Haslina, W., Yusnani, & Maryati, U. (2020). Aplikasi Pelaporan Kelebihan Jam Mengajar Jurusan Akuntansi PNP. Akuntansi Dan Manajemen, 15(2), 43-49. https://doi.org/10.30630/jam.v15i2.18