查询^(Query)是从单个表或多个表中检索数据的工具；它是在Microsoft Access^{(Microsoft Access)}中分析数据的最强大工具；基本上^(Basically)，查询^(Query)只是以Access可以处理的方式呈现的问题或数据请求。

在 Access 中创建和修改查询

在查询组^{(Queries Group)}中，有两个工具可以创建您的查询^(Query)：

1. 查询向导^{(The Query Wizard)}：帮助您创建一个简单的查询

• • 简单查询向导^{(Simple Query Wizard)}：这会根据您选择的字段创建查询。
  • 交叉表查询向导^{(Cross Tab Query Wizard)}：此向导创建一个以电子表格格式显示数据的交叉表查询。^{(Crosstab Query)}
  • 查找重复查询向导^{(Find Duplicate Query Wizard)}：此向导创建一个查询^(Query)，用于在单个表和查询^(Query)中查找具有重复字段值的数据。
  • 查找不匹配的查询向导^{(Find Unmatched Query Wizard)}：这将创建一个查询，该查询在一个表中查找记录或行，而在另一个表中没有相关记录。

1. 查询设计：在^{(The Query Design)}设计视图^{(Design View)}中创建一个新的空白查询。您可以使用Show Table对话框将查询和表添加到Query Design中。

使用查询有什么好处？^(Advantages)

在Microsoft Access中，查询可以回答一个简单的问题、合并来自不同表的数据、执行计算、添加、更改和删除数据库中的数据。在本文中，我们将解释如何：

1. 如何在向导查询中创建^{(Wizard Query)}查询^(Query)。
2. 如何在查询设计中创建^{(Query Design)}查询^(Query)
3. 在设计查询窗口中将^{(Design Query Window)}数据^(Data)添加到设计网格^{(Design Grid)}
4. 如何删除查询

1]如何^(How)在向导查询^{(Wizard Query)}中创建查询^(Query)

单击创建选项卡^{(Create Tab)}。在查询组^{(Queries Group)}上，您可以选择向导^(Wizard)或查询设计^{(Query Design)}。首先^(First)，我们将解释如何在向导查询中创建^{(Wizard Query)}查询^(Query)。

单击Wizard Query，然后选择Simple Query Wizard，它可以让您创建一个简单的Query，单击^(Click) OK。选择要放入查询的表和字段；单击下一步^(Next)。

您将看到两个打开查询^(Query)的选项；您可以选择打开查询^(Query)查看信息，即立即创建查询^(Query)或选择修改查询。然后完成^(Finish)。正在进行查询。

2]如何^(How)在查询设计^{(Query Design)}中创建查询^(Query)

使用查询设计^{(Query Design)}。单击查询设计^{(Click Query Design)}。在Query Design窗口中，有一个Show Table对话框，其中包含Tables、Links、Queries或All等类别。

在本文中，我们坚持使用Table类别并选择要在Query中使用的表。单击^(Click) 添加选定表^{(Add Selected Table )}或双击。该表将添加到查询^(Query)窗口；表必须连接（参见关于关系的文章）。

3]在设计查询^{(Design Query)}窗口中将数据添加^{(Add Data)}到设计网格^{(Design Grid)}

设计网格^{(Design Grid)}位于窗口的下部窗格，并指定查询字段^(Query)和条件。设计网格^{(Design Grid)}由Fields、Table、Sort、Criteria和or组成。

要将数据添加到设计网格^{(Design Grid)}，请双击要包含在查询中的所选表中的^(Query)字段^(Fields)。您将在设计网格^{(Design Grid)}中看到数据。另一个选项是转到Design Grid，单击Field行；您将看到一个下拉菜单，选择您的字段。

字段行下方是表格^(Table)行。选择您想要的表。您可以在排序^{(Sort )}行中对数据进行排序。

Criteria行用于从 Table 或^(Criteria)Query中搜索您要查找的内容。例如，您正在寻找拥有会计^(Accounts)和工商管理学位^{(Business Administration Degree)}的学生。首先在^(First)Accounts下方或行中的字段Degree和Business Administration下的Criteria行中键入Accounts。单击运行^(Run)。

创建一个查询。单击快速访问工具栏上的保存命令，命名您的^(Save)查询^(Query)，然后单击确定^(OK)。

4]删除查询^(Query)。在导航窗格^{(Navigation Pane)}中找到查询^(Query)。选择Query，右键单击，然后选择Delete。查询^(Query)将从导航窗格^{(Navigation Pane)}中删除。

阅读下一篇^{(Read next)}：如何在 Microsoft Access 中创建表单。

How to Create and Modify Query in Microsoft Access

A Query is a tool that retrieves data from a single table or multiple tables; it is the most powerful tool to analyze your data in Microsoft Access; Basically, a Query is just a question presented in a way that Access can process or a request for data.

Create and Modify Query in Access

In the Queries Group, there two tools that can create your Query these are:

1. The Query Wizard: Helps you to create a simple Query

• • Simple Query Wizard: This creates Query from the fields you pick.
  • Cross Tab Query Wizard: This wizard creates a Crosstab Query that displays data in a spreadsheet format.
  • Find Duplicate Query Wizard: This wizard creates a Query that finds data with duplicate field values in a single table and Query.
  • Find Unmatched Query Wizard: This creates a Query that finds records or rows in one table with no related records in another table.

1. The Query Design: Create a new blank query in Design View. You can use the Show Table dialog box to add queries and tables to the Query Design.

What are the Advantages of using a Query?

In Microsoft Access, a Query can answer a simple question, merge data from different tables, perform calculations, add, change, and delete data from the database. In this article, we are going to explain how to:

1. How to Create a Query in Wizard Query.
2. How to Create a Query in Query Design
3. Adding Data to Design Grid in the Design Query Window
4. How to delete a Query

1] How to Create a Query in Wizard Query

Click the Create Tab. On the Queries Group, you can either select Wizard or Query Design. First, we are going to explain how to create Query in Wizard Query.

Click Wizard Query, then select Simple Query Wizard, which lets you create a simple Query, Click OK.  Choose the table and fields you want to put into your Query; click Next.

You will see two options for opening your Query; you can choose to open the Query to view information, which creates the Query immediately or choose to modify the query. Then Finish. A Query is being made.

2] How to Create a Query in Query Design

To use Query Design. Click Query Design. In the Query Design window, there is a Show Table dialog box, with categories such as Tables, Links, Queries, or All.

In this article, we are sticking to the Table category and choose a table we want to use in the Query. Click Add Selected Table or double click. The table will add to the Query window; the tables must be connected (see article about relationships).

3] Add Data to Design Grid in the Design Query window

The Design Grid is located at the lower pane of the window and specifies the Query fields and criteria. Design Grid consists of Fields, Table, Sort, Criteria, and or.

To add data to the Design Grid, Double click on the Fields from your selected table you want to include in the Query. You will see the data in the Design Grid. The other option is to go to the Design Grid, click in the Field row; you will see a drop-down menu, choose your fields.

Below the field row is the Table row. Select your desired table. You can sort your data in the Sort row.

The Criteria row is to search for what you are looking for from your Table or Query. For instance, you are looking for students that have an Accounts and Business Administration Degree. First type Accounts in the Criteria row under the field Degree and Business Administration in the or row below the Accounts. Click Run.

A Query is created. Click the Save command on the quick access toolbar, name your Query, and then click OK.

4] To delete a Query. Locate the Query on the Navigation Pane. Select the Query, right-click, then Delete. The Query will be removed from the Navigation Pane.

Read next: How to Create a Form in Microsoft Access.

Related posts

• 如何使用Microsoft Access创建Report

• 如何使用Microsoft Access创建Database

• 如何使用 Microsoft Access 构建数据库

• Access & use Microsoft Edge有关在Windows 10 flags页面

• MDB Viewer Plus：View and Edit Microsoft Access Database Files

• 访问被拒绝 - CIFS 的约束委派失败

• 使用Group Policy & PowerShell配置受控Folder Access

• 如何在Windows中选择或突出显示文本

• 如何Create and Use AutoText entries在Microsoft Word

• Remove Access Denied error访问Windows中的文件或文件夹时

• 如何在Office程序中自定义Quick Access toolbar

• 创建键盘快捷键以安全访问删除硬件对话框

• 如何在Word Quick Access Toolbar上展示Spelling and Grammar tool

• 如何在Windows 10中启动Microsoft Edge（12种方式）

• 为 Microsoft Office 创建或生成键盘快捷键

• 如何从Logon screen中删除Access button的Ease

• 如何Backup and Restore Quick Access Folders在Windows 10

• 在 Microsoft Word 中创建带有复选框的清单，以及如何编辑它们

• NVIDIA Control Panel Access拒绝 - 不会应用设置

• 如何在 Microsoft Office for Android 中创建和保存 Excel 电子表格