第 1章數(shù)據(jù)庫基礎知識··············································································1 1.1 數(shù)據(jù)庫系統(tǒng)概述 ···········································································1 1.1.1數(shù)據(jù)處理 ·········································································1 1.1.2數(shù)據(jù)管理的發(fā)展································································2 1.1.3數(shù)據(jù)庫系統(tǒng)的組成·····························································3 1.1.4數(shù)據(jù)庫系統(tǒng)的特點·····························································6 1.2 數(shù)據(jù)模型 ···················································································7 1.2.1數(shù)據(jù)抽象的過程································································7 1.2.2概念模型 ·········································································8 1.2.3邏輯模型 ·········································································9 1.2.4外部模型 ······································································· 10 1.2.5內部模型 ······································································· 11 1.3 關系數(shù)據(jù)庫 ·············································································· 11 1.3.1關系模型 ······································································· 11 1.3.2關系運算 ······································································· 14 1.4 數(shù)據(jù)庫系統(tǒng)的體系結構 ································································ 17 1.4.1三級模式 ······································································· 17 1.4.2二級映像 ······································································· 18 1.5 Access簡介 ············································································· 19 1.5.1Access概述 ·································································· 19 1.5.2Access 2010的工作界面 ·················································· 19 1.5.3Access的六大對象 ························································· 22 本章小結 ························································································ 23 知識結構圖 ····················································································· 23 思考題 ··························································································· 24 第 2章數(shù)據(jù)庫和表的基本操作 ································································· 25 2.1 數(shù)據(jù)庫的基本操作 ······································································ 25 2.1.1創(chuàng)建數(shù)據(jù)庫···································································· 25 2.1.2打開與關閉數(shù)據(jù)庫··························································· 28 2.1.3數(shù)據(jù)庫加密···································································· 28 2.1.4數(shù)據(jù)庫備份···································································· 30 2.2 創(chuàng)建表 ···················································································· 31 2.2.1數(shù)據(jù)表的組成································································· 31 2.2.2創(chuàng)建數(shù)據(jù)表的常用方法····················································· 33 2.2.3設置字段屬性································································· 37 2.2.4建立表間關系································································· 44 2.2.5向表中輸入數(shù)據(jù)······························································ 46 2.3 表的編輯 ················································································· 55 2.3.1修改表的結構································································· 55 2.3.2編輯表的內容································································· 56 2.4 使用表 ···················································································· 58 2.4.1記錄排序 ······································································· 58 2.4.2數(shù)據(jù)篩選 ······································································· 59 2.4.3記錄匯總 ······································································· 60 2.4.4數(shù)據(jù)導出 ······································································· 60 本章小結 ························································································ 64 知識結構圖 ····················································································· 64 思考題 ··························································································· 64 第 3章數(shù)據(jù)查詢 ······················································································ 65 3.1 查詢概述 ················································································· 65 3.1.1查詢的功能···································································· 65 3.1.2查詢的視圖···································································· 66 3.1.3查詢的類型···································································· 66 3.1.4查詢條件 ······································································· 68 3.2 創(chuàng)建選擇查詢 ··········································································· 70 3.2.1使用查詢向導創(chuàng)建選擇查詢··············································· 70 3.2.2使用設計視圖創(chuàng)建選擇查詢··············································· 73 3.3 創(chuàng)建交叉表查詢 ········································································· 79 3.3.1使用查詢向導創(chuàng)建交叉表查詢············································ 80 3.3.2使用設計視圖創(chuàng)建交叉表查詢············································ 81 3.4 創(chuàng)建參數(shù)查詢 ··········································································· 82 3.5 創(chuàng)建操作查詢 ··········································································· 85 3.5.1更新查詢 ······································································· 85 3.5.2生成表查詢···································································· 86 3.5.3追加查詢 ······································································· 88 3.5.4刪除查詢 ······································································· 89 3.6 結構化查詢語言（ SQL）····························································· 90 3.6.1SQL簡介 ······································································ 90 3.6.2數(shù)據(jù)定義 ······································································· 91 3.6.3數(shù)據(jù)操縱 ······································································· 93 3.6.4數(shù)據(jù)查詢 ······································································· 94 3.6.5聯(lián)合查詢 ······································································· 97 3.6.6傳遞查詢 ······································································· 98 本章小結 ························································································ 99 知識結構圖····················································································· 99 思考題 ··························································································· 99 第 4章窗體····························································································100 4.1 窗體概述 ················································································100 4.1.1窗體的功能···································································100 4.1.2窗體的組成···································································101 4.1.3窗體的分類···································································102 4.1.4窗體的視圖···································································104 4.2 創(chuàng)建窗體 ················································································106 4.2.1使用工具自動創(chuàng)建窗體····················································106 4.2.2使用窗體向導創(chuàng)建窗體····················································108 4.2.3使用“空白窗體”工具創(chuàng)建窗體········································110 4.2.4創(chuàng)建數(shù)據(jù)透視表和數(shù)據(jù)透視圖窗體····································· 111 4.2.5設計視圖創(chuàng)建窗體·························································· 115 4.2.6創(chuàng)建主/子窗體 ······························································· 117 4.3 常用控件及其應用 ·····································································122 4.3.1窗體的“設計”選項卡····················································123 4.3.2窗體和控件的屬性··························································124 4.3.3常用控件的設計·····························································127 4.4 美化窗體 ················································································141 4.4.1主題的應用···································································141 4.4.2條件格式使用及表格式窗體的快速實現(xiàn)·······························141 4.4.3在窗體中添加圖片··························································145 4.4.4控件外觀調整································································147 本章小結 ·······················································································149 知識結構圖 ····················································································149 思考題 ··························································································150 第 5章報表····························································································151 5.1 報表概述 ················································································151 5.1.1報表的組成···································································151 5.1.2報表的類型···································································153 5.1.3報表的視圖···································································154 5.2 創(chuàng)建報表 ················································································155 5.2.1使用“報表”工具創(chuàng)建報表··············································155 5.2.2使用“報表向導”工具創(chuàng)建報表········································156 5.2.3使用“空報表”工具創(chuàng)建報表···········································158 5.2.4創(chuàng)建標簽報表································································159 5.2.5使用“報表設計”工具創(chuàng)建報表········································161 5.2.6創(chuàng)建主/子報表 ·······························································163 5.2.7利用“報表設計”按鈕創(chuàng)建圖表報表··································165 5.3 編輯報表 ················································································168 5.3.1修改布局樣式································································168 5.3.2添加分組和排序·····························································170 5.3.3添加計算 ······································································172 5.3.4添加常用美化控件··························································174 5.4報表的預覽和打印 ·····································································177 5.4.1預覽報表 ······································································177 5.4.2頁面設置 ······································································178 5.4.3打印報表 ······································································179 本章小結 ·······················································································179 知識結構圖 ····················································································180 思考題 ··························································································180 第 6章宏 ·······························································································181 6.1 宏的概述················································································181 6.1.1宏的概念 ······································································181 6.1.2宏的功能 ······································································182 6.2 宏的創(chuàng)建及運行 ········································································182 6.2.1宏的設計窗口································································182 6.2.2創(chuàng)建獨立的宏································································183 6.2.3直接運行宏···································································184 6.2.4創(chuàng)建宏組 ······································································185 6.2.5創(chuàng)建條件宏···································································187 6.2.6創(chuàng)建事件宏···································································189 6.3 常用的宏操作 ··········································································191 6.4 使用宏創(chuàng)建菜單 ········································································191 本章小結 ·······················································································194 知識結構圖 ····················································································194 思考題 ··························································································194 第 7章VBA編程 ····················································································195 7.1 面向對象程序設計 ·····································································195 7.2 VBA的模塊及編輯環(huán)境······························································196 7.2.1類模塊和標準模塊··························································197 7.2.2將宏轉換為模塊·····························································197 7.2.3VBA編輯環(huán)境 ·······························································198 7.2.4創(chuàng)建模塊與過程·····························································199 7.3 VBA編程基礎··········································································201 7.3.1數(shù)據(jù)類型 ······································································201 7.3.2常量、變量和數(shù)組··························································202 7.3.3函數(shù) ············································································205 7.3.4運算符和表達式·····························································209 7.4 VBA程序控制·········································································· 211 7.4.1順序結構······································································ 211 7.4.2選擇結構 ······································································213 7.4.3循環(huán)結構 ······································································219 7.5 過程調用和參數(shù)傳遞 ··································································223 7.5.1創(chuàng)建事件過程································································223 7.5.2子過程的定義和調用·······················································225 7.5.3Function過程的定義和調用 ··············································226 7.5.4參數(shù)傳遞 ······································································226 7.6 VBA編程訪問數(shù)據(jù)庫 ·································································227 7.6.1數(shù)據(jù)庫引擎及其接口·······················································227 7.6.2數(shù)據(jù)訪問對象································································228 7.6.3ActiveX數(shù)據(jù)對象 ···························································229 本章小結 ·······················································································236 知識結構圖 ····················································································237 思考題 ··························································································237 第 8章數(shù)據(jù)庫設計與開發(fā) ·······································································238 8.1 應用系統(tǒng)開發(fā)概述 ·····································································238 8.2 數(shù)據(jù)庫設計 ·············································································239 8.2.1數(shù)據(jù)庫設計規(guī)劃·····························································239 8.2.2用戶需求分析與概念結構設計···········································240 8.2.3邏輯結構設計································································240 8.2.4物理結構設計································································242 8.2.5數(shù)據(jù)庫的實現(xiàn)、運行與系統(tǒng)維護········································242 本章小結 ·······················································································243 知識結構圖 ····················································································243 思考題 ··························································································244 附錄 A字段常用屬性···············································································245 附錄 B窗體常用屬性···············································································246 附錄 C控件常用屬性··············································································248 附錄 D常用事件·····················································································250 附錄 E常用的宏命令···············································································253 附錄 F常用函數(shù)······················································································255 參考文獻 ···································································································258