Use of Databases to Manage Sales Results Data at the KDH Sancang Coffee Shop
DOI:
https://doi.org/10.62535/hx4h5d16Keywords:
database, Microsoft Access, relationship, query, sellingAbstract
Technological advances allow entrepreneurs to manage sales data efficiently. Governance management in micro, small and medium enterprises is often an obstacle to the continuity and development of the business. Based on interviews conducted, at KDH Sancang Coffee Shop, data management still uses Microsoft Excel, which sometimes makes it difficult for users to access the desired data. This research recommends using Microsoft Access to create a secure and organized sales database. This solution helps overcome data duplication problems and improve data accessibility and security. Based on the research results, the process of creating a database for sales results includes the creation of item and sales data tables, one to one relationship, Query total sales results, and Form Design for easy data access. This research activity aims to enable micro, small, and medium-sized enterprises to effectively organize their financial records, including providing owners with the necessary tools to manage their business finances more efficiently. The results showed that the use of Microsoft Access increased the efficiency of managing monthly sales data at KDH Sancang Coffee Shop which is expected to facilitate monthly sales evaluation activities at the coffee shop.
References
Aziz, A. (2012). Pemanfaatan Teknologi Informasi dalam Pengembangan Bisnis Pos information technology utilization in business post. Puslitbang Sumber Daya Dan Perangkat Pos Dan Informatika, 10(1), 35–50.
Charzon. (2018). Pengertian Dan Fungsi Database Untuk Program Delphi. Fakultas Komputer Section Class Content, 1–22.
Duggan, M., Roderick, D. R., & Sieburg, J. (1970). Data bases. Proceedings of the 1970 25th Annual Conference on Computers and Crisis: How Computers Are Shaping Our Future, ACM 1970, 1–7. https://doi.org/10.1145/1147282.1147284
Hidayat, A. P., Santosa, S. H., & Siskandar, R. (2022). Penentuan Jumlah Kebutuhan Bahan Baku Berdasarkan Distribusi Barang Ideal di IKM Tepung Tapioka Kabupaten Bogor. Jurnal INTECH Teknik Industri Universitas Serang Raya, 8(1), 23–28. https://doi.org/10.30656/intech.v8i1.4400
Hikam, H. M., & Pradana, B. I. (2019). Implementasi Strategi Inovasi Amstirdam Coffee Shop Untuk Menghadapi Persaingan. 1–14.
Maellah, M. (2018). Peran LPTK Dalam Pengembangan Pendidikan Vokasi di Indonesia Peran LPTK Dalam Pengembangan Pendidikan Vokasi di Indonesia. Seminar Internasional, ISSN, 1907–2066, 231–238. http://scholar.google.co.id/scholar_url?url=https%3A%2F%2Fejournal.undiksha.ac.id%2Findex.php%2FAPTEKINDO%2Farticle%2Fdownload%2F67%2F61&hl=id&sa=T&oi=ggp&ct=res&cd=0&d=14192830186105454022&ei=SeJlXq3xEYaE6rQP6fW_6AY&scisig=AAGBfm1hUUZS4keDxCiUc3DRNw6YBHm
Nur, H. (2019). Penggunaan Metode Waterfall Dalam Rancang Bangun Sistem Informasi Penjualan. Generation Journal, 3(1), 1. https://doi.org/10.29407/gj.v3i1.12642
Purwanto, E., Utomo, B. P. C., & Permatasari, H.-. (2021). Sistem Informasi Evaluasi Penjualan (Studi Kasus : Toko XYZ). Bianglala Informatika, 9(1), 1–5. https://doi.org/10.31294/bi.v9i1.9525
Universitas Negeri Yogyakarta. (2015). Materi Microsoft Access 2010. 12–15.
Anggraeni, D., Aswati, S., Maulina Azmi, S. R., Akmal, A., Dewi, M., & Anwar, K. (2018). Membangun Database Menggunakan Microsoft Access 2007. Jurdimas (Jurnal Pengabdian Kepada Masyarakat) Royal, 1(1), 7–14. https://doi.org/10.33330/jurdimas.v1i1.381
Anto, A. W., Noerman Syah, A. L., Priatna Sari, Y., & Zul Fauzi, A. (2020). Desain Database Menggunakan Microsoft Access Pada Siswa-Siswi SMK PGRI Kabupaten Brebes. ABDIMAS: Jurnal Pengabdian Masyarakat, 3(2), 367–371. https://doi.org/10.35568/abdimas.v3i2.643
Meiliza, A., Priatna, P., Calulla Nur, A., Rizal, A. A., Irmaniansyah, D., Pramudito, T., & Hariyadi, G. (2023). Pengembangan Aplikasi Database Analisa Penjualan pada Perusahaan Maju Makmur Development of Sales Analysis Database Application at Maju Makmur Company. Indonesian Journal of Science, 4(1), 19–26. http://journal.pusatsains.com/index.php/jsi
Oktarina, N. dan A. K. (2011). Pembelajaran Berbasis It Aplikasi Program. Jurnal Penelitian Pendidikan, 29(2), 158–168.
Rizaldi, R., Anggraeni, D., & Zikra Syah, A. (2018). Tips Dan Trik Membangun Relationship Dan Query Dalam Database. Jurdimas (Jurnal Pengabdian Kepada Masyarakat) Royal, 1(2), 45–50. https://doi.org/10.33330/jurdimas.v1i2.110
Wibagso, S. S., & Lia, E. (2020). Desain Model Database Layanan Panti Werdha dengan Menerapkan Metode Database Life Cycle. Jurnal Teknik Informatika Dan Sistem Informasi, 6(3), 573–588. https://doi.org/10.28932/jutisi.v6i3.3047
Zerlinda, F. M., Zulfa Zaidan, M., Fisrawati, Hadias Safitri, N., & Fathan Nabil Al-Badi, M. (2023). Aplikasi Database Untuk Mengelola Persediaan Barang di Toko Baju D’Clothing Menggunakan Pendekatan Entity Relationship Chart. Jurnal Sains Indonesia, 4(1), 68–75. https://doi.org/10.59897/jsi.v4i1.124
