Exam 2: Access 2: Building and Using Queries

To search for a pattern, you can use a(n) ____________________ character, a symbol you can use as substitute for characters to find information that matches your find criteria.

SQL is the acronym for " Simple Query Language ." _________________________

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

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.

A query can be used to create calculated fields.

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

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

Discuss adding or deleting a table in a query.

If, for example, a find-and-replace effort does not work correctly, click the Undo button to cancel the changes. _________________________

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

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

To move fields in the query grid, drag the field ____________________.

____________________ are limiting conditions you set in the query design grid.

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

By default, the printout of a datasheet contains the object name and current date in the footer . ____________________

____________________ a table or query datasheet temporarily displays only those records that match given criteria.

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

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

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