理 論 部 分
第1 章 Access 基礎(chǔ).............................. 1
1.1 數(shù)據(jù)庫(kù)基礎(chǔ)知識(shí)...............................1
1.1.1 計(jì)算機(jī)數(shù)據(jù)管理的發(fā)展.......1
1.1.2 數(shù)據(jù)庫(kù)系統(tǒng)...........................2
1.1.3 數(shù)據(jù)模型..............................4
1.2 關(guān)系數(shù)據(jù)庫(kù)......................................5
1.2.1 關(guān)系數(shù)據(jù)庫(kù)模型...................5
1.2.2 關(guān)系運(yùn)算..............................7
1.3 啟動(dòng)和退出Access...........................8
1.4 Access 簡(jiǎn)介......................................8
1.4.1 Access 發(fā)展概述...................8
1.4.2 Access 的系統(tǒng)結(jié)構(gòu)...............9
1.4.3 Access 的用戶(hù)界面.............10
小結(jié)........................................................11
習(xí)題........................................................11
第2 章 數(shù)據(jù)庫(kù).................................... 14
2.1 設(shè)計(jì)數(shù)據(jù)庫(kù)....................................14
2.1.1 設(shè)計(jì)原則............................14
2.1.2 設(shè)計(jì)步驟............................14
2.2 創(chuàng)建數(shù)據(jù)庫(kù)....................................16
2.2.1 建立一個(gè)空數(shù)據(jù)庫(kù).............17
2.2.2 利用向?qū)��?chuàng)建數(shù)據(jù)庫(kù).........17
2.3 數(shù)據(jù)庫(kù)的基本操作.........................18
2.3.1 數(shù)據(jù)庫(kù)的打開(kāi).....................18
2.3.2 數(shù)據(jù)庫(kù)的關(guān)閉.....................19
2.3.3 數(shù)據(jù)庫(kù)的備份.....................19
2.3.4 數(shù)據(jù)庫(kù)的壓縮和修復(fù).........19
小結(jié)........................................................20
習(xí)題........................................................20
第3 章 表........................................... 21
3.1 Access 數(shù)據(jù)類(lèi)型.............................21
3.1.1 基本概念............................21
3.1.2 數(shù)據(jù)類(lèi)型............................22
3.2 創(chuàng)建表........................................... 25
3.2.1 建立表結(jié)構(gòu)........................ 25
3.2.2 向表中輸入數(shù)據(jù)................ 26
3.2.3 設(shè)置字段屬性.................... 27
3.2.4 建立表之間的關(guān)系............ 32
3.3 維護(hù)表........................................... 34
3.3.1 打開(kāi)和關(guān)閉表.................... 34
3.3.2 修改表的結(jié)構(gòu).................... 34
3.3.3 編輯表的內(nèi)容.................... 35
3.3.4 調(diào)整表的外觀.................... 36
3.4 操作表........................................... 39
3.4.1 查找數(shù)據(jù)............................ 40
3.4.2 替換數(shù)據(jù)............................ 40
3.4.3 排序記錄............................ 41
3.4.4 篩選記錄............................ 42
3.5 導(dǎo)入/導(dǎo)出表.................................. 44
3.5.1 數(shù)據(jù)的導(dǎo)入........................ 44
3.5.2 數(shù)據(jù)的導(dǎo)出........................ 45
小結(jié)....................................................... 45
習(xí)題....................................................... 45
第4 章 查詢(xún)........................................ 48
4.1 認(rèn)識(shí)查詢(xún)....................................... 48
4.1.1 關(guān)系運(yùn)算概述.................... 48
4.1.2 查詢(xún)的功能........................ 50
4.1.3 查詢(xún)的類(lèi)型........................ 50
4.1.4 查詢(xún)的條件........................ 51
4.2 創(chuàng)建選擇查詢(xún)................................ 54
4.2.1 簡(jiǎn)單查詢(xún)向?qū)?................... 54
4.2.2 在設(shè)計(jì)視圖中創(chuàng)建條件
查詢(xún)................................... 55
4.2.3 在設(shè)計(jì)視圖中創(chuàng)建總計(jì)
查詢(xún)................................... 59
4.3 創(chuàng)建參數(shù)查詢(xún)................................ 61
·2 ·
Access 數(shù)據(jù)庫(kù)程序設(shè)計(jì)（第五版）
4.3.1 單參數(shù)查詢(xún).........................61
4.3.2 多參數(shù)查詢(xún).........................63
4.4 創(chuàng)建交叉表查詢(xún).............................64
4.4.1 認(rèn)識(shí)交叉表查詢(xún).................65
4.4.2 創(chuàng)建交叉表查詢(xún).................65
4.5 創(chuàng)建操作查詢(xún).................................67
4.5.1 生成表查詢(xún).........................67
4.5.2 追加查詢(xún)............................68
4.5.3 更新查詢(xún)............................69
4.5.4 刪除查詢(xún)............................70
4.6 SQL 查詢(xún)........................................71
4.6.1 使用SQL 修改查詢(xún)中的
條件....................................71
4.6.2 SQL 基礎(chǔ)知識(shí).....................72
4.6.3 SQL 數(shù)據(jù)定義語(yǔ)句.............72
4.6.4 SQL 數(shù)據(jù)操作語(yǔ)句.............74
4.6.5 SQL 數(shù)據(jù)查詢(xún).................... 75
小結(jié)........................................................79
習(xí)題........................................................79
第5 章 窗體........................................ 83
5.1 窗體基礎(chǔ)知識(shí).................................83
5.1.1 窗體的概念.........................83
5.1.2 窗體的視圖.........................83
5.1.3 窗體的組成.........................84
5.1.4 窗體的類(lèi)型.........................84
5.2 創(chuàng)建窗體........................................86
5.2.1 自動(dòng)創(chuàng)建窗體.....................86
5.2.2 使用“窗體向?qū)?rdquo;.............87
5.2.3 創(chuàng)建“數(shù)據(jù)透視表”
窗體....................................89
5.2.4 創(chuàng)建“數(shù)據(jù)透視圖”
窗體....................................90
5.3 自定義窗體....................................91
5.3.1 窗體設(shè)計(jì)工具選項(xiàng)卡.........91
5.3.2 控件組................................91
5.3.3 窗體中的控件.....................92
5.3.4 控件的用法.........................94
5.3.5 窗體和控件的屬性...........101
5.3.6 窗體和控件的事件...........104
5.4 美化窗體......................................105
5.4.1 應(yīng)用主題...........................105
5.4.2 添加當(dāng)前日期和時(shí)間.......106
5.4.3 對(duì)齊窗體中的控件...........106
小結(jié)......................................................106
習(xí)題......................................................106
第6 章 報(bào)表...................................... 109
6.1 報(bào)表基礎(chǔ)知識(shí)...............................109
6.1.1 報(bào)表的定義和功能...........109
6.1.2 報(bào)表的視圖.......................109
6.1.3 報(bào)表的組成.......................110
6.1.4 報(bào)表的分類(lèi).......................111
6.2 報(bào)表的自動(dòng)創(chuàng)建和向?qū)��?chuàng)建........112
6.2.1 利用“報(bào)表”自動(dòng)創(chuàng)建
報(bào)表..................................112
6.2.2 利用“報(bào)表向?qū)?rdquo;創(chuàng)建
報(bào)表..................................113
6.2.3 利用“標(biāo)簽向?qū)?rdquo;創(chuàng)建
報(bào)表..................................114
6.3 報(bào)表設(shè)計(jì)視圖的使用...................115
6.3.1 報(bào)表的設(shè)計(jì)視圖...............115
6.3.2 報(bào)表的格式設(shè)定...............116
6.3.3 報(bào)表中的控件使用...........117
6.3.4 創(chuàng)建基于參數(shù)查詢(xún)的
報(bào)表..................................119
6.3.5 創(chuàng)建子報(bào)表.......................120
6.3.6 報(bào)表的排序和分組...........122
6.4 預(yù)覽和打印報(bào)表...........................123
6.4.1 打印預(yù)覽...........................123
6.4.2 打印報(bào)表...........................124
小結(jié)......................................................124
習(xí)題......................................................124
第7 章 宏......................................... 126
7.1 宏的概念......................................126
7.1.1 宏的基本概念...................126
7.1.2 宏與Visual Basic ..............127
·3·
目 錄
7.1.3 宏向Visual Basic 程序代碼
轉(zhuǎn)換..................................127
7.2 宏的操作......................................127
7.2.1 宏的分類(lèi)..........................127
7.2.2 創(chuàng)建宏..............................128
7.2.2 宏的運(yùn)行..........................133
7.2.3 宏的調(diào)試..........................134
7.2.4 常用宏操作.......................134
小結(jié)......................................................136
習(xí)題......................................................136
第8 章 VBA 編程和數(shù)據(jù)庫(kù)編程......... 138
8.1 模塊的基本概念...........................138
8.1.1 模塊的類(lèi)型.......................138
8.1.2 模塊的組成.......................139
8.1.3 面向?qū)ο蟪绦蛟O(shè)計(jì)的
基本概念..........................139
8.2 VBA 開(kāi)發(fā)環(huán)境..............................142
8.2.1 進(jìn)入VBE 編程環(huán)境..........142
8.2.2 VBE 窗口..........................142
8.2.3 編寫(xiě)VBA 代碼.................144
8.3 常量、變量、運(yùn)算符和表達(dá)式....145
8.3.1 數(shù)據(jù)類(lèi)型和數(shù)據(jù)庫(kù)對(duì)象...145
8.3.2 常量與變量.......................147
8.3.3 數(shù)組..................................150
8.3.4 運(yùn)算符與表達(dá)式...............151
8.4 常用標(biāo)準(zhǔn)函數(shù)...............................155
8.4.1 數(shù)學(xué)函數(shù)..........................155
8.4.2 字符串函數(shù).......................156
8.4.3 日期/時(shí)間函數(shù)..................156
8.4.4 類(lèi)型轉(zhuǎn)換函數(shù)...................157
8.5 語(yǔ)句和控制結(jié)構(gòu)...........................158
8.5.1 語(yǔ)句概述...........................158
8.5.2 數(shù)據(jù)的輸入輸出...............159
8.5.3 順序結(jié)構(gòu)...........................162
8.5.4 條件結(jié)構(gòu)...........................163
8.5.5 循環(huán)結(jié)構(gòu)...........................168
8.5.6 GoTo 控制語(yǔ)句..................173
8.6 常用對(duì)象的屬性、方法和事件....174
8.6.1 標(biāo)簽、文本框與命令
按鈕..................................174
8.6.2 選項(xiàng)組..............................177
8.6.3 列表框和組合框...............180
8.6.4 窗體計(jì)時(shí)事件Timer .........182
8.6.5 窗體與報(bào)表的常用方法....183
8.6.6 VBA 編程驗(yàn)證數(shù)據(jù)...........185
8.7 過(guò)程的定義與調(diào)用.......................185
8.7.1 過(guò)程定義和調(diào)用...............186
8.7.2 參數(shù)傳遞...........................187
8.8 VBA 程序的錯(cuò)誤處理和調(diào)試.......189
8.8.1 錯(cuò)誤處理...........................189
8.8.2 調(diào)試..................................189
8.9 VBA 數(shù)據(jù)庫(kù)編程..........................192
8.9.1 數(shù)據(jù)庫(kù)引擎及其接口.......192
8.9.2 VBA 訪問(wèn)的數(shù)據(jù)庫(kù)類(lèi)型....193
8.9.3 數(shù)據(jù)庫(kù)訪問(wèn)對(duì)象...............193
8.9.4 ActiveX 數(shù)據(jù)對(duì)象.............195
8.9.5 VBA 數(shù)據(jù)庫(kù)編程技術(shù).......202
小結(jié)......................................................206
習(xí)題......................................................206
實(shí) 訓(xùn) 部 分
實(shí)訓(xùn)1 創(chuàng)建數(shù)據(jù)庫(kù)............................ 211
1.1 實(shí)訓(xùn)目的......................................211
1.2 實(shí)訓(xùn)內(nèi)容......................................211
1.2.1 啟動(dòng)數(shù)據(jù)庫(kù)并使用幫助
系統(tǒng)...................................211
1.2.2 創(chuàng)建數(shù)據(jù)庫(kù).......................212
1.2.3 數(shù)據(jù)庫(kù)的基本操作...........214
思考及課后練習(xí)...................................215
實(shí)訓(xùn)2 表Ⅰ——建立表結(jié)構(gòu)和輸入數(shù)據(jù)... 216
2.1 實(shí)訓(xùn)目的......................................216
2.2 實(shí)訓(xùn)內(nèi)容......................................216
2.2.1 建立表結(jié)構(gòu).......................216
·4 ·
Access 數(shù)據(jù)庫(kù)程序設(shè)計(jì)（第五版）
2.2.2 向表中輸入數(shù)據(jù)...............217
2.2.3 設(shè)置字段屬性...................219
2.2.4 建立表之間的關(guān)系...........220
思考及課后練習(xí)...................................221
實(shí)訓(xùn)3 表Ⅱ——維護(hù)、操作、
導(dǎo)入/導(dǎo)出表................................. 222
3.1 實(shí)訓(xùn)目的......................................222
3.2 實(shí)訓(xùn)內(nèi)容......................................222
3.2.1 打開(kāi)和關(guān)閉表...................222
3.2.2 修改表的結(jié)構(gòu)...................222
3.2.3 編輯表的內(nèi)容...................223
3.2.4 調(diào)整表的外觀...................224
3.2.5 查找數(shù)據(jù)..........................225
3.2.6 替換數(shù)據(jù)..........................225
3.2.7 排序記錄..........................226
3.2.8 篩選記錄..........................226
3.2.9 導(dǎo)入/導(dǎo)出表......................228
思考及課后練習(xí)...................................228
實(shí)訓(xùn)4 查詢(xún)Ⅰ——選擇查詢(xún)和參數(shù)查詢(xún)... 229
4.1 實(shí)訓(xùn)目的......................................229
4.2 實(shí)訓(xùn)內(nèi)容......................................229
4.2.1 使用向?qū)��?chuàng)建選擇查詢(xún)...229
4.2.2 使用設(shè)計(jì)視圖創(chuàng)建選擇
查詢(xún)...................................230
4.2.3 在設(shè)計(jì)視圖中創(chuàng)建總計(jì)
查詢(xún)...................................231
4.2.4 創(chuàng)建單參數(shù)查詢(xún)...............232
4.2.5 創(chuàng)建多參數(shù)查詢(xún)...............232
思考及課后練習(xí)...................................233
實(shí)訓(xùn)5 查詢(xún)Ⅱ——交叉表查詢(xún)和操作
查詢(xún)............................................. 234
5.1 實(shí)訓(xùn)目的......................................234
5.2 實(shí)訓(xùn)內(nèi)容......................................234
5.2.1 創(chuàng)建交叉表查詢(xún)...............234
5.2.2 創(chuàng)建操作查詢(xún)...................235
思考及課后練習(xí)...................................238
實(shí)訓(xùn)6 查詢(xún)Ⅲ——SQL查詢(xún)................... 239
6.1 實(shí)訓(xùn)目的......................................239
6.2 實(shí)訓(xùn)內(nèi)容......................................239
6.2.1 數(shù)據(jù)定義語(yǔ)句...................239
6.2.2 數(shù)據(jù)查詢(xún)語(yǔ)句...................240
6.2.3 創(chuàng)建聯(lián)合查詢(xún)和子查詢(xún)....241
思考及課后練習(xí)...................................243
實(shí)訓(xùn)7 窗體Ⅰ——創(chuàng)建窗體.................... 244
7.1 實(shí)訓(xùn)目的......................................244
7.2 實(shí)訓(xùn)內(nèi)容......................................244
7.2.1 利用“窗體”自動(dòng)創(chuàng)建
窗體..................................244
7.2.2 利用向?qū)��?chuàng)建窗體...........245
7.2.3 利用“其他窗體”創(chuàng)建數(shù)據(jù)
透視圖窗體.......................246
思考及課后練習(xí)...................................247
實(shí)訓(xùn)8 窗體Ⅱ——自定義窗體、美化
窗體............................................... 248
8.1 實(shí)訓(xùn)目的......................................248
8.2 實(shí)訓(xùn)內(nèi)容......................................248
8.2.1 控件的使用.......................248
8.2.2 控件的布局調(diào)整...............252
思考及課后練習(xí)...................................253
實(shí)訓(xùn)9 報(bào)表............................................... 254
9.1 實(shí)訓(xùn)目的......................................254
9.2 實(shí)訓(xùn)內(nèi)容......................................254
9.2.1 利用向?qū)��?chuàng)建報(bào)表...........254
9.2.2 創(chuàng)建圖表報(bào)表...................255
9.2.3 創(chuàng)建主/子報(bào)表..................256
思考及課后練習(xí)...................................258
實(shí)訓(xùn)10 宏................................................. 259
10.1 實(shí)訓(xùn)目的....................................259
10.2 實(shí)訓(xùn)內(nèi)容....................................259
10.2.1 創(chuàng)建和運(yùn)行宏.................259
10.2.2 為命令按鈕創(chuàng)建宏.........261
思考及課后練習(xí)...................................262
實(shí)訓(xùn)11 模塊Ⅰ——條件結(jié)構(gòu).................... 263
11.1 實(shí)訓(xùn)目的....................................263
11.2 實(shí)訓(xùn)內(nèi)容....................................263
·5·
目 錄
11.2.1 If 語(yǔ)句及IIf()函數(shù)的
使用................................263
11.2.2 Switch()函數(shù)及Select 語(yǔ)句
的使用............................265
思考及課后練習(xí)...................................266
實(shí)訓(xùn)12 模塊Ⅱ——循環(huán)結(jié)構(gòu).................... 267
12.1 實(shí)訓(xùn)目的....................................267
12.2 實(shí)訓(xùn)內(nèi)容....................................267
12.2.1 循環(huán)結(jié)構(gòu)實(shí)訓(xùn).................267
12.2.2 過(guò)程的創(chuàng)建與調(diào)用.........269
思考及課后練習(xí)...................................270
實(shí)訓(xùn)13 模塊Ⅲ——對(duì)象操作.................... 271
13.1 實(shí)訓(xùn)目的....................................271
13.2 實(shí)訓(xùn)內(nèi)容....................................271
13.2.1 使用和修改對(duì)象屬性.....271
13.2.2 DoCmd 對(duì)象的使用.........272
13.2.3 設(shè)計(jì)計(jì)時(shí)器.....................273
思考及課后練習(xí)...................................274
項(xiàng)目實(shí)戰(zhàn)部分
教學(xué)管理系統(tǒng)設(shè)計(jì)與開(kāi)發(fā)..................... 276
1.1 項(xiàng)目實(shí)戰(zhàn)目的...............................276
1.2 需求描述......................................276
1.3 開(kāi)發(fā)環(huán)境......................................276
1.4 案例覆蓋的知識(shí)點(diǎn).......................277
1.5 案例分析......................................277
1.6 推薦實(shí)現(xiàn)步驟...............................278
1.6.1 教學(xué)管理系統(tǒng)的系統(tǒng)
設(shè)計(jì)...................................278
1.6.2 數(shù)據(jù)庫(kù)設(shè)計(jì).......................280
1.6.3 系統(tǒng)的詳細(xì)設(shè)計(jì)...............282
練習(xí)及課后作業(yè)...................................290
附錄 全國(guó)計(jì)算機(jī)等級(jí)考試簡(jiǎn)介................................................................................... 291
參考文獻(xiàn)...................................................................................................................... 294