- 电子工业出版社
- 9787121353369
- 1-1
- 284630
- 46218006-8
- 平塑
- 16开
- 2019-01
- 435
- 272
- 工学
- 计算机科学与技术
- TP311.138AC
- 大学计算机公共课程
- 本科 研究生（硕士、EMBA、MBA、MPA、博士）
内容简介
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章数据查询 ·····
