Access 2 Tests

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

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet.

In Access, the Save As command allows you to save either the entire database or the current object with a new name.​

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

The ____ button provides a list of values in the selected field that can be used to customize a filter.

____ will find all records where there is any entry in the field, even if the entry is 0.

Access saves ____ automatically as you move from record to record.

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

Query criteria are not case sensitive.​

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

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

Deleting a field from a query also deletes it from the underlying table.

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

Creates a datasheet of selected fields and records from one or more tables The lower pane in Query Design View Limiting conditions used to narrow the number of records on a datasheet Putting records in ascending or descending order based on a field's values Used to search for a pattern Creates a temporary subset of records Criterion that finds all records where no entry has been made in the field Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines

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

A filter can be used to create calculated fields.

A join line is also called a(n) ____ line.

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

You can enter, edit, and navigate data in a query datasheet just like a(n) report datasheet. _________________________

To sort records based on the selected field in the order Z to A, use the _____ button.​

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

To delete records from a query datasheet, click the record selector button to the left of the record, click the Home tab, click the Delete button in the Records group, and click Yes.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

SQL stands for ____.

A(n) ____ is a saved object within the datasheet.

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

Query Design View presents the fields you can use for a query in small windows called field ____.

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

Daniel Arno owns a lawn and landscape business with many customers. Occasionally, he wants to filter the data about his customers in various ways. Daniel lives in Oxford and he would like to find all customers who do not live in Oxford. Which comparison operator should he use?​

To filter for comparative data, use the Filter By Selection feature.

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

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

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

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

Filters are used to select a subset of records in a datasheet.

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

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

To move a field in the query design grid, click its ____, and then drag it left or right.

A query can be used to create calculated fields.

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

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

Enter OR criteria on different Criteria rows in the query design grid.