【正文】 signer to carry on the analysis and the design the system, the system Execution is through Visualbasic. Use FlexCell, DTPicker, Listbar and other Highlevel controls software. Then founds the general data accessing module: . This module Standard the Process of ADO data access, only a modification of the connection character string then to realize a visit of many kinds of different databases system. By calculating account balances algorithm research, I have grasped the skill of using the SQLsentence to visit database. In this paper, personal wealth management software to achieve plete revenue expenditure account management, assetliability management, data derived, and multiaccounts books of operation and the automatic generation of financial statements. It can work monly under each kind of Windows operating system so it can achieve the anticipated design. Key word: Database， ADO， Visual Basic， Personal financing 某某某某 大學(xué)畢業(yè)論文 目錄 III 目錄 摘要 .................................................................................................................... I ABSTRACT .................................................................................................... II 目錄 ................................................................................................................. III 第一章 緒論 ..................................................................................................... 1 什么是個(gè)人 (家庭 )理財(cái) .......................................................................... 1 個(gè)人理財(cái)分析中最 重要的四份財(cái)務(wù)報(bào)表 ............................................ 1 常見(jiàn)個(gè)人理財(cái)軟件分析 ........................................................................ 2 第二章 系統(tǒng)功能介紹 ..................................................................................... 3 系統(tǒng)簡(jiǎn)介 ................................................................................................ 3 系統(tǒng)主要功能 ........................................................................................ 3 系統(tǒng)特點(diǎn) ................................................................................................ 4 系統(tǒng)運(yùn)行界面 ........................................................................................ 4 第三章 系統(tǒng)設(shè)計(jì) ............................................................................................. 7 系統(tǒng)需求分析 ........................................................................................ 7 系統(tǒng)性能要求 ........................................................................................ 7 硬件配置要求 ........................................................................................ 7 軟件開(kāi)發(fā)所需軟件配置要求 ................................................................ 8 系統(tǒng)結(jié)構(gòu)設(shè)計(jì)圖 .................................................................................... 9 數(shù)據(jù)庫(kù)分析設(shè)計(jì) .................................................................................... 9 系統(tǒng) ER 圖 ................................................................................... 11 數(shù)據(jù)字典 ....................................................................................... 12 創(chuàng)建表關(guān)系 ................................................................................... 16 創(chuàng)建查詢 ....................................................................................... 17 第四章 系統(tǒng)實(shí)現(xiàn) ........................................................................................... 19 系統(tǒng)主界面 .......................................................................................... 19 創(chuàng)建工程項(xiàng)目 ............................................................................... 19 創(chuàng)建系統(tǒng)主窗體 ........................................................................... 20 主窗口菜單 ................................................................................... 22 公用模塊 .............................................................................................. 24 ....................................................................... 24 .................................................................................. 24 某某某某 大學(xué)畢業(yè)論文 目錄 IV ADO 數(shù)據(jù)訪問(wèn)技術(shù) .............................................................................. 25 從 Microsoft Visual Basic 引用 ADO 的步驟 .......................... 25 在 Visual Basic 中創(chuàng)建 ADO 對(duì)象 .......................................... 26 FLEXCELL 表格控件 .............................................................................. 26 賬套管理 .............................................................................................. 29 選用賬套 ....................................................................................... 30 新建賬套 ....................................................................................... 30 刪 除賬套 ....................................................................................... 31 日常收支流水賬 .................................................................................. 32 信息流覽頁(yè)面 ............................................................................... 32 收支記錄管理界面 ....................................................................... 34 年度收支統(tǒng)計(jì)表 .................................................................................. 36 對(duì)計(jì)算賬戶余額算法的研究 ............................................................... 37 用數(shù)據(jù)指針對(duì)數(shù)據(jù)集進(jìn)行處理 ................................................... 37 用 SQL 函數(shù)對(duì)數(shù)據(jù)集進(jìn)行處理 ................................................. 38 算法比較 ....................................................................................... 39 對(duì)程序錯(cuò)誤的處理 .............................................................................. 41 使用 On Error Resume Next 錯(cuò)誤處理程序 ................................ 41 使用 On Error GoTo 錯(cuò)誤處理程序 ............................................. 42 創(chuàng)建統(tǒng)一的錯(cuò)誤處理程序塊 ....................................................... 42