Jurnal Pengabdian Kepada Masyarakat (J-ABDIMAS)
Vol 9 No 2 (2022): JURNAL PENGABDIAN KEPADA MASYARAKAT 2022

LITERASI FITUR DATA-FORM MS. EXCEL UNTUK MENGELOLA DATABASE ANGGOTA PERKUMPULAN KEMATIAN “LAZARUS” MALANG

Tri Istining Wardani (Politeknik Negeri Malang)
Asminah Rachmi (Politeknik Negeri Malang)
Dwi Sudjanarti (Politeknik Negeri Malang)
Umi Khabibah (Politeknik Negeri Malang)
Achmad Zaini (Politeknik Negeri Malang)



Article Info

Publish Date
30 Dec 2022

Abstract

This community service aims to develop technical skills in managing databases. So far, the “Lazarus" commission processed all regular membership fees manually. The repetitive work and recording errors happened along the way. With a total of 428 family members out of 993, the above data processing was inefficient and ineffective. Ms. Excel, especially the Data-Form feature will make database management easier for someone to process data entry, edit, search, and delete in a database table. When a database has been formed, the preparation of the annual report will also be able to be compiled efficiently & effectively, because the database is already stored in a soft file. Community service is carried out through training assistance. The activity begins with preparing teaching modules, followed by assisting to create a table model database in Ms. Excel. Subsequently, design a Data (Entry) Form model for recapitulation. The competencies have been achieved because in the end the database management has been simulated very well using real data & problems. Therefore, the final evaluation results declared that the database management model uses the Data Form successfully to help the "Lazarus" commission maximize its service.

Copyrights © 2022






Journal Info

Abbrev

abdimas

Publisher

Subject

Economics, Econometrics & Finance Education Languange, Linguistic, Communication & Media

Description

J-ABDIMAS - Jurnal Pengabdian Kepada Masyarakat terbit pertama kali bulan Desember 2014, dan diterbitkan dua kali dalam setahun yaitu pada bulan Juni dan DesemberRedaktur mengundang para penulis untuk menyumbangkan artikel hasil Pengabdian Kepada Masyarakat  dalam bidang IpTek, Bisnis maupun ...