The Designing and Operation of Database with Microsoft Access. Case study : community shop Ban Non Sa-at, Thai Charoen Subdistrict, Nong Bun Mak District, Nakhonratchasima Province

Abstract

This paper presents a guideline for preparing a paper to submit to the Objectives: To analyze and design the community store product sales system for maximum benefit to the business. Study to develop the community store product sales system. sample group Ban Non Sa-at Community Shop, Thai Charoen Subdistrict, Nong Bun Mak District Nakhon Ratchasima Province, 7 locations by choosing a specific method The research tools used were questionnaires. and the developed work system efficiency evaluation form Statistics using percentages and standard deviations The results of the research found that the efficiency of using the system System users have evaluated the system's performance.  In terms of basic information management, it was at a moderate level. In terms of product entry, it was at a moderate level. In terms of sales management, it was at a moderate level.  in terms of issuing reports is at a high level. The system works easily. It is faster. Reduce complicated work Reduce errors in product pricing This allows users to work more efficiently. and from evaluating the performance of the sales system Have opinions on basic data management systems. There is an inventory management system. This can solve the original problem of stores storing data by writing down notes on paper. No data is stored on the computer. Using the system designed and developed helps reduce errors in checking stock. Check sales and make selling products more quickly As a result, work is easier and more efficient.