Access数 据 库 图 文 教 案 1 第一部分 Access数据库管理系统 ·························· 2 1.1 数据库系统的认识 ······························ 2 1.2 关系数据库 ································· 2 1.3 Access 数据库管理系统 ···························· 3 1.4 Access 数据库 ································ 3 第二部分 数据表 ·································· 4 2.1 数据表的认识 ································ 4 2.2 创建数据表 ································· 5 2.3 管理数据表 ································· 6 2.4 创建数据表间的关系 ····························· 6 2.5 表数据的操作 ································ 7 2.6 设置表外观 ································· 9 第三部分 查询 ·································· 10 3.1 查询的认识 ································ 10 3.2 创建查询 ································· 10 第四部分 窗体 ·································· 13 4.1 窗体的认识 ································ 13 4.2 创建窗体 ································· 13 4.3 修饰窗体 ································· 17 4.4 在窗体中操作数据 ····························· 17 4.5 预览并打印窗体 ······························ 17 第五部分 报表 ·································· 17 5.1 报表的认识 ...