隨著現(xiàn)代工業(yè)的發(fā)展，計(jì)算機(jī)信息管理系統(tǒng)越來越受到企業(yè)重視。本文主要分析了庫存管理系統(tǒng)的一些基本功能和組成情況，包括系統(tǒng)的需求分析、系統(tǒng)結(jié)構(gòu)，功能模塊劃分以及數(shù)據(jù)庫模式分析等，重點(diǎn)對應(yīng)用程序的實(shí)際開發(fā)實(shí)現(xiàn)作了介紹。達(dá)到了數(shù)據(jù)的一致性和安全性，且應(yīng)用程序功能完備，符合了庫存管理系統(tǒng)作為典型的信息管理系統(tǒng)(MIS)的要求。同時(shí)簡單介紹了Visual Basic編程環(huán)境和Access數(shù)據(jù)庫管理系統(tǒng)的功能特點(diǎn)，庫存管理系統(tǒng)是企業(yè)物流管理中不可或缺的一部分。
本文針對企業(yè)的實(shí)際需要，分析了企業(yè)倉庫管理系統(tǒng)的功能，它主要采用VB可視化的編程語言來開發(fā)。它包括單據(jù)管理，統(tǒng)計(jì)查詢，輔助項(xiàng)目管理，報(bào)表管理，系統(tǒng)維護(hù)等功能。
ABSTRACT
With the development of modern industry, the information management system of the computer is being paid attention to by enterprises. This text has analysed some basic functions of the administrative system of the stock and makes up the situation mainly, including the systematic demand is analysed, systematic structure, the function module divides and the data base mode is analysed 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 enterprise's material flow management.
This article in view of enterprise's actual need, has analyzed the enterprise storage management system function, it mainly uses the VB visible programming language to develop. It including documentary evidence management, statistical inquiry, auxiliary project management, report form management, function and so on system maintenance. carry on the renewal, the deletion and the inquiry, but also has the operator to manage, jurisdictionestablishment, password revision and so on other management functions.
關(guān)鍵詞：庫存管理，數(shù)據(jù)庫，信息管理，VB
Keywords: stock management, database, information management, VB
目錄
1 緒論 1
1.1庫存管理系統(tǒng)研究背景與意義 1
1.2庫存管理系統(tǒng)的研究現(xiàn)狀 1
1.3本文的組織結(jié)構(gòu) 2
2 技術(shù)簡介和數(shù)據(jù)庫理論基礎(chǔ) 3
2.1開發(fā)工具及關(guān)鍵技術(shù)簡介 3
2.2 Visual Basic簡介及實(shí)現(xiàn)原理 3
2.3 數(shù)據(jù)庫組件介紹 4
2.4 SQL語言在VB中的應(yīng)用 5
2.5 Access 2000簡述 6
2.7 SQL語言介紹 7
3 系統(tǒng)需求分析和總體設(shè)計(jì) 9
3.1需求分析 9
3.2可行性分析 9
3.3系統(tǒng)分析 9
3.4模塊劃分 11
4 庫存管理系統(tǒng)設(shè)計(jì)分析 13
4.1 系統(tǒng)目標(biāo)設(shè)計(jì) 13
4.2系統(tǒng)設(shè)計(jì)思想 13
4.3系統(tǒng)架構(gòu)選擇 13
4.4系統(tǒng)結(jié)構(gòu)設(shè)計(jì) 14
4.5數(shù)據(jù)庫設(shè)計(jì) 15
5 系統(tǒng)詳細(xì)設(shè)計(jì)與實(shí)現(xiàn) 19
5.1系統(tǒng)登入模塊設(shè)計(jì) 19
5.2 系統(tǒng)主窗體模塊設(shè)計(jì) 20
5.3貨品入庫登記模塊的實(shí)現(xiàn) 23
5.4出入庫查詢窗體模塊的設(shè)計(jì) 24
5.5出入庫數(shù)據(jù)整理窗體模塊 25
6 總結(jié)與展望 27
參考文獻(xiàn) 28
作品（軟件）使用說明書 29