- 电子工业出版社
- 9787121353369
- 1-1
- 284630
- 46218006-8
- 平塑
- 16开
- 2019年1月
- 435
- 272
- 计算机科学与技术
- TP311.138AC
- 大学计算机公共课程
- 研究生、本科
内容简介
Access 2010为软件支撑环境，以应用为目的，以案例为引导，融入计算思维，既考虑理论基础的系统性，又强调实践技术的应用，由浅入深、循序渐进地介绍关系数据库管理系统的基础理论及系统开发技术。全书分为 8章，内容上以“学生成绩管理系统”来组织材料。应用系统贯穿全书，围绕它编排了大量翔实的实例，实例新颖、系统，相互呼应。实例涵盖表、查询、窗体、报表、宏、模块六大数据库对象的创建和使用方法。每章附有知识结构图，方便读者归纳、总结。本书力求内容系统、结构严谨、实例丰富、语言通俗易懂，突出“利用数据库技术进行数据综合分析和展示分析结果”能力的培养。本书既可以作为高等院校“数据库技术及应用”课程的教材，也可作为全国计算机等级考试考生的培训辅导书，还可作为读者自学提高的参考书。
目录
第 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
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
