Exam 2: Create Select Queries

When a query selects fields from multiple tables, the tables need to be ________.

________ to add fields to the design grid.

If you do not enclose date criterion in number signs (#), they will be inserted automatically.

Criteria are case sensitive.

Once a select query is created, it can be used only one time.

When creating a query in Design view, the screen displays two panes, the query design workspace and the query ________.

The × symbol indicates multiplication in an expression.

When creating a query, the ________ displays the tables that the query will search.

The last step in creating a query in Design view is to add the tables.

After you create a select query, you ________ it to see the results.

The Simple Query Wizard can be used to quickly ________ fields to a new query.

In expressions, field names are always enclosed by parentheses.

Use the Property Sheet to adjust the number of decimal places a calculation displays in the query datasheet.

In queries, calculated fields need a descriptive label used to identify a field in expressions, datasheets, or forms and reports.

It is best practice to exclude spaces from field names.

The Access comparison operator for not equal to is ________.

The wildcard character, ________, matches any single numeric character.

When selecting the fields you want to display in the query result, choosing fields from unrelated tables will result in too many records displaying.

In expressions, field names are enclosed between ________.

A calculated field can be assigned any of the data types other fields are assigned.