【正文】 ******學院本科生畢業(yè)設計 學生宿舍管理系統(tǒng) 的設計 Design of Student Dormitory Management System 學生宿舍 管理系統(tǒng)的設計 摘要 宿舍管理科在高校宿舍管理工作中承擔著管理、檢查、督促和協(xié)調等重要的管理任務。隨著高校規(guī)模的不斷擴大及學生人數(shù)的不斷增多，宿舍管理也需要得到改進和完善。而在傳統(tǒng)的手工管理方式中，由于人力、物力等客觀因素的限制，使得管理上難免會存在漏洞和不到位。但是，隨著計算機技術、信息技術 的發(fā)展和廣泛應用，信息管理系統(tǒng)作為信息的交互的平臺已成為大勢所趨。計算機的信息化管理為這些問題的解決提供了可能。 結合目前我院后勤管理情況，通過咨詢各用戶部門的需求， 本設計使用 Access數(shù)據(jù)庫和其內置的 VBA（ Visual Basic for Application） 語言作為開發(fā)工具，設計出功能全面的管理系統(tǒng)。 在論文中介紹了設計開發(fā)的方法及過程，論證說明 Access 數(shù)據(jù)庫和 VBA 語言工具的特點。 本系統(tǒng)旨在實現(xiàn)對現(xiàn)有的宿舍管理系統(tǒng)中遇到的宿舍信息情況和大量數(shù)據(jù)進行數(shù)據(jù)庫存儲的基礎上，設計并完成對其宿舍信息的 分類 、 查詢、添加、刪除和修改。系統(tǒng) 操作簡便、靈活實用、 界面美觀，對高校的宿舍管理具有一定的借鑒意義。 關鍵詞 ：宿舍管理， Access 數(shù)據(jù)庫， VBA 語言 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)開發(fā)應用背景 ..................................................................................................... 1 課題研究的意義 ......................................................................................................... 1 系統(tǒng)開發(fā)環(huán)境的選擇 ................................................................................................. 1 2 數(shù)據(jù)庫系統(tǒng)的介紹 ............................................................................................................ 1 數(shù)據(jù)庫的概念、發(fā)展及其優(yōu)點 ................................................................................. 1 數(shù)據(jù)庫的概念 ...................................................................................................... 1 數(shù)據(jù)庫的發(fā)展 ................................................................................................... 2 VBA 語言簡 介 ............................................................................................................ 4 數(shù)據(jù)庫設計的一般步驟 ............................................................................................. 4 需求分析 .............................................................................................................. 5 邏輯設計結構 ...................................................................................................... 5 物理設計結構 ...................................................................................................... 6 數(shù)據(jù)庫的實施 ...................................................................................................... 6 數(shù)據(jù)庫的運行與維護 .......................................................................................... 6 3 系統(tǒng)分析與總體設計 ........................................................................................................ 6 系統(tǒng)需求分析 ............................................................................................................. 6 系統(tǒng)功能描述 ............................................................................................................. 7 系統(tǒng)功能模塊劃分 ..................................................................................................... 7 4 數(shù)據(jù)庫的基礎認識 ........................................................................................................... 8 數(shù)據(jù)表的創(chuàng)建 ............................................................................................................. 8 數(shù)據(jù)表之間的關系 ..................................................................................................... 8 窗體的基本認識 ......................................................................................................... 9 5 系統(tǒng)功能模塊的設計 ........................................................................................................ 9 登錄窗體的設計 ......................................................................................................... 9 主窗體的設計 ........................................................................................................... 11 學生基本信息窗體的設計 ....................................................................................