Ch 5 access – Flashcards

In the accompanying figure, the top values query is designed to return the top values for the ____ field.

Max is an example of a(n) LOGICAL function used in a crosstab query.

A Social Security Number which appears in the format 123-456-7891 is an example of a(n) ____.

A query that selects records in fields that satisfy the criteria is a Select query.

Tables used in a find unmatched query must have a COMMON FIELD.

When using the IIf function, a condition is tested, and if the condition is FALSE, the first value of the condition is returned by the function.

The LIKE COMPARISON OPERATOR is used to select records by matching field values to a specific pattern that includes one or more of the wildcard characters (*, ?, #) in a query.

The Top Values query property allows the user to limit the number of records in the query results by using a preset value, by entering an integer, or by selecting a(n) ____________________.

A PARAMETER QUERY displays a dialog box that prompts the user to enter one or more values when the query is run.

A calculated query uses aggregate functions to perform arithmetic operations on selected records.

Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces.

A ____ query uses functions, such as Sum and Count, to perform arithmetic operations on selected records.

Joining two or more fields in a calculated field using an expression such as =Title & " "& FirstName & " " & LastName is an example of CONCATENATION.

A value of true will be returned if a field is empty when the IsNull function is used.

Which of the following is an example of a parameter query prompt criterion?

The value of a field containing no information is a ____ value.

In crosstab query results, the value of a checked Yes/No data type field will display as ____.

When using the IIF function, each part of the function is separated by a COLON.

Which Access object(s) may be used when creating a lookup field to select values?

The ____ function tests a condition and returns one of two values; the function returns the first value if the condition is true and the second value if the condition is false.

An input mask may be created for any field with the ____ or ____ data type.

A nonnull field is a field that contains any data at all, including a single space.