Exam 2: Create Select Queries

In a query, calculated fields begin with a descriptive label that ends with an asterisk.

In the Show Table dialog box, ________ a table to add it to the query design workspace.

All of the following are Date/Time formats EXCEPT ________.

Select queries do not change the data in the underlying table(s).

AutoComplete is a menu of commands that ________ the characters you type.

The multiplication operator is ________.

By default, queries follow the relationship rules defined in the Relationships window.

In query criteria, numbers are typically combined with comparison operators.

In a query, the alias in a calculated field ends with a(n) ________.

The Query Design button is found in the ________ group under the Create tab.

The ________ logical operator creates a comparison of two criteria that is true only when both criteria outcomes are true.

It is okay to include spaces in labels.

The results of a query are displayed in ________ view.

Quick Info, ToolTips, and AutoComplete are displayed by the ________ feature.

The Query Wizard button is found in the Queries group under the ________ tab.

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

A(n) ________ is a descriptive label given to a calculated field.

The placement of criteria in the design grid rows does not determine whether records display.

When two criteria are placed in the same row in the design grid, the And logical operator applies.

________ statistics are calculations for groups of data such as totals, averages, or counts.