Perancangan Database Akuntansi Menggunakan Microsoft Access pada Usaha Konveksi Taylor Abadi


  • Wiwik Andriani Politeknik Negeri Padang
  • Eka Rosalina Politeknik Negeri Padang
  • Fera Sriyunianti Politeknik Negeri Padang
  • Ferdi Afrizon Politeknik Negeri Padang
  • Dandi Aprila Politeknik Negeri Padang



Accounting, Microsoft Access, Financial Report


This service aims to help design accounting applications at the Konveksi Taylor Abadi Convection Business using Microsoft Access. The application is designed according to the needs of the store, where this application has a form that is equipped with Visual Basic for Application (VBA) and other facilities such as an account list form, inventory list, fixed asset list, transaction recording consisting of sales, purchases, raw material usage, allocation forms. factory overhead costs, direct labor costs, finished production or finished products. This application provides financial reports ranging from reports on the cost of production, profit and loss reports, reports on changes in capital, balance reports and cash flow reports as well as other data needed by the company. From the results of this service, it was found that there were deficiencies in the recording and financial reports at Taylor Abadi Convection. Therefore, the author provides a solution for Konveksi Taylor Abadi Convection to use Microsoft Access computer applications in recording transactions and preparing financial reports in accordance with Financial Accounting Standards (SAK) quickly and automatically.


Anggraeni, D., Aswati, S., Maulina Azmi, S. R., Akmal, A., Dewi, M., & Anwar, K. (2018). Membangun Database Menggunakan Microsoft Access 2007. Jurdimas (Jurnal Pengabdian Kepada Masyarakat) Royal, 1(1), 7–14.

Hayat, Farihah, Z., & Sulistiyo. (2019). Perhitungan Harga Pokok Produksi Dengan Metode Harga Pokok Pesanan Pada CV Mitra Bisnis Anda. Jurnal Aktual Akuntansi Keuangan Bisnis Terapan, 2(1), 1–6.

Kasmir. (2008). Analisis Laporan Keuangan. In Analisis Laporan Keuangan (11th ed., pp. 21–27). Rajawali Pers.

Kumar Dora, S., & Dubey, P. (2013). Software Development Life Cycle (Sdlc) Analytical Comparison and Survey on Traditional and Agile Methodology. National Monthly Refereed Journal of Research in Science & Technology, 2(8), 22–30.

Mulyadi. (2011). Sistem Perencanaan dan Pengendalian Manajemen. Salemba Empat.

Sastroatmodjo, S., & Purnairwan, E. (2021). PENGANTAR AKUNTANSI. Media Sains Indonesia.




How to Cite

Andriani, W., Rosalina, E., Sriyunianti, F., Afrizon, F., & Aprila, D. (2023). Perancangan Database Akuntansi Menggunakan Microsoft Access pada Usaha Konveksi Taylor Abadi. SAINS DAN INFORMATIKA : RESEARCH OF SCIENCE AND INFORMATIC, 9(1), 30–36.