Access数据库应用进阶.PDF

Advanced Application of Access Database Access 数据库应用进阶 目标与内容Objectives and Content In this course, we will learn how to create, modify and apply the main objects of Access, such as, tables, queries, forms, reports, webpages, etc. And we will also have some thorough discussions about various data relationships and different types of data links. Through learning the course, trainees will be able to establish Access databases based on their practical needs as well as to use and maintain the databases. 本课程深入介绍 Access 主要对象如表、查询、窗体、报表和网页等的各种创建方法，以及这些对象的修 改和应用，并对 Access 数据库的各种数据关系和各种连接情况进行详尽的讨论。通过本课程的学习，学 员能针对实际工作需要建立Access 数据库，并对其应用和维护。 参加对象Target Group This course is designed for those who have taken the 本课程适合学习过 Access 初级课程或已能 Access Basics course, or have a similar knowledge of 初步应用Access 的相关人士。 日期Schedule Access. in 2017 May 11-12 July 25-26 November 7-8, 2017 大纲Outline 价格 Price  Designing a Detailed Table Structure  数据表结构的详细设计 Members: RMB 1600  Setting Filed Properties  设置数据表字段的属性 Non-members:  Understanding Data Relationships in Access  Access 的数据关系 RMB 1800  Defining Data Relationships  如何建立Access 数据关系 Fee includes  Enforcing the Referential Integrity  数据关系的参照完整性 lectures,  Creating a Multi-Table Query  创建多表查询 course materials and