Exam 3: Maintaining and Querying a Database

-In the accompanying figure, a criterion is set for a field in the Visit table. ____________________

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

-The default name for a new Access query is ____________________.

Jorge has created a database for the herb garden he is planting this spring. Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial. He needs to answer the following questions using his database. Which plants need full sun? Which plants are Perennials? -To create a datasheet that lists all herbs that are Perennials, Jorge will create a new query. The Perennial field has a data type of Yes/No. Which criterion should Jorge use in the query for the Perennial field?

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

Which method of adding all of the fields from a table to the design grid is best when record selection criteria will be used in the query? How are the fields ordered in the design grid using this method?

MATCHING -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 process of rearranging records in a specified order or sequence is referred to as sorting.____________________

-In the accompanying figure, which field is the secondary sort field?

Jorge has created a database for the herb garden he is planting this spring. Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial. He needs to answer the following questions using his database. Which plants need full sun? Which plants are Perennials? -After creating the query, Jorge must set criteria to have the query return only those plants that need full sun. Entries for the Amount of Sun field include: partial sun, little sun, and full sun. How should Jorge enter the criteria for the exact match of full sun?

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

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

-A calculated field created in a query generates results when ____.

In the criterion, <=250, the operator will return values for the specified field that are ____.

The default query type for Access is the Crosstab query.

-In the accompanying figure, which field represents a calculated field?

Hiding a field in Datasheet view removes the field from the current table.

-A query based on more than one table is a(n) ____query.

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

-The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.