《数据库管理系统》教案-第四节.ppt

第四章 创建查询 Creating Queries 4.1 Understanding and Using Simple Queries 了解和使用简单查询 Hour 3. Queries Introduced 4.2 Using Operators, Functions and Expressions 使用运算符、函数和表达式 4.3 Creating Queries 创建查询 4.1 Understanding and Using Simple Queries Hour 3. Queries IntroducedQueries are stored questions about data. They are an extremely powerful aspect of Microsoft Access. By using queries, you can retrieve just the data you want, how you want it, whenever you want it. In this hour youll learn the following: What is a query? 什么是查询 Types of queries 查询的类型 Query capabilities 查询的功能 How to open a query in Datasheet view How to open a query in Design view How to run a query How to add fields to a query, change the sort order of a query, and modify a querys criteria How to save a query How to print query results How to close a query What is a query ? 什么是查询 A Select query is a stored question about the data stored in a databases tables. 一个选择查询 是对存储在表（Tables）中数据 的一种提问。 Select queries are the foundation of much of what you do in Access. They underlie most forms and reports, and they allow you to view the data you want, when you want. 选择查询是许多工作的基础。 You use a simple Select query to define the tables and fields whose data you want to view and also to specify the criteria that limits the data the querys output displays. A Select query is a query of a table or tables that just displays data; the query doesnt modify data in any way. For example：The datasheet view of the “ Current Product List ” query is shown in Figure 4-1. How to open a query in Datasheet view When youre working with an existing query, you need to be able to open it in Datasheet view. Here are the steps in involved: Select Queries in the list of objects in the Database window. Click to select the query that you want to run, and then