Term
|
Definition
| to locate text w/in a record that matches characters you type |
|
|
Term
|
Definition
| to substitute new text after finding a string of text |
|
|
Term
|
Definition
| a character (? OR *) that signifies one or more unspecified characters when finding text |
|
|
Term
|
Definition
| to use more than one field to sort |
|
|
Term
|
Definition
| to arrange records alphabetically or numerically according to a specified field |
|
|
Term
|
Definition
| to display only certain records |
|
|
Term
|
Definition
| to filter based on the data in the current field |
|
|
Term
|
Definition
| to show a form that allows you to enter criteria for the filter |
|
|
Term
|
Definition
| a defined set of operations to be performed on a table, or on the results of another query |
|
|
Term
|
Definition
| a query that sorts and filters a table or other query to extract certain fields and records based on the criteria you specify |
|
|
Term
|
Definition
| a view that allows you to choose the fields in a query, to sort, and to set criteria |
|
|
Term
|
Definition
| the lower half of the Query Design view that shows the field name, table name, sort order, show box, and criteria rows for selecting records |
|
|
Term
|
Definition
| the check box on the query design grid that allows you to display or hide a column that may be used in criteria or sorting |
|
|
Term
|
Definition
| the gray bar above a field in the query grid; click it to select that field in preparation for moving or deleting it |
|
|
Term
|
Definition
| a dialog box that shows properties for all aspects of an object; each query has this, as does each individual object |
|
|
Term
|
Definition
| a way to structure your data for printing w/format enhancements |
|
|
Term
|
Definition
| a view of the report that lets you change its appearance and contents |
|
|
Term
|
Definition
| any selectable item on a report or form layout |
|
|
Term
|
Definition
| a formula on the report that performs a math operation on the records and presents a result, such as counting, summing, or multiplying |
|
|
Term
|
Definition
| a series of dialog boxes that guide you through the creation of labels |
|
|
