【正文】 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 某某某某 大學畢業(yè)論文 目錄 III 目錄 摘要 .................................................................................................................... I ABSTRACT .................................................................................................... II 目錄 ................................................................................................................. III 第一章 緒論 ..................................................................................................... 1 什么是個人 (家庭 )理財 .......................................................................... 1 個人理財分析中最 重要的四份財務報表 ............................................ 1 常見個人理財軟件分析 ........................................................................ 2 第二章 系統(tǒng)功能介紹 ..................................................................................... 3 系統(tǒng)簡介 ................................................................................................ 3 系統(tǒng)主要功能 ........................................................................................ 3 系統(tǒng)特點 ................................................................................................ 4 系統(tǒng)運行界面 ........................................................................................ 4 第三章 系統(tǒng)設(shè)計 ............................................................................................. 7 系統(tǒng)需求分析 ........................................................................................ 7 系統(tǒng)性能要求 ........................................................................................ 7 硬件配置要求 ........................................................................................ 7 軟件開發(fā)所需軟件配置要求 ................................................................ 8 系統(tǒng)結(jié)構(gòu)設(shè)計圖 .................................................................................... 9 數(shù)據(jù)庫分析設(shè)計 .................................................................................... 9 系統(tǒng) ER 圖 ................................................................................... 11 數(shù)據(jù)字典 ....................................................................................... 12 創(chuàng)建表關(guān)系 ................................................................................... 16 創(chuàng)建查詢 ....................................................................................... 17 第四章 系統(tǒng)實現(xiàn) ........................................................................................... 19 系統(tǒng)主界面 .......................................................................................... 19 創(chuàng)建工程項目 ............................................................................... 19 創(chuàng)建系統(tǒng)主窗體 ........................................................................... 20 主窗口菜單 ................................................................................... 22 公用模塊 .............................................................................................. 24 ....................................................................... 24 .................................................................................. 24 某某某某 大學畢業(yè)論文 目錄 IV ADO 數(shù)據(jù)訪問技術(shù) .............................................................................. 25 從 Microsoft Visual Basic 引用 ADO 的步驟 .......................... 25 在 Visual Basic 中創(chuàng)建 ADO 對象 .......................................... 26 FLEXCELL 表格控件 .............................................................................. 26 賬套管理 .............................................................................................. 29 選用賬套 ....................................................................................... 30 新建賬套 ....................................................................................... 30 刪 除賬套 ....................................................................................... 31 日常收支流水賬 .................................................................................. 32 信息流覽頁面 ............................................................................... 32 收支記錄管理界面 ....................................................................... 34 年度收支統(tǒng)計表 .................................................................................. 36 對計算賬戶余額算法的研究 ............................................................... 37 用數(shù)據(jù)指針對數(shù)據(jù)集進行處理 ................................................... 37 用 SQL 函數(shù)對數(shù)據(jù)集進行處理 ................................................. 38 算法比較 ....................................................................................... 39 對程序錯誤的處理 .............................................................................. 41 使用 On Error Resume Next 錯誤處理程序 ................................ 41 使用 On Error GoTo 錯誤處理程序 ............................................. 42 創(chuàng)建統(tǒng)一的錯誤處理程序塊 ....................................................... 42