【正文】 ......................................................................................... 1 2 數(shù)據(jù)庫系統(tǒng)的介紹 ............................................................................................................ 1 數(shù)據(jù)庫的概念、發(fā)展及其優(yōu)點(diǎn) ................................................................................. 1 數(shù)據(jù)庫的概念 ...................................................................................................... 1 數(shù)據(jù)庫的發(fā)展 ................................................................................................... 2 VBA 語言簡 介 ............................................................................................................ 4 數(shù)據(jù)庫設(shè)計的一般步驟 ............................................................................................. 4 需求分析 .............................................................................................................. 5 邏輯設(shè)計結(jié)構(gòu) ...................................................................................................... 5 物理設(shè)計結(jié)構(gòu) ...................................................................................................... 6 數(shù)據(jù)庫的實(shí)施 ...................................................................................................... 6 數(shù)據(jù)庫的運(yùn)行與維護(hù) .......................................................................................... 6 3 系統(tǒng)分析與總體設(shè)計 ........................................................................................................ 6 系統(tǒng)需求分析 ............................................................................................................. 6 系統(tǒng)功能描述 ............................................................................................................. 7 系統(tǒng)功能模塊劃分 ..................................................................................................... 7 4 數(shù)據(jù)庫的基礎(chǔ)認(rèn)識 ........................................................................................................... 8 數(shù)據(jù)表的創(chuàng)建 ............................................................................................................. 8 數(shù)據(jù)表之間的關(guān)系 ..................................................................................................... 8 窗體的基本認(rèn)識 ......................................................................................................... 9 5 系統(tǒng)功能模塊的設(shè)計 ........................................................................................................ 9 登錄窗體的設(shè)計 ......................................................................................................... 9 主窗體的設(shè)計 ........................................................................................................... 11 學(xué)生基本信息窗體的設(shè)計 ....................................................................................... 11 查詢模塊的設(shè)計 ....................................................................................................... 13 查詢的概念 ........................................................................................................ 13 創(chuàng)建選擇查詢 .................................................................................................... 14 宿舍基本管理模塊的設(shè)計 ....................................................................................... 16 宿舍狀態(tài)圖 的設(shè)計 ................................................................................................... 17 報表顯示的設(shè)計 ....................................................................................................... 17 系統(tǒng)權(quán)限窗體的設(shè)計 ............................................................................................... 19 密碼維護(hù)窗體的創(chuàng)建 ............................................................................................... 20 幫助窗體的設(shè)計 ..................................................................................................... 21 6 應(yīng)用系統(tǒng)設(shè)計 .................................................................................................................. 21 為窗體定義自定義菜單 ........................................................................................... 21 設(shè)置基本啟動選項(xiàng) ................................................................................................... 22 系統(tǒng)使用評價 ........................................................................................................... 23 7 結(jié)束語 .............................................................................................................................. 23 致謝 ..................................................................................................................................... 24 參考文獻(xiàn) ............................................................................................................................. 25 附錄 ..................................................................................................................................... 26 1 1 前言 系統(tǒng)開發(fā)應(yīng)用背景 MIS(Management Information System， 管理信息系統(tǒng) )是 以管理學(xué)、會計學(xué) 、經(jīng)營管理理論、統(tǒng)計學(xué)、計算機(jī)處理等多學(xué)科為基礎(chǔ)，為經(jīng)營管理者提供有用的信息而建立的系統(tǒng)。 在論文中介紹了設(shè)計開發(fā)的方法及過程，論證說明 Access 數(shù)據(jù)庫和 VBA 語言工具的特點(diǎn)。而在傳統(tǒng)的手工管理方式中，由于人力、物力等客觀因素的限制，使得管理上難免會存在漏洞和不到位。隨著高校規(guī)模的不斷擴(kuò)大及學(xué)生人數(shù)的不斷增多，宿舍管理也需要得到改進(jìn)和完善。 結(jié)合目前我院后勤管理情況，通過咨詢各用戶部門的需求， 本設(shè)計使用 Access數(shù)據(jù)庫和其內(nèi)置的 VBA（ Visual Basic for Application） 語言作為開發(fā)工具，設(shè)計出功能全面的管理系統(tǒng)。 關(guān)鍵詞 ：宿舍管理， 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