學(xué)籍管理系統(tǒng)
摘  要
  
學(xué)籍管理系統(tǒng)是典型的信息管理系統(tǒng)(MIS),其開發(fā)主要包括后臺數(shù)據(jù)庫的建立和維護(hù)以及前端應(yīng)用程序的開發(fā)兩個(gè)方面。對于前者要求建立起數(shù)據(jù)一致性和完整性強(qiáng)、數(shù)據(jù)安全性好的庫。而對于后者則要求應(yīng)用程序功能完備,易使用等特點(diǎn)。
本系統(tǒng)主要完成對學(xué)生情況和學(xué)生成績的管理，包括數(shù)據(jù)庫中表的添加、修改、刪除等。系統(tǒng)還可以完成對各類信息的瀏覽、查詢、添加、刪除、修改、報(bào)表等功能。
系統(tǒng)的核心是數(shù)據(jù)庫中各個(gè)表聯(lián)系，每一個(gè)表的修改都將聯(lián)動(dòng)的影響其它的表，當(dāng)完成對數(shù)據(jù)的操作時(shí)系統(tǒng)會(huì)自動(dòng)地完成數(shù)據(jù)庫的修改。查詢功能也是系統(tǒng)的核心之一，在系統(tǒng)中即有單條件查詢和多條件查詢，也有精確查詢和模糊查詢，系統(tǒng)不僅有靜態(tài)的條件查詢，也有動(dòng)態(tài)生成的條件查詢，其目的都是為了方便用戶使用。系統(tǒng)有完整的用戶添加、刪除和密碼修改功能，并具備報(bào)表打印功能。
經(jīng)過分析,我們使用 MICROSOFT公司的 VISUAL BASIC開發(fā)工具,利用其提供的各種面向?qū)ο蟮拈_發(fā)工具,尤其是數(shù)據(jù)窗口這一能方便而簡潔操縱數(shù)據(jù)庫的智能化對象,首先在短時(shí)間內(nèi)建立系統(tǒng)應(yīng)用原型,然后,對初始原型系統(tǒng)進(jìn)行需求迭代,不斷修正和改進(jìn),直到形成用戶滿意的可行系統(tǒng)。
關(guān)鍵字：管理信息系統(tǒng)、數(shù)據(jù)庫、vb6.0、access2000。
ABSTRACT
Student status management system is development two aspects that typical information management system, IMS( MIS), its development includes primarily the background database creates with support and the front end applies the procedure.Creates to rise to the former request the consistency of data is strong with the integrity, the library that the safeness of data like.But request the latter very much to apply the procedure function complete, easy usage etc. characteristics.
This system completes primarily to student's circumstance with the management of student's score, include the database the inside the watch increase, modify, delete etc..The system can also complete to the browsing of various information, search, increase, delete, modify, report etc. function.
System of nucleus is other table in an influence for of relation, each a modification of watch moving in a table in database that modification that operation hour system, be to complete the logarithms according to will complete the database of oneself.Search the function is also one of the nucleus of the system, having namely in system the single condition search to search with many conditions, also having the accurate search to search with blur, system not only contain static condition search, also have the dynamic born condition search, its purpose is all for the sake of the convenient consumer to use.System contain complete consumer increase, delete to modify the function with the password, the union has the report prints the function.
Through analysis, we use the MICROSOFT company VISUAL BASIC development tool, making use of its every kind of the tool of development that provide that face to the object, particularly is intelligence that the window of data this on canning be convenient but manipulate the database in brief to turn the object, create in the in a short time first system application prototype, then, start to the beginning the prototype system proceeds to require with the iteration, revising continuously with improve, until forming the consumer is satisfied can row system.
Keywords: MIS, database, vb6.0, access2000.
 
目  錄

前  言 1
第一章  概述 1
1.1課題來源 1
1.2 開發(fā)工具的選用 2
1.2.1 Visual Basic的使用 2
1.2.2 Microsoft Access的使用 3
1.3 系統(tǒng)的初步調(diào)查 3
1.4 系統(tǒng)的可行性研究 4
1.4.1技術(shù)上的可行性 4
1.4.2管理上的可行性 4
1.4.3安全上的可行性 4
1.5 系統(tǒng)分析 4
1.5.1系統(tǒng)的安全性 4
1.5.2系統(tǒng)的快捷性 5
1.5.3系統(tǒng)的準(zhǔn)確性 5
1.5.4系統(tǒng)的嚴(yán)謹(jǐn)性 5
第二章  概要設(shè)計(jì) 5
2.1 系統(tǒng)設(shè)計(jì)思路 5
2.1.1界面設(shè)計(jì) 5
2.1.2用戶登陸 5
2.1.3學(xué)籍信息內(nèi)容查詢和錄入 6
2.1.4數(shù)據(jù)庫分析 6
2.2 設(shè)計(jì)簡述 6
2.2.1 vb設(shè)計(jì)的界面簡述 6
2.2.2 Access2000設(shè)計(jì)數(shù)據(jù)庫 7
2.2.3系統(tǒng)簡圖 7
2.3 設(shè)計(jì)需求 7
2.3.1 運(yùn)行設(shè)計(jì) 7
2.3.2 出錯(cuò)處理設(shè)計(jì) 8
2.3.3安全保密設(shè)計(jì) 8
2.3.4維護(hù)設(shè)計(jì) 8
第三章  詳細(xì)設(shè)計(jì) 9
3.1 數(shù)據(jù)庫的實(shí)現(xiàn) 9
3.1.1課程表 9
3.1.2學(xué)生情況表 9
3.1.3學(xué)生與課程表 9
3.2 界面的實(shí)現(xiàn) 9
3.2.1登陸界面 9
3.2.3 主界面 10
3.2.4 基本信息錄入 11
3.2.5 成績錄入 14
3.2.6 信息查詢 16
3.2.7 報(bào)表輸出 18
第四章  數(shù)據(jù)測試 18
第五章  總結(jié) 19
5.1 編程心得 19
5.2 感謝 19
參考文獻(xiàn) 20