【正文】 畢業(yè)設(shè)計（論文） I 倉庫管理 系統(tǒng) 摘 要 隨著科學(xué)技術(shù)的不斷提高，計算機科學(xué)不斷發(fā)展，其強大的功能已經(jīng)被人們深刻認(rèn)識，它已經(jīng)進入了人類社會的各個領(lǐng)域并發(fā)揮著越來越重要的作用。作為計算機應(yīng)用的一部分，使用計算機對產(chǎn)品庫存信息進行管理，是一直必然的趨勢。 本文主要分析了庫存管理系統(tǒng)的一些基本功能和組成情況，重點對數(shù)據(jù)庫報表和幫助系統(tǒng)的制作做了介紹。系統(tǒng)達到了數(shù)據(jù)的一致性和安全性，且應(yīng)用程序功能完備，符合了庫存 管理系統(tǒng) 作為 典型的信息管理系統(tǒng) (MIS)的要求。 用戶可以對倉庫庫存進行更新、刪除和查詢，以及出庫和入庫管理，對出入庫明細 進行查詢，對出庫，入庫，和材料的庫存余額進行報表生成，對使用該系統(tǒng)的用戶進行更新、刪除和查詢，還有操作員管理，權(quán)限設(shè)置，密碼修改，數(shù)據(jù)備份與系統(tǒng)恢復(fù)等其他系統(tǒng)管理功能 。 同時簡單介紹了 Visual Basic 和 Access 數(shù)據(jù)庫管理系統(tǒng)的功能特點，倉庫管理系統(tǒng)是企業(yè)物流管理中不可或缺的一部分。 關(guān)鍵詞 ： 倉庫管理 ； Visual Basic； 數(shù)據(jù)庫設(shè)計 畢業(yè)設(shè)計（論文） II Abstract With the constant improvement of science and technology, puter science develop constantly, already people39。s deep understanding strong function its, it has already entered each field of the human society and played a more and more important role. As a part that the puter employs , use the puter to manage products stock information, manage the inparable advantage artificially . This text has analysed some basic functions of the administrative system of the stock and makes up the situation mainly, Article key to database report form and help system artificial reached the consistency and security of the data, and the application program function is plete, have accorded with the administrative system of the stock as the request for the typical information management system (MIS). The usER can carries on the renewal, the deletion and the inquiry to in the warehouse matERial basic situation, the storehouse and goes into storage to the matERial carries on the management, to leaves goes into storage detailed carries on the inquiry, to leaves the storehouse, goes into storage, carries on the report form production with the matERial stock remaining sum, for uses this system the usER to carry on the renewal, the deletion and the inquiry, carries on the inquiry to the stock quantity, also has the opERator to manage, Jurisdiction establishment, password revision, the data backup and the system restore and so on othER system administration functions. 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 enterprise39。s material flow management. Key word: Storage management 。Visual Basic 。 database design 畢業(yè)設(shè)計（論文） 目 錄 摘 要 ...........................................................................................................................I Abstract ......................................................................................................................... II 第一章 緒論 ........................................................................................................... 1 課題提出的意義 ......................................................................................... 1 管理信息系統(tǒng)的概述 ................................................................................. 2 計算機管理系統(tǒng)發(fā)展的概況 ..................................................................... 3 課題的主要任務(wù) ......................................................................................... 4 第二章 開發(fā)平臺的選擇和用戶界面的設(shè)計 ....................................................... 5 開發(fā)平臺的選擇 ......................................................................................... 5 工作語言（ VB）的選擇 ............................................................... 5 結(jié)構(gòu)化查詢語言 SQL .................................................................... 6 Access2020 簡 介 ............................................................................ 7 用戶界面的設(shè)計 ......................................................................................... 8 第三章 VB 中報表的制作 .................................................................................. 11 Data Report 控件 ....................................................................................... 11 Data Report 控件使用方法 .......................................................... 11 Data Report 控件界面元素 .......................................................... 11 Data Report 控件的打印功能 ...................................................... 12 MS Excel .................................................................................................... 12 Crystal Reporter（水晶報表） ................................................................. 13 Crystal Reports 插件程序的使用 ................................................. 13 Crystal Reports 控件的背景知識 ................................................. 14 Crystal Reports 控件的使用 ......................................................... 14 第四章 軟件的總體設(shè)計 ..................................................................................... 16 系統(tǒng)的總體結(jié)構(gòu) ....................................................................................... 16 系統(tǒng)各模塊功能說明 ............................................................................... 17 系統(tǒng)的物理設(shè)計 ....................................................................................... 17 第五章 程序設(shè)計說明 ......................................................................................... 20 創(chuàng)建系統(tǒng)啟動畫面 ................................................................................... 20 登錄窗體的創(chuàng)建 ....................................................................................... 20 創(chuàng)建系統(tǒng)主菜單 ....................................................................................... 23 工具窗體的制作 ....................................................................................... 25 數(shù)據(jù) 報表的制作 ....................................................................................... 25 創(chuàng)建數(shù)據(jù)環(huán)境 ............................................................................... 25 制作數(shù)據(jù)報表 .............................................