Journal of Applied Science, Technology & Humanities
Vol. 1 No. 1 (2024): January 2024

Use of Databases to Manage Sales Results Data at the KDH Sancang Coffee Shop

Agung Prayudha Hidayat Hidayat (IPB University)
Apristio Faza Ridhar Rahman (IPB University)
Azka Khairani Marisda (IPB University)
Ghailan Arhab (IPB University)
Nayla Cahya Kamila (IPB University)
Rafiq Rizki Prabowo (IPB University)
Sesar Husen Santosa (IPB University)



Article Info

Publish Date
28 Feb 2024

Abstract

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.

Copyrights © 2024






Journal Info

Abbrev

batrisya

Publisher

Subject

Humanities Computer Science & IT Control & Systems Engineering Economics, Econometrics & Finance Social Sciences

Description

Journal of Applied Science, Technology & Humanities is published by Batrisya Education. Published five times a year, in January, March, June, September, November and already have a registration number ISSN 3032-5765, DOI: https://doi.org/10.62535/jasth. Journal of Applied Science, Technology & ...