資源描述:
《財務(wù)管理系統(tǒng)—免費畢業(yè)設(shè)計論文》由會員上傳分享,免費在線閱讀,更多相關(guān)內(nèi)容在學(xué)術(shù)論文-天天文庫。
1、畢業(yè)設(shè)計(論文)財務(wù)管理系統(tǒng)摘要利用VisualBasic的數(shù)據(jù)控件和數(shù)據(jù)綁定控件可以快速地開發(fā)出數(shù)據(jù)庫應(yīng)用程序,本設(shè)計正是利用了這一點,采用VisualBasic的數(shù)據(jù)控件和數(shù)據(jù)綁定控件創(chuàng)建了商校財務(wù)管理系統(tǒng)。實現(xiàn)此程序的第一步就是創(chuàng)建數(shù)據(jù)庫,這里選擇了Access來建立數(shù)據(jù)庫。這是因為,MicrosoftAccess與其他的數(shù)據(jù)庫軟件相比,其理解和使用都更為簡單,而且VisualBasic的數(shù)據(jù)訪問對象所使用的MicrosoftJet數(shù)據(jù)庫引擎專門對Access數(shù)據(jù)庫進(jìn)行了優(yōu)化,使用MicrosoftJet數(shù)據(jù)庫引擎來訪問Access數(shù)據(jù)庫可以獲得更高的效率
2、。本設(shè)計使用數(shù)據(jù)庫控件完成對數(shù)據(jù)庫表的添加、查詢等功能,這里用到了數(shù)據(jù)控件的事件編程,這些功能主要是通過操作記錄集來完成的。記錄集是表示一個或幾個表格中的對象集合的多個對象,當(dāng)數(shù)據(jù)控件跟數(shù)據(jù)庫相關(guān)聯(lián)后便會產(chǎn)生一個記錄集。本設(shè)計中使用了記錄集默認(rèn)的類型動態(tài)記錄集,此類型的記錄集是和原始數(shù)據(jù)庫中的表相關(guān)聯(lián)的,因此用戶對動態(tài)類型記錄集的操作都會被保存到相應(yīng)的數(shù)據(jù)庫中。除對數(shù)據(jù)庫表的基本操作外,此系統(tǒng)還設(shè)計有計算器、打印等功能,界面友好,方便靈活,便于用戶使用。關(guān)鍵詞:數(shù)據(jù)控件;數(shù)據(jù)綁定控件;記錄集;動態(tài)記錄集;數(shù)據(jù)庫57畢業(yè)設(shè)計(論文)AbstractDatabase
3、appliedprogramcanbeexploredquicklywithdatacontrolanddatabindingcontrolofVisualBasic.ItisjustwiththisitemforthesystemdesignthatschoolfinancemanagementsystemisaccomplishedthatiswithdatacontrolanddatabindingcontrolofVisualBasic.Thefirststepofcompletingthesystemissettingdatabase.Accessis
4、selectedhere.Itisbecausethatcompiredwithotherdatabases,Accesscanbemoreeasilyunderstandedanditcanbemoreeasilyapplied.AndMicrosoftJetwhichthedatavisitingobjectofVisualBasicgivesAccessmorepriorityescpecially.VisitingAccesswithMicrosoftJetcanabtainmoreefficiency.Thissystemachievesthefunc
5、tionofadding、demand.Heretheprogrammingoftheeventsareused.Thesefunctionsaremainlyaccomplishedbyoperatingrecordset.Recordsetaremajorityobjectswhichindicatemoreobjectsofobjectsassemblesinoneormoreforms.Arecordsetwillbecomeintobeingwhendatacontrolisrelatedwithdatabase.Dynasetwhichisacqui
6、escencedbythesystemisusedinthissystem.Therecordsetofthistypeisrelatedwiththeformofaboriginaldatabase,sowhentheusersoperatetherecordsetofdynaset,theresultoftheoperatingwillbepreservedinthecorrespondingdatabase.Ecceptthebasicoperatingtotheformsofthedatabase,thesystemalsoincludesthefunc
7、tionofcalculating,printingandsoon.Itsvisageissofriendly,andtheoperatingissoeasilyandflexible,thatitcanbeusedconvenientforusers.Keywords:DataControl;DataBindingControl;Recordset;Dynaset;Database57畢業(yè)設(shè)計(論文)目錄第1章緒論1第2章建立數(shù)據(jù)庫22.1概述22.1.1設(shè)計一個數(shù)據(jù)庫的基本步驟32.2MicrosoftAccess數(shù)據(jù)庫簡介42.3建立數(shù)據(jù)庫52.4創(chuàng)建數(shù)據(jù)
8、表62.4.1創(chuàng)建數(shù)據(jù)表