Exam 3: Maintaining and Querying a Database

The default name for a new Access query is ____________________.

A ____________________ is a set of records that answers the question resulting from a query.

The condition "Seattle" for the field City in a student database is an example of what type of value?

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

Which comparison operator matches a pattern that includes wildcards?

The ____ command removes the display of one or more fields in Datasheet view.

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.

Identify the letter of the choice that best matches the phrase or definition. -The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

The most simple technique to use for filtering records is Filter By Form.____________________

Data may be sorted in a table datasheet,a form,and a ____.

When the sort field data for each record in a database is different,the sort field is ____.

In a query,Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

Date criteria are automatically enclosed in ____ when entered in a query design.

Identify the letter of the choice that best matches the phrase or definition. -Operators that allow two or more conditions to be combined such as And.

Identify the letter of the choice that best matches the phrase or definition. -A predefined set of formats including colors,fonts,and other effects that enhance an object's appearance and usability.