Term
|
Definition
| (AC 95-96) The results will include only those records that match each individual criterion. |
|
|
Term
|
Definition
| (AC 117-119) - A function that performs some mathematical function against a group of records. |
|
|
Term
|
Definition
| (AC 113) A field that can be calculated from other fields. |
|
|
Term
|
Definition
| (AC 94) A operator such as greater than, less then, equal to, not equal to. |
|
|
Term
|
Definition
| (AC 95-96) When you have more than one criterion that the data for which you are searching must satisfy. |
|
|
Term
|
Definition
| (AC 122-125) - A crosstab query is a matrix, where the column headings come from the values in a field. |
|
|
Term
|
Definition
| (AC 98-103) - The design grid is a graphical tool that allows you to create a query by placing fields from the upper half of the Query window into the design grid in the lower half of the window. |
|
|
Term
|
Definition
| (AC 121-122) - When you group data in a report, you tell Access that you want certain data arranged together. For example, you might want to group order records by item number, with all the orders for a particular item number listed together. |
|
|
Term
|
Definition
| (AC 103-107) To find records in the two tables that have identical values in matching fields. |
|
|
Term
|
Definition
| (AC 95-96) The results will include all records that match either individual criterion. |
|
|
Term
|
Definition
| (AC 89-92) A query that prompts for input whenever it is used. For example it may ask for name or city. |
|
|
Term
|
Definition
| (AC 97) Determines the order of the records as a result of a query. |
|
|
Term
|
Definition
| (AC 100) - The property sheet contains settings that control the characteristics or appearance of the selected control. |
|
|
Term
|
Definition
| (AC 74) - A query is a question that you ask about the data in your table(s). For example, you may want to know which of your customers bought pinto beans in March. Access searches designated tables or queries and provides you with an answer. |
|
|
Term
|
Definition
| (AC 97-103) The arrangement of the data in a certain order. For example, you might want to sort order records by date ordered. You also can sort items within a group. |
|
|
Term
|
Definition
| (AC 87) - A symbol that represents any character or combination of characters. |
|
|
