Term
|
Definition
| To enter a number in a criterion, type the number without any ____ or _____. |
|
|
Term
|
Definition
| T or F: Unless you specify oherwise, Access assumes that the criteria you enter involves exact matches. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| term for specifying to Access you do not want an exact match for entered criteria |
|
|
Term
|
Definition
Comparison operators are:
a) >
b) <
c) >=
d) <=
e) ≠
f) all of the above
g) all but c and d
|
|
|
Term
|
Definition
| when you have more than one criterion that the data must satisfy |
|
|
Term
| AND criterion, OR criterion |
|
Definition
| What are the two types of compound criterion? |
|
|
Term
|
Definition
| each individual criterion must be true in order for the compound criterion to be true |
|
|
Term
|
Definition
| compound criterion is true if either of the individual criterion is true |
|
|
Term
|
Definition
| allows you to search or a range of values in one field |
|
|
Term
False
The database displays the records differently, but the underlying tables remain in their original order |
|
Definition
| T or F: When sorting data in a query, the underlying tables are rearranged. |
|
|
Term
|
Definition
| to rearrange records in a particular way |
|
|
Term
|
Definition
| the field or fields on which the records are sorted |
|
|
Term
|
Definition
| the more important field when sorting on more than one field |
|
|
Term
|
Definition
| another name for major key |
|
|
Term
|
Definition
| the less important field when sorting more than one field |
|
|
Term
|
Definition
| another name for minor key |
|
|
Term
|
Definition
| window containing the various properties of the object |
|
|
Term
|
Definition
| The property sheet is used to omit ______. |
|
|
Term
|
Definition
| the default in Access--Access selects all records from two tables that have the same value int he fields that are joined |
|
|
Term
|
Definition
| are used to show all the records in one table as well as the common recrods |
|
|
Term
|
Definition
| records that share the same value in the join field |
|
|
Term
|
Definition
| The major sort key must appear to the (a. left b. right) of the minor sort key in the design grid |
|
|
Term
|
Definition
| query that allows you to show only a specified number of records--those having the highest or lowest values |
|
|
Term
|
Definition
| records having the highest values |
|
|
Term
|
Definition
| records having the lowest values |
|
|
Term
|
Definition
| When you run a top-value query, it is important to change the value in the Top Values box back to ____. |
|
|
Term
|
Definition
| to find records in two tables that have identical values in matching fields |
|
|
Term
|
Definition
| a line Access draws between matching fields in the two tables to indicate that they are related |
|
|
Term
|
Definition
| T or F: You can insert a join line manually by clicking one of the two matching fields and dragging it to the other matching field |
|
|
