Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Journal of Applied Science, Technology & Humanities
Nayla Cahya Kamila
IPB University
Humanities Computer Science & IT Control & Systems Engineering Economics, Econometrics & Finance Social Sciences

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Use of Databases to Manage Sales Results Data at the KDH Sancang Coffee Shop Agung Prayudha Hidayat Hidayat; Apristio Faza Ridhar Rahman; Azka Khairani Marisda; Ghailan Arhab; Nayla Cahya Kamila; Rafiq Rizki Prabowo; Sesar Husen Santosa
Journal of Applied Science, Technology & Humanities | JASTH Vol. 1 No. 1 (2024): January 2024
Publisher : Batrisya Education

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.62535/hx4h5d16

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.
Co-Authors Agung Prayudha Hidayat Apristio Faza Ridhar Rahman Azka Khairani Marisda Ghailan Arhab Rafiq Rizki Prabowo Sesar Husen Santosa