Jejak digital: Jurnal Ilmiah Multidisiplin
Vol. 2 No. 4 (2026): JUNI-JULI

Perancangan Sistem Informasi Akuntansi Persediaan Berbasis Microsoft Access pada Apotek Mizan Palembang

Farah Salsabila (Politeknik Negeri Sriwijaya)
Sukmini Hartati (Politeknik Negeri Sriwijaya)
Eka Jumarni Fithri (Politeknik Negeri Sriwijaya)



Article Info

Publish Date
23 Jun 2026

Abstract

Inventory management at Apotek Mizan Palembang is currently conducted manually using stock books and administrative documents, resulting in high recording error risks, delayed stock information, difficulties in controlling minimum stock levels, and time-consuming report preparation prone to errors. This study aims to design an inventory accounting information system based on Microsoft Access to address these problems. Data collection methods include interviews, observations, and questionnaires with the owner/apothecary and internal pharmacy documents. The designed system comprises tables (product, purchase/sales transaction, detail), queries (Detail, Product, Purchase/Sales Transaction), forms (Login, Main Menu, Product, Purchase/Sales Transaction), and stock card reports. Testing shows the system can automate transaction recording, update stock in real-time, and generate reports quickly and accurately. This system improves operational efficiency, strengthens inventory control, and provides more reliable information for decision-making.

Copyrights © 2026






Journal Info

Abbrev

jejakdigital

Publisher

Subject

Economics, Econometrics & Finance Education Languange, Linguistic, Communication & Media Social Sciences Other

Description

Jurnal Ilmiah Multidisiplin adalah jurnal elektronik dan cetak Open Access Journal yang diterbitkan oleh Indo Publishing setiap 6 kali dalam setahun menyediakan forum untuk mempublikasikan artikel penelitian asli, artikel review dari kontributor, dan berita teknologi baru mencangkup multidisiplin ...