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