Exam 2: Create Select Queries

When entering criteria that include wildcards, the ________ operator will automatically be entered.

Tables can be added to the query design workspace by ________ them from the Navigation Pane.

Use the ________ to build expressions in a query.

The Run button for executing a query is found in the ________ group under the Design tab.

Average is an example of a summary statistic.

A(n) ________ displays a subset of the data in response to a specific question.

When a date is used as query criteria, the ________ symbol is placed before and after it.

The Quick Info message explains the purpose of the selected AutoComplete command.

Select queries ________ and display the records that answer the question.

Captions display in ________ headings in the query datasheet.

When an alias is used in an expression, it is enclosed in square brackets.

Using the Don* criteria, which of the following would NOT be matched?

A(n) ________ is a combination of fields, mathematical operators, and pre-built functions that calculates values in tables, forms, queries, and reports.

When creating a query, the criteria are the ________ used to select the desired records.

The ________ operator finds all numbers or dates between and including two values.

When a value must not match, type <> and then type the value.