Ensiklopedia of Journal
Vol 6, No 4 (2024): Vol. 6 No. 4 Edisi 1 Juli 2024

PERANCANGAN PELAPORAN PASIEN RAWAT JALAN MENGUNAKAN APLIKASI DATABASE BERBASIS VISUAL BASIC FOR APPLICATION (VBA) MICROSOFT EXCEL DI RUMAH SAKIT

Mardiawati, Dewi (Unknown)
Dewi, Siti Handam (Unknown)
Zailinda, Meuthia Arini (Unknown)



Article Info

Publish Date
26 Jul 2024

Abstract

Internal reports are reports that are used and utilized by the hospital. Based on the initial survey that the researchers conducted, it was found that there were delays in collecting outpatient internal reports and processing was still done manually. The purpose of this study was to determine the design of an outpatient patient reporting database application based on Microsoft Excel's Visual Basic For Application (VBA) in Mental Hospitals Prof Hb Saanin Padang. The method used is Research and Development. The results of the study found that the flow was in accordance with the flow of medical record documents. The basic patient data components used are 20 basic patient data components and 7 outpatient internal report components. The person in charge of recording and reporting outpatient care is 1 officer. The database application design uses UML visual modeling with the types of use case diagrams, class diagrams, and activity diagrams and the programming language is VBA Excel. The use of database applications has been effective and speeds up report processing with usage results of 03.60 minutes. So it can be concluded that the database application design has been effective and in accordance with the needs of the hospital.

Copyrights © 2024






Journal Info

Abbrev

ensiklopedia

Publisher

Subject

Arts Humanities Computer Science & IT Law, Crime, Criminology & Criminal Justice Social Sciences

Description

Ensiklopeda of Journal mendorong seluruh ahli hukum, sosial, politik, bahasa, dan ilmu pendidikan untuk turut berkontribusi melalui artikel dan/atau book review. Ensiklopeda of Journal terbit tiap 1 Kali per 3 bulan, dalam satu volume, yakni di bulan Januari, April, Juli, dan Oktober. Ensiklopeda of ...