[仓库管理系统的设计与实现].docVIP

PAGE I [仓库管理系统的设计与实现] 袁昌华 摘 要 随着现代工业的发展，计算机信息管理系统越来越受到企业重视。本文主要分析了库存管理系统的一些基本功能和组成情况，包括系统的需求分析、系统结构，功能模块划分以及数据库模式分析等，重点对应用程序的实际开发实现作了介绍。达到了数据的一致性和安全性，且应用程序功能完备，符合了库存管理系统作为典型的信息管理系统(MIS)的要求。同时简单介绍了Visual Basic编程环境和Access数据库管理系统的功能特点，库存管理系统是企业物流管理中不可或缺的一部分。 针对目前我国仓库管理的现状, 介绍了在CIMS环境下利用Visual Basic对旧式仓库管理进行改造的方法, 重点是对出入库管理的改进。充分利用现有仓库设施实现系统化、规范化和自动化, 优化了企业资源, 提高了生产效益。 该文根据现代物流管理模式并利用计算机技术开发了仓库管理系统并利用该套系统对仓库进行全自动精细化管理,促进了生产管理的规范化和有效提高工作效率。 关键词 库存管理，数据库，信息管理，VB,Access PAGE II ABSTRACT With the development of modern industry, the information management system of the computer is being paid attention to by enterprises. This text has analyzed some basic functions of the administrative system of the stock and makes up the situation mainly, including the systematic demand is analyzed, systematic structure, the function module divides and the data base mode is analyzed etc., have realized doing the introduction to the actual development of the application program especially. Having reached the consistency and security of the data, and the application program function is complete, have accorded with the administrative system of the stock as the request for the typical information management system (MIS). Introduced the function characteristics of Visual Basic programming environment and Access data base management system briefly at the same time, the administrative system of the stock is an indispensable part in enterprises material flow management. According to the current status of warehouse management in China, an old type warehouse was improved by using Visual Basic based on computer integrated manufacturing system (CIMS), especially storage and retrieval management. It makes full use of the available equipments to realize systematize, standardization and autoimmunization, so that the resources of the enterprise are optimized and the profit of the production is increased. This paper is intended to introduce how to design the storage management system with computer techno