第1章數(shù)據(jù)庫(kù)基礎(chǔ)與Access2010..............................................................1

1.1數(shù)據(jù)庫(kù)系統(tǒng)的基本概念..............................................................................................1

1.1.1數(shù)據(jù)、數(shù)據(jù)庫(kù)、數(shù)據(jù)庫(kù)管理系統(tǒng)..................................................................1

1.1.2數(shù)據(jù)庫(kù)系統(tǒng)的發(fā)展..........................................................................................4

1.1.3數(shù)據(jù)庫(kù)系統(tǒng)的基本特點(diǎn)..................................................................................5

1.1.4數(shù)據(jù)庫(kù)系統(tǒng)的內(nèi)部體系結(jié)構(gòu)..........................................................................6

1.2數(shù)據(jù)模型......................................................................................................................8

1.2.1組成要素..........................................................................................................8

1.2.2概念模型..........................................................................................................8

1.2.3三種數(shù)據(jù)模型................................................................................................10

1.3關(guān)系數(shù)據(jù)庫(kù)................................................................................................................12

1.3.1關(guān)系模型........................................................................................................12

1.3.2關(guān)系代數(shù)運(yùn)算................................................................................................13

1.3.3關(guān)系的完整性................................................................................................16

1.3.4關(guān)系規(guī)范化....................................................................................................17

1.3.5數(shù)據(jù)庫(kù)的設(shè)計(jì)方法........................................................................................17

1.4初識(shí)Access2010.......................................................................................................18

1.4.1Access2010的啟動(dòng)和退出...........................................................................19

1.4.2Access2010的工作界面...............................................................................19

1.4.3Access2010的命令選項(xiàng)卡...........................................................................21

1.4.4Access2010的選項(xiàng)卡式文檔.......................................................................23

1.5Access2010中的對(duì)象...............................................................................................23

1.5.1表....................................................................................................................23

1.5.2查詢................................................................................................................24

1.5.3窗體................................................................................................................25

1.5.4報(bào)表................................................................................................................25

1.5.5宏....................................................................................................................26

1.5.6模塊................................................................................................................26

1.5.7對(duì)象間的關(guān)系................................................................................................26

1.6Access2010中的數(shù)據(jù)...............................................................................................27

1.6.1字段的數(shù)據(jù)類型............................................................................................27

1.6.2表達(dá)式............................................................................................................28

1.6.3函數(shù)................................................................................................................31

1.7Access2010的幫助系統(tǒng)...........................................................................................35

習(xí)題1.................................................................................................................................36

第2章創(chuàng)建與管理數(shù)據(jù)庫(kù)..........................................................................41

2.1創(chuàng)建數(shù)據(jù)庫(kù)................................................................................................................41

2.1.1設(shè)計(jì)示例教學(xué)管理數(shù)據(jù)庫(kù)............................................................41

2.1.2使用Access2010附帶的模板創(chuàng)建數(shù)據(jù)庫(kù)..................................................44

2.1.3使用Office.com中的模板創(chuàng)建數(shù)據(jù)庫(kù)........................................................45

2.1.4創(chuàng)建空數(shù)據(jù)庫(kù)................................................................................................45

2.2數(shù)據(jù)庫(kù)的打開與關(guān)閉................................................................................................45

2.2.1打開數(shù)據(jù)庫(kù)....................................................................................................45

2.2.2關(guān)閉數(shù)據(jù)庫(kù)....................................................................................................46

2.3管理數(shù)據(jù)庫(kù)................................................................................................................47

2.3.1設(shè)置默認(rèn)的數(shù)據(jù)庫(kù)格式和默認(rèn)文件夾........................................................47

2.3.2查看數(shù)據(jù)庫(kù)屬性............................................................................................47

2.3.3備份數(shù)據(jù)庫(kù)....................................................................................................48

2.3.4壓縮和修復(fù)數(shù)據(jù)庫(kù)........................................................................................49

2.3.5設(shè)置和撤銷數(shù)據(jù)庫(kù)密碼................................................................................50

習(xí)題2.................................................................................................................................51

第3章表...................................................................................................52

3.1表的基本知識(shí)............................................................................................................52

3.2創(chuàng)建數(shù)據(jù)表................................................................................................................53

3.2.1使用數(shù)據(jù)表視圖創(chuàng)建表........................................................................53

3.2.2使用設(shè)計(jì)視圖創(chuàng)建表............................................................................55

3.3設(shè)置字段屬性............................................................................................................58

3.3.1字段大小........................................................................................................58

3.3.2格式................................................................................................................58

3.3.3輸入掩碼........................................................................................................59

3.3.4默認(rèn)值............................................................................................................60

3.3.5標(biāo)題................................................................................................................61

3.3.6有效性規(guī)則和有效性文本............................................................................61

3.3.7表的索引........................................................................................................62

3.4編輯與維護(hù)數(shù)據(jù)表....................................................................................................64

3.4.1打開和關(guān)閉表................................................................................................64

3.4.2修改表結(jié)構(gòu)....................................................................................................64

3.4.3向表中輸入數(shù)據(jù)............................................................................................65

3.4.4編輯表內(nèi)容....................................................................................................66

3.4.5表的導(dǎo)入和鏈接............................................................................................68

3.4.6表的導(dǎo)出........................................................................................................69

3.5調(diào)整表外觀................................................................................................................70

3.5.1調(diào)整表的行高和列寬....................................................................................70

3.5.2調(diào)整字段顯示次序........................................................................................71

3.5.3隱藏和顯示字段............................................................................................71

3.5.4凍結(jié)字段/解除對(duì)所有字段的凍結(jié).............................................................72

3.5.5設(shè)置數(shù)據(jù)表格式............................................................................................72

3.5.6改變字體........................................................................................................72

3.6操作表........................................................................................................................73

3.6.1查找數(shù)據(jù)........................................................................................................73

3.6.2替換數(shù)據(jù)........................................................................................................74

3.6.3排序記錄........................................................................................................75

3.6.4篩選記錄........................................................................................................76

3.7建立表間關(guān)系............................................................................................................78

3.7.1表間關(guān)系的分類............................................................................................78

3.7.2建立表間關(guān)系................................................................................................78

3.7.3表關(guān)系的修改................................................................................................80

習(xí)題3.................................................................................................................................81

第4章查詢................................................................................................86

4.1查詢概述....................................................................................................................86

4.1.1查詢的功能....................................................................................................86

4.1.2查詢的類型....................................................................................................87

4.2創(chuàng)建選擇查詢............................................................................................................88

4.2.1使用查詢向?qū)��?chuàng)建查詢........................................................................88

4.2.2使用設(shè)計(jì)視圖創(chuàng)建查詢........................................................................89

4.2.3運(yùn)行查詢........................................................................................................92

4.2.4編輯查詢中的字段........................................................................................92

4.2.5排序查詢結(jié)果................................................................................................92

4.2.6查詢的條件....................................................................................................92

4.2.7在查詢中進(jìn)行計(jì)算........................................................................................95

4.2.8多表查詢中聯(lián)接屬性的設(shè)置........................................................................99

4.3創(chuàng)建參數(shù)查詢..........................................................................................................102

4.3.1單參數(shù)查詢..................................................................................................102

4.3.2多參數(shù)查詢..................................................................................................102

4.4創(chuàng)建交叉表查詢......................................................................................................103

4.4.1認(rèn)識(shí)交叉表查詢..........................................................................................103

4.4.2創(chuàng)建交叉表查詢..........................................................................................104

4.5創(chuàng)建操作查詢..........................................................................................................106

4.5.1生成表查詢..................................................................................................107

4.5.2更新查詢......................................................................................................108

4.5.3刪除查詢......................................................................................................109

4.5.4追加查詢......................................................................................................111

4.6結(jié)構(gòu)化查詢語(yǔ)言（SQL）......................................................................................112

4.6.1SQL概述......................................................................................................112

4.6.2SQL語(yǔ)句......................................................................................................113

4.6.3創(chuàng)建SQL特定查詢.....................................................................................116

習(xí)題4...............................................................................................................................118

第5章窗體..............................................................................................123

5.1窗體概述..................................................................................................................123

5.1.1窗體的功能..................................................................................................123

5.1.2窗體的結(jié)構(gòu)..................................................................................................124

5.1.3窗體的視圖..................................................................................................124

5.2創(chuàng)建窗體..................................................................................................................125

5.2.1使用窗體創(chuàng)建窗體..............................................................................125

5.2.2使用分割窗體創(chuàng)建分割窗體..............................................................126

5.2.3使用多個(gè)項(xiàng)目創(chuàng)建顯示多個(gè)記錄的窗體..........................................127

5.2.4使用窗體向?qū)��?chuàng)建窗體......................................................................128

5.2.5使用空白窗體創(chuàng)建窗體......................................................................129

5.2.6使用窗體設(shè)計(jì)創(chuàng)建窗體......................................................................130

5.2.7使用數(shù)據(jù)透視圖創(chuàng)建窗體..................................................................131

5.3窗體的設(shè)計(jì)..............................................................................................................132

5.3.1窗體的屬性..................................................................................................132

5.3.2控件的概念..................................................................................................133

5.3.3控件的種類..................................................................................................134

5.3.4常用控件的使用..........................................................................................134

5.4修飾窗體..................................................................................................................141

5.4.1使用主題功能..............................................................................................141

5.4.2條件格式的使用..........................................................................................141

5.4.3添加背景圖像..............................................................................................142

5.5定制系統(tǒng)控制窗體..................................................................................................142

5.5.1創(chuàng)建導(dǎo)航窗體..............................................................................................142

5.5.2設(shè)置啟動(dòng)窗體..............................................................................................144

習(xí)題5...............................................................................................................................144

第6章報(bào)表..............................................................................................147

6.1報(bào)表概述..................................................................................................................147

6.1.1報(bào)表的功能..................................................................................................147

6.1.2報(bào)表的結(jié)構(gòu)..................................................................................................148

6.1.3報(bào)表的視圖..................................................................................................148

6.2創(chuàng)建報(bào)表..................................................................................................................148

6.2.1使用報(bào)表創(chuàng)建報(bào)表..............................................................................148

6.2.2使用報(bào)表向?qū)��?chuàng)建報(bào)表......................................................................149

6.2.3使用空?qǐng)?bào)表創(chuàng)建報(bào)表..........................................................................151

6.2.4使用設(shè)計(jì)視圖創(chuàng)建報(bào)表......................................................................153

6.2.5使用標(biāo)簽向?qū)��?chuàng)建報(bào)表......................................................................154

6.2.6編輯報(bào)表......................................................................................................157

6.3報(bào)表排序和分組統(tǒng)計(jì)..............................................................................................160

6.3.1記錄排序......................................................................................................160

6.3.2記錄分組......................................................................................................161

6.3.3報(bào)表常用函數(shù)..............................................................................................163

6.3.4分組統(tǒng)計(jì)......................................................................................................163

6.4打印報(bào)表..................................................................................................................164

6.4.1頁(yè)面設(shè)置......................................................................................................164

6.4.2打印..............................................................................................................165

習(xí)題6...............................................................................................................................166

第7章宏.................................................................................................168

7.1宏的概述..................................................................................................................168

7.1.1宏的功能......................................................................................................168

7.1.2宏的種類......................................................................................................168

7.1.3宏的設(shè)計(jì)器..................................................................................................169

7.1.4宏操作..........................................................................................................170

7.2宏的創(chuàng)建和設(shè)計(jì)......................................................................................................172

7.2.1創(chuàng)建獨(dú)立的宏..............................................................................................172

7.2.2創(chuàng)建嵌入的宏..............................................................................................174

7.2.3創(chuàng)建條件操作宏..........................................................................................175

7.2.4創(chuàng)建宏組......................................................................................................178

7.3宏的運(yùn)行、調(diào)試與修改..........................................................................................179

7.3.1宏的運(yùn)行......................................................................................................179

7.3.2宏的調(diào)試......................................................................................................181

7.3.3宏的修改......................................................................................................182

習(xí)題7...............................................................................................................................182

第8章模塊與VBA編程..........................................................................184

8.1VBA的編程環(huán)境....................................................................................................184

8.1.1打開VBE窗口............................................................................................184

8.1.2VBE窗口簡(jiǎn)介.............................................................................................185

8.2VBA模塊簡(jiǎn)介........................................................................................................187

8.2.1模塊的類型..................................................................................................187

8.2.2VBA代碼編寫模塊的過(guò)程.........................................................................188

8.2.3將宏轉(zhuǎn)換為模塊的過(guò)程..............................................................................188

8.2.4在模塊中執(zhí)行宏..........................................................................................188

8.3VBA程序設(shè)計(jì)基礎(chǔ)................................................................................................189

8.3.1程序書寫原則..............................................................................................189

8.3.2數(shù)據(jù)類型......................................................................................................190

8.3.3變量與常量..................................................................................................191

8.3.4常用的標(biāo)準(zhǔn)函數(shù)..........................................................................................195

8.3.5運(yùn)算符和表達(dá)式..........................................................................................195

8.4VBA程序流程控制語(yǔ)句........................................................................................195

8.4.1賦值語(yǔ)句......................................................................................................196

8.4.2選擇結(jié)構(gòu)語(yǔ)句..............................................................................................196

8.4.3循環(huán)結(jié)構(gòu)語(yǔ)句..............................................................................................200

8.4.4其他語(yǔ)句標(biāo)號(hào)和GoTo語(yǔ)句...............................................................204

8.5面向?qū)ο蟪绦蛟O(shè)計(jì)的基本概念..............................................................................204

8.5.1對(duì)象..............................................................................................................204

8.5.2屬性..............................................................................................................205

8.5.3方法..............................................................................................................205

8.5.4事件..............................................................................................................206

8.6VBA模塊的創(chuàng)建....................................................................................................207

8.6.1VBA標(biāo)準(zhǔn)模塊.............................................................................................207

8.6.2Sub子過(guò)程的創(chuàng)建和調(diào)用...........................................................................208

8.6.3Function函數(shù)過(guò)程的創(chuàng)建和調(diào)用...............................................................210

8.6.4過(guò)程調(diào)用中的參數(shù)傳遞..............................................................................211

8.7VBA常用操作........................................................................................................212

8.7.1打開和關(guān)閉操作..........................................................................................212

8.7.2輸入框函數(shù)..................................................................................................214

8.7.3消息框..........................................................................................................215

8.7.4VBA編程驗(yàn)證數(shù)據(jù).....................................................................................218

8.7.5計(jì)時(shí)事件Timer............................................................................................219

8.8VBA的數(shù)據(jù)庫(kù)編程技術(shù)........................................................................................219

8.8.1數(shù)據(jù)庫(kù)引擎及其接口..................................................................................220

8.8.2VBA訪問(wèn)的數(shù)據(jù)庫(kù)類型.............................................................................220

8.8.3數(shù)據(jù)訪問(wèn)對(duì)象..............................................................................................220

8.8.4ActiveX數(shù)據(jù)對(duì)象........................................................................................222

8.9VBA程序調(diào)試........................................................................................................224

8.9.1錯(cuò)誤類型......................................................................................................224

8.9.2調(diào)試錯(cuò)誤......................................................................................................225

8.10錯(cuò)誤處理................................................................................................................226

8.10.1設(shè)置錯(cuò)誤陷阱............................................................................................226

8.10.2編寫錯(cuò)誤處理代碼....................................................................................226

習(xí)題8.................................................................................................227

附錄A全國(guó)計(jì)算機(jī)等級(jí)考試二級(jí)Access數(shù)據(jù)庫(kù)程序設(shè)計(jì)考試大綱（2016年版）................................234

附錄B習(xí)題參考答案................................................................................238

參考文獻(xiàn).....................................................................................................240