Claim Missing Document
Check
Articles

Found 5 Documents
Search

Sistem Informasi Administrasi Dan Reservasi Ada Guest House Berbasis Microsoft Access Imelda Ayu Rahmadani; Nur Shela; Dinda Zasyifa; Muhammad Ilham Fathoni; Angga Kusumah
Jurnal Ilmiah Sistem Informasi Akuntansi Vol. 5 No. 1 (2025): Volume 5, Nomor 1, June 2025
Publisher : Universitas Teknokrat Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33365/jimasia.v5i1.278

Abstract

Pengelolaan administrasi dan reservasi guest house secara manual kerap menimbulkan berbagai kendala, seperti keterlambatan layanan, ketidakakuratan pencatatan data, serta rendahnya efisiensi operasional. Untuk mengatasi permasalahan tersebut, penelitian ini bertujuan merancang dan membangun sistem informasi administrasi dan reservasi berbasis Microsoft Access yang lebih terstruktur, efektif, dan efisien. Metode yang digunakan adalah rekayasa perangkat lunak dengan pendekatan terstruktur, dimulai dari analisis kebutuhan sistem, perancangan menggunakan Data Flow Diagram (DFD) dan Entity Relationship Diagram (ERD), hingga implementasi dalam bentuk tabel, form, query, serta laporan otomatis. Proses pengujian dilakukan secara iteratif bersama pengguna untuk memastikan sistem bekerja sesuai kebutuhan. Hasil penelitian menunjukkan bahwa sistem mampu mengelola data tamu, kamar, reservasi, dan pembayaran secara terpadu, dengan dukungan fitur form input yang ramah pengguna, query otomatis, serta laporan administrasi seperti kwitansi dan laporan bulanan yang meningkatkan akurasi dan efisiensi kerja. Sistem ini juga membantu proses monitoring dan pengambilan keputusan manajerial. Meskipun demikian, sistem berbasis desktop memiliki keterbatasan dalam akses jarak jauh dan keamanan data. Oleh karena itu, pengembangan ke arah sistem online dan penambahan fitur keamanan menjadi rekomendasi lanjutan.
Peningkatan Pemahaman Tentang Perilaku Konsumen Pada UMKM Buket Bunga Betterstore Samarinda Auliya Syafira; Meilynda Satriani; Aura Nuzulul Rahmah; Muhammad Suyudi; Angga Kusumah
Paramacitra Jurnal Pengabdian Masyarakat Vol. 3 No. 02 (2026): Volume 03 Nomor 02 (Mei 2026)
Publisher : PT Ininnawa Paramacitra Edu

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.62330/pjpm.v3i02.700

Abstract

Micro, Small, and Medium Enterprises (MSMEs) play an important role in the local economy, yet many business owners still find it difficult to understand their consumers' behavior. This community service activity was carried out at Betterstore, an artificial flower bouquet business in Samarinda, with the goal of helping the owner and staff better understand consumer behavior, including purchasing habits, customer preferences, and the concept of consumer satisfaction. The activity was conducted through direct interviews and face -to-face educational sessions with Betterstore's owner and staff. As a result, the business owner gained a cl earer understanding of customer purchasing patterns, the importance of identifying the right target market, and the need to keep up with product trends on social media. Throughout the activity, Betterstore's team was enthusiastic and open, and expressed their commitment to applying these insights in their marketing and product development going forward. This activity is hoped to support Betterstore's growth and competitiveness within Samarinda's growing creative industry.
COACHING CLINIC: METODOLOGI DAN KONSTRUKSI TEORI ILMU MANAJEMEN DI STIMI SAMARINDA Angga Kusumah; Muhammad Suyudi; Aris Tri Cahyono; Fatahul Rahman; Bejo Santoso; Yurdi Maulidani; Putri Nurhaliza
JUAN: Jurnal Pengabdian Nusantara Vol. 2 No. 4 (2025): Oktober 2025
Publisher : CV Sentra Nusa Connection

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.63545/juan.v2.i4.180

Abstract

Kegiatan pengabdian kepada masyarakat ini bertujuan untuk memperkuat kemampuan peserta dalam metodologi dan proses konstruksi teori melalui pengembangan atau mengadaptasi teori yang telah ada agar relevan dengan konteks manajerial kontemporer. Selain itu, kegiatan ini menekankan pentingnya pemilihan metode penelitian yang tepat agar hasil penelitian memiliki validitas dan reliabilitas yang tinggi yang sesuai dengan etika akademik dan standar keilmuan manajemen. Coaching Clinic ini diharapkan menjadi sarana pembentukan paradigma ilmiah yang mendukung pengembangan ilmu manajemen berbasis riset. Metode pelaksanaan dengan pendekatan partisipatif, interaktif dan berbasis praktik ilmiah. Sebanyak 87 peserta yang mengikuti kegiatan ini. Hasil kegiatan dibuktikan dengan tersusunnya framework penelitian yang lebih sistematis dan berbasis teori manajemen yang relevan. Kegiatan ini diharapkan menjadi langkah awal pembentukan budaya riset di kalangan Mahasiswa STIMI Samarinda.
Implementasi Microsoft Acces Dalam Sistem Informasi Manajemen Usaha Wadah Laundry Nayla Putri Syadiva; Mutia Salsabila; Wulan Juani Salsa Billa; Nur Asy Syifa'; Angga Kusumah
Jurnal Sistem Informasi Akuntansi Vol 6 No 2 (2025): Periode September 2025
Publisher : LPPM Universitas Bina Sarana Informatika

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31294/ckm3jh98

Abstract

Wadah Laundry is a business that records transactions manually without a structured bookkeeping system. This leads to difficulties in monitoring operational income and expenses, making it unclear whether the business is generating profit or loss. Therefore, this study aims to develop an information system based on Microsoft Access to facilitate transaction recording, monitor financial flows, and calculate profit or loss more accurately. This research employs a field study method by collecting data directly through observations and interviews related to the business’s operational processes. The developed system includes key features such as customer transaction recording, customer data management, data storage, editing, deletion, and report generation as needed. The implementation results show that this system can help process data more effectively, making transaction recording more organized and accurate. Thus, the developed application is expected to support Wadah Laundry’s operations by improving business management efficiency.
ENHANCING SERVICE EFFICIENCY THROUGH AN EXCEL MACRO- BASED INFORMATION SYSTEM: EVIDENCE FROM SANKEN SAMARINDA SERVICE CENTER Tandi Kadang; Tiara; Andi Nurhasanah; Angga Kusumah; Feti Fahmimroah
International Journal of Social Science, Educational, Economics, Agriculture Research and Technology (IJSET) Vol. 4 No. 11 (2025): OCTOBER
Publisher : RADJA PUBLIKA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.54443/ijset.v4i12.1527

Abstract

This study aims to develop an information system using Microsoft Excel Macros to improve service efficiency at the Sanken Samarinda Service Center. The background of this research lies in the operational condition that still relies heavily on manual record-keeping, resulting in data entry delays, calculation errors, and slow report generation. The development of this information system is expected to accelerate the administrative processes of sales and services while increasing data accuracy. The research applied a mixed-methods approach, employing observation, interviews, documentation, and literature review for data collection. The incremental model was used for system development, allowing design and testing to be carried out progressively. The findings indicate that implementing a Macro Excel-based system reduces data entry time by up to 50%, improves operational efficiency, and enables automatic and accurate report generation. In terms of effectiveness, the system successfully optimizes resource utilization and minimizes human error. These findings reinforce the theory of information technology efficiency, showing that simple software tools like Microsoft Excel can serve as economical and effective alternatives to support business process digitalization.