【正文】 ******學(xué)院本科生畢業(yè)設(shè)計(jì) 學(xué)生宿舍管理系統(tǒng) 的設(shè)計(jì) Design of Student Dormitory Management System 學(xué)生宿舍 管理系統(tǒng)的設(shè)計(jì) 摘要 宿舍管理科在高校宿舍管理工作中承擔(dān)著管理、檢查、督促和協(xié)調(diào)等重要的管理任務(wù)。隨著高校規(guī)模的不斷擴(kuò)大及學(xué)生人數(shù)的不斷增多，宿舍管理也需要得到改進(jìn)和完善。而在傳統(tǒng)的手工管理方式中，由于人力、物力等客觀因素的限制，使得管理上難免會(huì)存在漏洞和不到位。但是，隨著計(jì)算機(jī)技術(shù)、信息技術(shù) 的發(fā)展和廣泛應(yīng)用，信息管理系統(tǒng)作為信息的交互的平臺(tái)已成為大勢(shì)所趨。計(jì)算機(jī)的信息化管理為這些問(wèn)題的解決提供了可能。 結(jié)合目前我院后勤管理情況，通過(guò)咨詢各用戶部門(mén)的需求， 本設(shè)計(jì)使用 Access數(shù)據(jù)庫(kù)和其內(nèi)置的 VBA（ Visual Basic for Application） 語(yǔ)言作為開(kāi)發(fā)工具，設(shè)計(jì)出功能全面的管理系統(tǒng)。 在論文中介紹了設(shè)計(jì)開(kāi)發(fā)的方法及過(guò)程，論證說(shuō)明 Access 數(shù)據(jù)庫(kù)和 VBA 語(yǔ)言工具的特點(diǎn)。 本系統(tǒng)旨在實(shí)現(xiàn)對(duì)現(xiàn)有的宿舍管理系統(tǒng)中遇到的宿舍信息情況和大量數(shù)據(jù)進(jìn)行數(shù)據(jù)庫(kù)存儲(chǔ)的基礎(chǔ)上，設(shè)計(jì)并完成對(duì)其宿舍信息的 分類(lèi) 、 查詢、添加、刪除和修改。系統(tǒng) 操作簡(jiǎn)便、靈活實(shí)用、 界面美觀，對(duì)高校的宿舍管理具有一定的借鑒意義。 關(guān)鍵詞 ：宿舍管理， Access 數(shù)據(jù)庫(kù)， VBA 語(yǔ)言 Design of Student Dormitory Management System Electronic Information Science and Technology 20201 Xie Chunyu Supervisor Chen Shidong Abstract The department of dormitory management plays an important role in college dormitory management, which undertaking the management, the inspection, the supervision and the work in line and so on. With the university scale unceasing expansion and the increasing number of students, the dormitory management also needs to obtain the improvement and the consummation. But the traditional way is manual management, which is limit in some objective factors, such as the manpower, the physical resource and so on. The traditional way is not able to get the task or solve the loopholes. However, with the development of the puter technology and information technology, the widespread application of puter, the information management system has bee as the information interactive platform ultimately. The puter informationization management has provided the possibility for these question solution. The current situation of logistics management in our hospital, through consultation with the needs of user departments. This design uses the VBA（ Visual Basic for Application） language and the Access database as the development tool, designs the management system with a prehensive function. In the paper, the author introduced the method and the process of the design, and proves merits of the Access database and the VBA language tool. The system is designed to achieve the existing dormitory management system of information encountered in quarters and a large amount of data stored in the database based on the design and pletion of the classification of information to their quarters, query, add, delete, and modify. This system existence some merits such as operation simple, nimble practical and contact surface artistic and so on, which has certain model significance to university39。s dormitory management. Key words: Dormitory management, Access database, VBA language 目錄 1 前言 .................................................................................................................................... 1 系統(tǒng)開(kāi)發(fā)應(yīng)用背景 ..................................................................................................... 1 課題研究的意義 ......................................................................................................... 1 系統(tǒng)開(kāi)發(fā)環(huán)境的選擇 ................................................................................................. 1 2 數(shù)據(jù)庫(kù)系統(tǒng)的介紹 ............................................................................................................ 1 數(shù)據(jù)庫(kù)的概念、發(fā)展及其優(yōu)點(diǎn) ................................................................................. 1 數(shù)據(jù)庫(kù)的概念 ...................................................................................................... 1 數(shù)據(jù)庫(kù)的發(fā)展 ................................................................................................... 2 VBA 語(yǔ)言簡(jiǎn) 介 ............................................................................................................ 4 數(shù)據(jù)庫(kù)設(shè)計(jì)的一般步驟 ............................................................................................. 4 需求分析 .............................................................................................................. 5 邏輯設(shè)計(jì)結(jié)構(gòu) ...................................................................................................... 5 物理設(shè)計(jì)結(jié)構(gòu) ...................................................................................................... 6 數(shù)據(jù)庫(kù)的實(shí)施 ...................................................................................................... 6 數(shù)據(jù)庫(kù)的運(yùn)行與維護(hù) .......................................................................................... 6 3 系統(tǒng)分析與總體設(shè)計(jì) ........................................................................................................ 6 系統(tǒng)需求分析 ............................................................................................................. 6 系統(tǒng)功能描述 ............................................................................................................. 7 系統(tǒng)功能模塊劃分 ..................................................................................................... 7 4 數(shù)據(jù)庫(kù)的基礎(chǔ)認(rèn)識(shí) ........................................................................................................... 8 數(shù)據(jù)表的創(chuàng)建 ............................................................................................................. 8 數(shù)據(jù)表之間的關(guān)系 ..................................................................................................... 8 窗體的基本認(rèn)識(shí) ......................................................................................................... 9 5 系統(tǒng)功能模塊的設(shè)計(jì) ........................................................................................................ 9 登錄窗體的設(shè)計(jì) ......................................................................................................... 9 主窗體的設(shè)計(jì) ........................................................................................................... 11 學(xué)生基本信息窗體的設(shè)計(jì) ....................................................................................