Working with Queries

If you often want to access only a subset of your data that can be well defined by a filter condition, you can define a query. This is basically a name for the new view at the filtered data. You open the query and see the current data in the table layout that you defined.

Creating a New Query With the Query Wizard

In Office you can create a new query using the Query Wizard:

1. Open the database file in which you want to create the new query.

2. In the left pane of the database window, click the Queries icon.

3. Click Use Wizard to Create Query.

Creating a New Query With the Design View

1. Open the database file in which you want to create the new query.

2. In the left pane of the database window, click the Queries icon.

3. Click Create Query in Design View.

You see the Query Design window.

Related Topics

• Using Databases in Office Base
• Database Overview