SISTEM INFORMASI PADA APOTEK SARAYA FARMA BERBASIS MACRO MICROSOFT EXCEL

Abstract

The primary objective of this study was to develop a Microsoft Excel macro-based information system for Saraya Farma Pharmacy, which previously depended on manual transaction recording. Manual recording of data presented a potential for errors and inefficiencies in data management. The objective of this study was to develop and execute an information system that could enhance the efficacy and productivity of pharmacy operations. The research methodology employed was a synthesis of qualitative and quantitative approaches. Data were gathered through observation, interviews, and literature reviews. Data Flow Diagrams (DFD), Entity Relationship Diagrams (ERD), and Microsoft Excel with macros were among the analysis tools employed. The study findings demonstrated that the implemented information system successfully enhanced the operational effectiveness and efficiency of Saraya Farma Pharmacy. The automation of recording, computing transactions, and generating reporting enhanced efficiency, speed, and precision. Furthermore, this method also contributed