Exam 3: Workshop 3: Queries and Data Access

A wildcard character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

When you ________,you select a value in a record and Access filters the records that contain only the values that match what you have selected.

When you filter by selection,you select a value in a record and Access filters the records that contain only the values that match what you have selected.

The ________ is a tool in Access that can help you format your calculated fields correctly.

The ________ Query Wizard is used to display fields from one or more tables or queries with the option to choose a detailed or summary query if working with more than one table.

If two tables do not have a common field,Access will join the two tables by combining the records,regardless of whether they have a matching field.This is called the ________ effect.

If two tables do not have a common field,Access will join the two tables by combining the records,regardless of whether they have a matching field.This is called the ________.

Null is the absence of any value and is different from blank or zero.

A ________ query is used when you want to find the rows in one table that do not have a match in the other table.

To search for a three-letter word that starts with "t" and ends with "p" you would enter t!p.

By default,records in a table or query are sorted by the ________ field.

The ________ allows you to move to the top and bottom of a table or scroll to a specific record.

To find all states that are not PA you could enter < >"PA" for the state criteria.The < > is an example of a logical operator.

To match any number of characters,you would use the ________ wildcard character.

A(n)________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

If you use multiple criteria,then you must also use ________ operators to combine criteria.

The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query.

A filter is a condition you apply temporarily to a table or query.