Access Unit B- Building and Using Queries Test

In the figure above, which button indicates whether a filter is applied or not?

3

In the figure above, which button would you use to filter for more than one criterion?

4

In the figure above, which button would you use to filter for an exact match?

5

In the figure above, which button opens the Find and Replace dialogue box?

6

Which of the following comparison operators means "less than or equal to"?

<=

Which of the following comparison operators means "not equal to"?

<>

Which of the following comparison operators means "greater than"?

>

To find numbers greater than or equal 500, use which comparison operator?

>=

In the figure above, item 3 points to ___________.

A criteria entry

Which of the following is NOT true about a query?

A query is the same thing as a filter.

When you double-click a field in a field list in Query Design View, it is

Added to the next available position in the query design grid

In the figure above, item 3 could also be entered as ________.

All of the above; other answers: colorado, CoLoRaDo, or COLORADO

The wildcard character that stands for any group of characters is the ________.

Asterisk (*)

Limiting conditions used to narrow the number of records on a datasheet

Criteria

________ are rules or limiting conditions you set to determine which records will be selected in a filter or query.

Criteria

True or False: A filter can be used to create calculated fields.

False

True or False: Deleting a field from a query also deletes it from the underlying table.

False

True or False: The asterisk (*) is the wildcard used to represent one and only one character in criteria.

False

In the figure above, item 2 points to the _______.

Field list

In the figure above, item 4 points to a __________.

Field name

A(n) _______ is a temporary view of the data whose criteria are always discarded when you close the datasheet.

Filter

Creates temporary subset of records

Filter

This button helps search for data in a single field or in all fields.

Find

In the figure above, item 4 points to "Cost" as the ____________.

Fourth field of a query

To find all records where there is any entry in the field, even of the entry is 0, use which criteria?

Is Not Null

Criterion that finds all records where no entry had been made in the field

Is Null

A join line is also called a ________ line.

Link

In the figure above, item 7 points to the __________.

Link line

A query datasheet is sometimes called a __________ of the data.

Logical View

AND criteria

Must all be true for the record to be selected

A(n) _____________ is a saved view of the data whose criteria is not discarded when you close the datasheet.

Query

Creates a datasheet of selected fields and records from one or more tables

Query

The lower pane in Query Design View

Query grid

The wildcard character that stands for any single character is the ________.

Question mark (?)

In the figure above, item 5 points to the ___________.

Related fields

Use the ______ command to save the current object with a new name.

Save Object As

Putting records in ascending or descending order based on a field's values

Sorting

SQL stands for _____.

Structured Query Language

Criteria _______ is the term for rules by which criteria must be entered in a query.

Syntax

Rules that determine how criteria is entered

Syntax

True or False: A Query is commonly used as the source of data for a form or report.

True

True or False: A query allows the selection of several fields and records from one or more tables, then presents the selected data as a single datasheet.

True

True or False: A query can be used to create calculated fields.

True

True or False: Enter OR criteria on different Criteria rows in the query design grid.

True

True or False: Filters are used to select a subset of records in a database.

True

True or False: Queries evaluate multiple sort fields in a left-to-right order making the leftmost sort field the rivalry sort field.

True

True or False: The question mark (?) is the wildcard character which stands for any single character in criteria.

True

True or False: To add, delete, or change fields in a query, you use Query Design View.

True

In the figure above, item 1 points to the __________.

View button

Used to search for a pattern

Wildcard