Defining filters in the Filter window
Use the Filter window to define the filters that you select in
the Query editor. The Filter window opens each time you move a filter from
the Fields pane in the Query editor to the Filters pane.
Grouping query filters
You can group filters in the Filter Criteria list using the logical
operators AND and OR. Use the Query editor or the Query wizard to group query
filters to create complex filters.
Querying across multiple record types
The first step in creating a query is to select a record type.
You can only select one record type from the list.
Moving fields to the Favorites folder
You can store frequently used fields in the Favorites folder for
easy access when creating or editing queries.