RESEARCH MS ACCESS SOFTWARE FOR APPLICATION IN SMART GARMENT FACTORY MACHINE MANAGEMENT

Abstract

This study was conducted to support the process of Vietnamese garment companies in building smart factories with production activities that can be controlled automatically. It is a model for managing the system of machines in the factory using MS Access, which allows for updating machines information, searching for machines, reporting, and statistics. It allows for managing the information changes in the system, including machine information, warranty time, maintenance schedule, repair history, disposed of machines, and purchasing new machines. The system replaced a batch of manual operations and paperwork procedures with queries, macros, and reports. The results are labor cost savings, reduced costs, and increased machine utilization efficiency.