Access Database Application Tutorial

Name: Access Database Application Tutorial
ISBN: 9787115478108

Li Jun / 张立涛 / 陈刚 / 梁静毅 / 苏晓勤Posts & Telecom Press · ChinaAug 2021

Rating 3.1

Word count: 146K words
Chapters: 211
ISBN: 9787115478108

Summary

This book covers the fundamentals of databases, an overview of Access, basic Access operations, table structure design, query design, form design, report design, macro design, and module and VBA programming. Theory is closely integrated with hands-on practice throughout, with a "Student Grade Management" project running through the entire book, enabling readers to experience and master the full process of building a database application system with Access.

Editor's review

Access Database Application Tutorial is a practical introductory textbook for database beginners. Drawing on his extensive experience in database teaching, author Li Jun turns complex database concepts into easy-to-understand knowledge modules. Using Access, the classic desktop database management system, the book systematically explains the complete knowledge chain from basic database theory, table design, and query creation to form and report development and macro and VBA programming. Its core value lies in its "theory combined with practice" approach: every concept is paired with realistic cases and step-by-step operations, so readers can learn and apply immediately. For office staff, students, and managers who need to handle daily data, perform simple data analysis, or understand the core ideas of databases, this book offers a smooth learning curve. It does not pursue technical depth or cutting-edge topics; instead, it focuses on building solid foundations and developing practical problem-solving skills—a pragmatic positioning that makes it especially reliable and efficient among comparable tutorials.

Who it's for

A good fit for

College students who need to systematically learn basic database concepts and operations
Administrative, secretarial, or management staff who handle and analyze large amounts of data in daily office work
Workplace newcomers who want to master a practical skill to improve efficiency
Hobbyists interested in data management who want to build a personal knowledge system from scratch

Not a good fit for

Professional programmers seeking advanced database development techniques or deep knowledge of database internals
Readers who want to learn large enterprise database management systems such as SQL Server or Oracle

Reading tips

Follow the chapters in order; do not skip the early theoretical foundations.
Be sure to install Access on your computer and follow the book's cases hands-on—practice is key to mastering database skills.
When studying the query and VBA sections, try modifying the book's cases slightly and applying them to simple scenarios you envision or encounter at work, to deepen your understanding.

About the publisher

Posts & Telecom Press China · Founded in 1953

Posts & Telecom Press is known for its strengths in science and technology, computing, and information and communications titles, and has extended its publishing into photography, art, software learning, and inspirational growth, giving it a fairly diverse range. Its catalog includes computing and communications works such as Refactoring and Patterns (Revised Edition) and Huawei Switch Learning Guide (Second Edition), alongside bilingual collector's editions such as The Little Prince (Chinese-English-French illustrated collector's edition), The Great Gatsby, and Three Days to See. Beijing Ten Years: 1980-1990 and Ghost Blade: WLOP Personal Illustration Collection reflect its presence in photography and art. Its authors include Antoine de Saint-Exupéry, Helen Keller, Joshua Kerievsky, Wang Da, Zhang Zhaozeng, and WLOP.

版权信息
内容提要
前言
第1章数据库系统概述
1.1 数据库系统基础知识
1.1.1 信息、数据和数据处理
1.1.2 数据库技术的产生与发展
1.1.3 数据库系统的组成
1.1.4 数据库系统的三级模式结构
1.2 数据模型
1.2.1 基本概念
1.2.2 组成要素
1.2.3 概念模型与E-R图
1.2.4 逻辑数据模型
1.3 关系型数据库
1.3.1 关系型数据库概念
1.3.2 关系的完整性
1.3.3 关系的运算与关系操作
1.4 思考与练习
第2章 Access 2010基础
2.1 Microsoft Access关系型数据库管理系统简介
2.1.1 Access的发展简介
2.1.2 Access的特点
2.1.3 Access的功能
2.1.4 Access 2010的启动和退出
2.1.5 数据库的组成对象
2.2 Access 2010数据库的创建
2.2.1 使用模板创建数据库
2.2.2 创建空数据库
2.3 打开和关闭数据库
2.3.1 打开Access 2010数据库
2.3.2 关闭Access 2010数据库
2.4 管理数据库
2.4.1 压缩和修复数据库
2.4.2 备份与还原数据库
2.4.3 加密数据库
2.4.4 生成ACCDE文件
2.5 数据库的导入与导出
2.5.1 数据库的导入
2.5.2 数据库的导出
2.6 思考与练习
第3章表
3.1 数据表
3.1.1 二维表与数据表
3.1.2 Access 2010表的操作界面
3.2 表结构设计概述
3.2.1 字段名称
3.2.2 字段的数据类型
3.2.3 字段属性
3.2.4 设置表的主键
3.2.5 字段说明
3.2.6 “学生管理”数据库的表结构设计示例
3.3 创建表
3.3.1 创建表的几种方式
3.3.2 数据表视图及表的创建
3.3.3 设计视图及表结构的设置
3.4 表记录的基本操作
3.4.1 各种类型数据的输入
3.4.2 选定记录字段
3.4.3 记录的编辑
3.4.4 表中记录排序
3.4.5 表中记录筛选
3.4.6 查找与替换
3.4.7 表的复制、删除及重命名
3.5 设置表之间的关系
3.5.1 关系的建立
3.5.2 关系的编辑
3.6 表的导入和导出
3.6.1 导入表
3.6.2 导出表
3.7 思考与练习
第4章查询与SQL
4.1 查询概述
4.1.1 查询类型
4.1.2 创建查询的方法
4.2 查询条件的设置
4.3 选择查询
4.3.1 使用向导创建
4.3.2 使用设计视图创建
4.3.3 运行和修改查询
4.3.4 设置查询中的计算
4.4 参数查询
4.4.1 在设计视图中创建单参数查询
4.4.2 在设计视图中创建多参数查询
4.5 交叉表查询
4.5.1 使用向导创建
4.5.2 使用设计视图创建
4.6 操作查询
4.6.1 生成表查询
4.6.2 更新查询
4.6.3 追加查询
4.6.4 删除查询
4.7 SQL查询
4.7.1 SQL简介
4.7.2 数据查询语句
4.7.3 单表查询
4.7.4 多表查询
4.7.5 嵌套查询
4.7.6 联合查询
4.8 其他SQL语句
4.8.1 数据定义语句
4.8.2 数据操纵语句
4.9 思考与练习
第5章窗体
5.1 窗体概述
5.1.1 窗体的作用
5.1.2 窗体的组成
5.1.3 窗体的类型
5.1.4 窗体的视图
5.1.5 “窗体设计工具”选项卡
5.2 创建窗体
5.2.1 使用按钮快速创建窗体
5.2.2 使用向导创建窗体
5.2.3 使用设计视图创建窗体
5.2.4 使用数据透视图创建窗体
5.2.5 使用数据透视表创建窗体
5.2.6 主/子窗体
5.3 窗体控件
5.3.1 常用控件的功能
5.3.2 窗体和控件的属性
5.3.3 窗体和控件的事件与事件过程
5.4 修饰窗体
5.4.1 主题的应用
5.4.2 条件格式的使用
5.4.3 提示信息的添加
5.4.4 窗体的布局
5.5 使用窗体操作数据
5.6 思考与练习
第6章报表
6.1 报表概述
6.1.1 报表的一般类型
6.1.2 报表的视图
6.1.3 报表的组成
6.2 创建报表
6.2.1 使用“报表”创建报表
6.2.2 使用“报表向导”创建报表
6.2.3 使用“空报表”创建报表
6.2.4 使用“标签”创建标签报表
6.2.5 使用“报表设计”创建报表
6.3 报表设计
6.3.1 报表设计中的常用控件
6.3.2 报表节的使用
6.3.3 报表记录的排序和分组
6.3.4 报表中的计算控件
6.4 主/子报表和图表报表
6.4.1 主/子报表
6.4.2 图表报表
6.5 思考与练习
第7章宏
7.1 宏概述
7.1.1 宏的基本概念
7.1.2 宏的设计视图
7.1.3 宏的类型
7.1.4 常用的宏操作
7.1.5 宏的功能
7.2 创建宏
7.2.1 独立宏
7.2.2 嵌入宏
7.2.3 条件宏
7.2.4 Group块
7.2.5 子宏
7.2.6 宏的编辑
7.3 宏的应用
7.3.1 打印报表
7.3.2 导出Access对象
7.3.3 创建菜单
7.3.4 使用宏运行更多命令
7.4 宏的运行与调试
7.4.1 运行宏
7.4.2 调试宏
7.5 宏与VBA
7.5.1 宏与VBA编程
7.5.2 将宏转换为VBA模块
7.6 思考与练习
第8章 VBA编程基础
8.1 VBA编程环境
8.1.1 进入VBA编程环境——VBE窗口
8.1.2 VBE窗口的组成
8.2 程序设计概述
8.2.1 VBA模块简介
8.2.2 对象及其属性、方法和事件
8.3 VBA程序设计基础
8.3.1 数据类型
8.3.2 常量和变量
8.3.3 数组
8.3.4 运算符
8.3.5 表达式
8.3.6 常用内部函数
8.4 VBA程序流程设计
8.4.1 VBA语句的书写规则
8.4.2 VBA常用语句
8.4.3 顺序结构
8.4.4 选择结构
8.4.5 循环结构
8.5 过程声明、调用与参数传递
8.5.1 过程声明
8.5.2 过程调用
8.5.3 参数传递
8.6 VBA事件驱动机制
8.7 VBA程序调试和错误处理
8.7.1 VBA程序调试
8.7.2 错误类型
8.7.3 错误处理
8.8 思考与练习
附录
附录A 常用函数
附录B 窗体属性及其含义
附录C 控件属性及其含义
附录D 常用宏操作命令
附录E 常用事件
参考文献

FAQ

Is this book suitable for someone with no programming background at all?

Very suitable. The book starts from zero and assumes no prior programming or database knowledge, with particular emphasis in the first half on concept guidance and graphical interface operations, keeping the barrier to entry low.

What kind of work will I be able to do after studying this book?

After finishing it, you will be able to independently design and create small desktop database systems—for example, to manage customer information, inventory records, or library archives. You will be able to use queries to retrieve and analyze data efficiently, and create attractive forms and reports for data presentation and printing—enough to meet the data processing needs of many administrative and management positions.

Which version of Access are the book's cases and operations based on?

The book is generally written based on a relatively recent and widely used version of Access (such as Access 2016 or 2019), whose core interface and features are largely the same across versions. Even if you use another similar version (such as 2013 or 2021), you should have little trouble following along, as the core logic is entirely consistent.

Related on WeRead

Access数据库应用教程（2010版）邓海 Access 数据库应用教程李军 Access数据库应用教程李晓歌李晓歌 Access 2010数据库项目应用教程代秀珍贾振刚 Access 2016数据库应用教程白艳

This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.

About the author

Li Jun Author · China

Li Jun, who writes under the pen name Mingjian, graduated from Northeastern University with a degree in Computer and Information Management and works as an author and planner of computer books. Since 2000, he has published practical articles in various computer newspapers and magazines under his pen name. In 2002, he founded Mingjian Studio, later renamed Wenjie Academy, and has co-authored and published hundreds of computer books with Tsinghua University Press and other publishers. The library holds 21 of his works, spanning politics, law, medicine, popular science, design, and prose. They include a guide to studying Xi Jinping's important discourses on ecological civilization, legal works on labor dispute adjudication involving equity incentives and on corporate equity practice, medical and popular-science titles such as a work on infertility and illustrated guides to invasive insects and plants, and the essay collection Spring Water. His writing emphasizes practical guidance and the popularization of knowledge for a range of readers.

张立涛 Author

Zhang Litao is an author about whom little public information is currently available; the library holds only one work by this name, Access Database Application Tutorial. Judging from the title and its common classification under "examinations," the book appears to be a study and test-preparation textbook on database technology, aimed at readers who need to master the basic operations of Access and prepare for related exams. Because reliable information on the author's life, nationality, education, or professional positions is lacking, no further details about his personal background can be given. Based on the available work, Zhang Litao's writing tends toward the practical and instructional, focusing on the application of a specific software tool and serving the practical needs of course study and exam preparation. Such textbooks usually emphasize step-by-step operations and the organization of key knowledge points, making them suitable for beginners to practice in order. For readers, given the relatively limited reference materials, this work can be treated as an introductory guide to Access databases and used in line with examination requirements.

陈刚 Author

Chen Gang is an author with an unusually broad range of interests. Publicly available information about him is limited, and his nationality, dates of birth and death, and professional background cannot be verified. Judging from the fifteen works held in the collection, his writing spans medicine, applied psychology, law, politics, popular fiction, and photography—a breadth rarely seen among authors of his generation. In medicine, he has addressed hepatobiliary and pancreatic anatomy from the perspective of liver transplantation and the surgical treatment of hypertensive brainstem hemorrhage, showing attention to clinical anatomy and surgical practice. In law and politics, his works examine the modernization of civil procedure law through the lens of legal-system consciousness, along with international law and popular government, combining professional expertise with theoretical scope. He has also produced applied psychology titles such as Understanding Human Nature and practical texts such as guidelines for standardizing video-based investigation. In fiction, he appears in connection with the three-volume Jeff Wheeler Kingfountain series, as translator or editor. Overall, his works are knowledge-oriented and practice-driven, serving both specialist and general readers.

梁静毅 Author

Liang Jingyi is an author about whom limited public information is available; what can be confirmed centers on the book Access Database Application Tutorial. The book is classified under exam preparation and serves the needs of Access database courses and test review, with content focusing on basic database operations and practical application. This work suggests that Liang Jingyi writes for teaching and examination contexts, turning key software operations into tutorial material that is easy for readers to understand and practice, helping learners master basic skills such as creating tables, queries, forms, and reports. Because the author's nationality, dates of birth and death, educational background, and professional experience have no reliable public record, a full picture of the author's work remains difficult to outline. The available entry can only reflect the subject and purpose of this single work; further information may allow for supplementation later.

苏晓勤 Author

Su Xiaoqin is a compiler of computer textbooks about whom limited public information is available. Two works can currently be confirmed: A Practical Course in University Computer Studies and Access Database Application Tutorial. Judging from the subjects of these two books, her writing focuses mainly on introductory computer teaching at the university level and entry-level database applications, with an emphasis on practical operation and software skills, making the materials suitable for classroom instruction and self-study. In book classification, her works are often placed in the exam category, indicating that these textbooks have some reference value for computer proficiency examinations and related course preparation. Because public information about the author's education, positions, and professional experience is lacking, a more detailed account of her life cannot be provided at present. Overall, Su Xiaoqin's work centers on university basic computer education, stressing practicality and operability and offering beginners fairly systematic learning materials.