【正文】 （論文） I 財(cái)務(wù)管理系統(tǒng) 摘 要 利用 VisualBasic 的數(shù)據(jù)控件和數(shù)據(jù)綁定控件可以快速地開發(fā)出數(shù)據(jù)庫應(yīng)用程序，本設(shè)計(jì)正是利用了這一點(diǎn)，采用 VisualBasic 的數(shù)據(jù)控件和數(shù)據(jù)綁定控件創(chuàng)建了商校財(cái)務(wù)管理系統(tǒng)。 本設(shè)計(jì)使用數(shù)據(jù)庫控件完成對(duì)數(shù)據(jù)庫表的添加、查詢等功能，這里用到了數(shù)據(jù)控件的事件編程，這些功能主要是通過操作記錄集來完成的。 關(guān)鍵詞 ： 數(shù)據(jù)控件；數(shù)據(jù)綁定控件；記錄集；動(dòng)態(tài)記錄集；數(shù)據(jù)庫 畢業(yè)設(shè)計(jì)（論文） II Abstract Database applied program can be explored quickly with data control and data binding control of Visual is just with this item for the system design that school finance management system is acplished that is with data control and data binding control of Visual Basic. The first step of pleting the system is setting database. Access is selected here. It is because that pired with other databases,Access can be more easily understanded and it can be more easily Microsoft Jet which the data visiting object of Visual Basic gives Access more priority escpecially. Visiting Access with Microsoft Jet can abtain more efficiency. This system achieves the function of adding 、 demand. Here the programming of the events are functions are mainly acplished by operating are majority objects which indicate more objects of objects assembles in one or more forms. A recordset will be e in to being w hen data control is related with database .Dynaset which is acquiescenced by the system is used in this recordset of this type is related with the form of aboriginal database,so when the users operate the recordset of dynaset, the result of the operating will be preserved in the corresponding database. Eccept the basic operating to the forms of the database,the system also includes the function of calculating ,printing and so on. Its visage is so friendly,and the operating is so easily and flexible,that it can be used convenient for users. Key words： Data Control。Database 畢業(yè)設(shè)計(jì)（論文） III 目 錄 第 1 章 緒 論 ........................................................................................................... 5 第 2 章 建立數(shù)據(jù)庫 ................................................................................................. 7 概 述 ........................................................................................................... 7 設(shè)計(jì)一個(gè)數(shù)據(jù)庫的基本步驟 ........................................................... 8 Microsoft Access 數(shù)據(jù)庫簡介 ..................................................................... 9 建立數(shù)據(jù)庫 ............................................................................................... 10 創(chuàng)建數(shù)據(jù)表 ............................................................................................... 11 創(chuàng)建數(shù)據(jù)表的方法 ......................................................................... 11 使用設(shè)計(jì)器創(chuàng)建表 ......................................................................... 11 創(chuàng)建新表 ......................................................................................... 13 數(shù)據(jù)庫轉(zhuǎn)換 ............................................................................................... 14 第 3 章 窗體界面設(shè)計(jì)與操作 ............................................................................... 16 首頁窗體設(shè)計(jì) ........................................................................................... 16 創(chuàng)建新工程 ..................................................................................... 16 添加控件 ......................................................................................... 17 編寫代碼格式 ................................................................................. 18 保存工程和窗體文件 ..................................................................... 19 登 錄窗體設(shè)計(jì) ........................................................................................... 19 系統(tǒng)功能菜單窗體設(shè)計(jì) ........................................................................... 21 概述 ................................................................................................. 21 用菜單編輯器設(shè)計(jì)菜單 ................................................................. 23 密碼修改窗體設(shè)計(jì) ................................................................................... 24 差旅費(fèi)支出輸入表窗體設(shè)計(jì) ................................................................... 26 辦公用品費(fèi)用 ........................................................................................... 28 查詢選擇窗體設(shè)計(jì) ................................................................................... 29 查詢窗體設(shè)計(jì) ........................................................................................... 30 關(guān)于作者窗體設(shè)計(jì) ................................................................................... 31 第 4 章 與窗體設(shè)計(jì)相關(guān)的問題 ........................................................................... 32 添加數(shù)據(jù)訪問控件 ................................................................................... 32 畢業(yè)設(shè)計(jì)（論文） IV Data 控件簡介 ................................................................................. 32 創(chuàng)建 Data 控件 ............................................................................... 33 ADO Data 控件簡介 ........................................................................ 35 VB 鏈接 Access 數(shù)據(jù)庫的方法 ..................................................... 35 添加數(shù)據(jù)感知控件 ................................................................................... 36 添加文本框 ..................................................................................... 36 添加 MSFlexGrid 控件 .................................................................. 36 使用代碼操作記錄 ................................................................................... 37 使用 Recordset 對(duì)象的方法操作記錄 ........................................... 37 使用 SQL 語言對(duì)數(shù)據(jù)庫進(jìn)行查詢 ............................................... 39 出錯(cuò)處理 ......................................................................................... 39 MsgBox 函數(shù)簡介 .................................................................................... 40 計(jì)算器的調(diào)用 ........................................................................................... 41 第 5 章 結(jié) 論 ...............