Access 2010為軟件支撐環境，以應用為目的，以案例為引導，融入計算思維，既考慮理論基礎的系統性，又強調實踐技術的應用，由淺入深、循序漸進地介紹關系數據庫管理系統的基礎理論及系統開發技術。全書分為 8章，內容上以“學生成績管理系統”來組織材料。應用系統貫穿全書，圍繞它編排了大量翔實的實例，實例新穎、系統，相互呼應。實例涵蓋表、查詢、窗體、報表、宏、模塊六大數據庫對象的創建和使用方法。每章附有知識結構圖，方便讀者歸納、總結。本書力求內容系統、結構嚴謹、實例豐富、語言通俗易懂，突出“利用數據庫技術進行數據綜合分析和展示分析結果”能力的培養。本書既可以作為高等院�！皵祿䦷旒夹g及應用”課程的教材，也可作為全國計算機等級考試考生的培訓輔導書，還可作為讀者自學提高的參考書。
童啟，中國計算機學會會員，現任湖南工業大學計算機學院基礎課部副主任，研究方向包括數據挖掘、計算機教育等。近三年來主持湖南省教育廳教改項目1項、湖南省教育廳科研項目1項、校重點教學改革項目1項；參與湖南省"十二五”教育科學規劃課題、教育部產學合作協調育人項目、湖南省自然科學基金項目多項；作為主要成員參加了省級精品課程《C語言程序設計》等多個教學改革質量工程項目；近3年主編教材2部；2016年獲得湖南省普通高校教師信息化教學競賽省級二等獎；獲得省級教學成果獎1項，校級教學成果獎3項。
第 1章數據庫基礎知識··············································································1
1.1 數據庫系統概述 ···········································································1
1.1.1數據處理 ·········································································1
1.1.2數據管理的發展································································2
1.1.3數據庫系統的組成·····························································3
1.1.4數據庫系統的特點·····························································6
1.2 數據模型 ···················································································7
1.2.1數據抽象的過程································································7
1.2.2概念模型 ·········································································8
1.2.3邏輯模型 ·········································································9
1.2.4外部模型 ······································································· 10
1.2.5內部模型 ······································································· 11
1.3 關系數據庫 ·············································································· 11
1.3.1關系模型 ······································································· 11
1.3.2關系運算 ······································································· 14
1.4 數據庫系統的體系結構 ································································ 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章數據庫和表的基本操作 ································································· 25
2.1 數據庫的基本操作 ······································································ 25
2.1.1創建數據庫···································································· 25
2.1.2打開與關閉數據庫··························································· 28
2.1.3數據庫加密···································································· 28
2.1.4數據庫備份···································································· 30
2.2 創建表 ···················································································· 31
2.2.1數據表的組成································································· 31
2.2.2創建數據表的常用方法····················································· 33
2.2.3設置字段屬性································································· 37
2.2.4建立表間關系································································· 44
2.2.5向表中輸入數據······························································ 46
2.3 表的編輯 ················································································· 55
2.3.1修改表的結構································································· 55
2.3.2編輯表的內容································································· 56
2.4 使用表 ···················································································· 58
2.4.1記錄排序 ······································································· 58
2.4.2數據篩選 ······································································· 59
2.4.3記錄匯總 ······································································· 60
2.4.4數據導出 ······································································· 60
本章小結 ························································································ 64
知識結構圖 ····················································································· 64
思考題 ··························································································· 64
第 3章數據查詢 ······················································································ 65
3.1 查詢概述 ················································································· 65
3.1.1查詢的功能···································································· 65
3.1.2查詢的視圖···································································· 66
3.1.3查詢的類型···································································· 66
3.1.4查詢條件 ······································································· 68
3.2 創建選擇查詢 ··········································································· 70
3.2.1使用查詢向導創建選擇查詢··············································· 70
3.2.2使用設計視圖創建選擇查詢··············································· 73
3.3 創建交叉表查詢 ········································································· 79
3.3.1使用查詢向導創建交叉表查詢············································ 80
3.3.2使用設計視圖創建交叉表查詢············································ 81
3.4 創建參數查詢 ··········································································· 82
3.5 創建操作查詢 ··········································································· 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數據定義 ······································································· 91
3.6.3數據操縱 ······································································· 93
3.6.4數據查詢 ······································································· 94
3.6.5聯合查詢 ······································································· 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 創建窗體 ················································································106
4.2.1使用工具自動創建窗體····················································106
4.2.2使用窗體向導創建窗體····················································108
4.2.3使用“空白窗體”工具創建窗體········································110
4.2.4創建數據透視表和數據透視圖窗體····································· 111
4.2.5設計視圖創建窗體·························································· 115
4.2.6創建主/子窗體 ······························································· 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條件格式使用及表格式窗體的快速實現·······························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 創建報表 ················································································155
5.2.1使用“報表”工具創建報表··············································155
5.2.2使用“報表向導”工具創建報表········································156
5.2.3使用“空報表”工具創建報表···········································158
5.2.4創建標簽報表································································159
5.2.5使用“報表設計”工具創建報表········································161
5.2.6創建主/子報表 ·······························································163
5.2.7利用“報表設計”按鈕創建圖表報表··································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 宏的創建及運行 ········································································182
6.2.1宏的設計窗口································································182
6.2.2創建獨立的宏································································183
6.2.3直接運行宏···································································184
6.2.4創建宏組 ······································································185
6.2.5創建條件宏···································································187
6.2.6創建事件宏···································································189
6.3 常用的宏操作 ··········································································191
6.4 使用宏創建菜單 ········································································191
本章小結 ·······················································································194
知識結構圖
····················································································194
思考題 ··························································································194
第 7章VBA編程 ····················································································195
7.1 面向對象程序設計 ·····································································195
7.2 VBA的模塊及編輯環境······························································196
7.2.1類模塊和標準模塊··························································197
7.2.2將宏轉換為模塊·····························································197
7.2.3VBA編輯環境 ·······························································198
7.2.4創建模塊與過程·····························································199
7.3 VBA編程基礎··········································································201
7.3.1數據類型 ······································································201
7.3.2常量、變量和數組··························································202
7.3.3函數 ············································································205
7.3.4運算符和表達式·····························································209
7.4 VBA程序控制·········································································· 211
7.4.1順序結構······································································ 211
7.4.2選擇結構 ······································································213
7.4.3循環結構 ······································································219
7.5 過程調用和參數傳遞 ··································································223
7.5.1創建事件過程································································223
7.5.2子過程的定義和調用·······················································225
7.5.3Function過程的定義和調用 ··············································226
7.5.4參數傳遞 ······································································226
7.6 VBA編程訪問數據庫 ·································································227
7.6.1數據庫引擎及其接口·······················································227
7.6.2數據訪問對象································································228
7.6.3ActiveX數據對象 ···························································229
本章小結 ·······················································································236
知識結構圖 ····················································································237
思考題 ··························································································237
第 8章數據庫設計與開發 ·······································································238
8.1 應用系統開發概述
·····································································238
8.2 數據庫設計 ·············································································239
8.2.1數據庫設計規劃·····························································239
8.2.2用戶需求分析與概念結構設計···········································240
8.2.3邏輯結構設計································································240
8.2.4物理結構設計································································242
8.2.5數據庫的實現、運行與系統維護········································242
本章小結 ·······················································································243
知識結構圖 ····················································································243
思考題 ··························································································244
附錄 A字段常用屬性···············································································245
附錄 B窗體常用屬性···············································································246
附錄 C控件常用屬性··············································································248
附錄 D常用事件·····················································································250
附錄 E常用的宏命令···············································································253
附錄 F常用函數······················································································255
參考文獻
···································································································258
新書資訊