Exam 2: Create Select Queries

Using the D?n criteria, which of the following would NOT be matched?

A query can get its data from one or more tables, from existing queries, or from a combination of the two.

Left and right square brackets are used to surround ________ names in expressions.

The Access comparison operator for less than or equal to is ________.

The value that displays in place of actual field names in datasheets, forms, and reports is called a caption.

The second step in creating a query in Design view is to add the fields.

The wildcard character, # (number sign), matches any single character.

If you do not type quotations marks around criteria, they will be automatically inserted.

Pound signs in a numeric field indicate that the value is the right width for the column.

You need to manually insert the Like operator when including wildcards in query criteria.

When a query is run, the results display in Datasheet view.

Because dates are stored as ________ numbers, you can include arithmetic and comparison operators in your criteria.

Count is an example of a quantity statistic.

Query ________ operators such as > and < are used to compare two values.

The ________ operator calculates the total of the values in each group.

The Sum operator calculates the total of the values in each group.

If you add criteria to more than one query column, either one or the other criteria must be true for the record to be included in the query results.

The ________ logical operator creates a comparison of two criteria that is true if either of the criteria outcomes is true.

The wildcard character, ________, matches any combination of characters.

A special character used in query criteria, which allows matches for any combination of letters or characters, is called a ________.