Exam 3: Workshop 3: Queries and Data Access

When using the Find Duplicates Query Wizard,you select the fields that you think may include duplicate information,and the wizard creates the query to find records matching your criteria.

Which of the following is NOT true about applying filters to a datasheet?

In a query,you can select any records that have no value in a field using the ________ criteria.

In a query,you can select any records that have no value in a field using the ________ criteria.

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

A wildcard character can replace a single character or multiple characters and both text and numbers.

Which of the following is NOT a method used to open or switch views?

________ is the process of rearranging records in a specific order.

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.

________ compare the values in a table or another query to the criteria value you set up in a query.

In Datasheet view,you can use the ________ to quickly locate specific records using all or part of a field value.

If you need to see a quick snapshot of statistics for a table or query,you can use the ________.

A(n)________ query is used when you want to find records with the same specific value.

An orphan is a foreign key in one table that does not have a matching value in the primary key field of a related table.

Text filters allow you to create a custom filter to match ________ the text in a field that you specify.

In a query,if you wanted to display the smallest value from the selected records,you would use the ________ aggregate function.

When you want to specify multiple criteria,and all criteria must be true for a record to be included in the results,then the ________ logical operator is used.

To search for a three-digit number that starts with "67" you would enter 67*.