A | B |
Aggregate Functions | Calculations such as MIN, MAX, AVG, and SUM that are performed on a group of records. |
AND Condition | A condition in which only records where all of the values are present in the selected fields. |
Ascending Order | A sorting order that arranges text in alphabetical order (A to Z) or numbers from the lowest to highest number. |
Between...And Operator | A comparison operator that looks for values within a range. |
Calculated Field | A field that stores the value of a mathematical operation form, or report other than that listed as the field name. |
Comparison Operators | Symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria. |
Compound Criteria | Multiple conditions in a query or filter. |
Criteria | Conditions in a query that identify the specific records for which you are looking. |
Crosstab Query | A query that uses an aggregate function for data that can be grouped by two types of information and displays the data in a compact, spreadsheet-like format. |
Data Source | The table or tables from which a form, query, or report retrieves its data. |
Descending Order | A sorting order that arranges text in reverse alphabetical order (Z to A) or numbers from the highest to lowest number. |
Design Grid | The lower area of the Query window that displays the design of the query. |
Expression | 1. A combination of functions, field values, constants, and operators that produce a result. 2. The formula that will perform a calculation. |
Field List | A list of the field names in a table. |
Foreign Key | The field that is included in the related table so the field can be joined with the primary key in another table for the purpose of creating a relationship. |
Innermost Sort Field | When sorting on multiple fields in Datasheet view, the field that will be used for the second level of sorting. |
Is Not Null | A criteria that searches for fields that are empty. |
Is Null | Will exclude records where the specified field is empty. |
Join Line | In the Relationship window, the line joining two tables that visually indicates the related field and the type of relationship. |
Logical Operators | Operators that combine criteria using AND and OR. With two criteria,AND requires that both conditions be met and OR requires that either condition be met |
Message Bar | The area directly below the Ribbon that displays information such as security alerts when there is potentially unsafe, active content in an Office 2010 document that you open. |
One-to-Many-Relationship | A relationship between two tables where one record in the first corresponds to many records in the second table- the most common type of relationship in Access. |
OR Condition | A condition in which records that match at least one of the specified values are displayed. |
Outermost Sort Field | When sorting on multiple fields in Datasheet view, the field that will be used for the first level of sorting. |
Property Sheet | A list of characteristics- properties- for fields or controls on a form or report in which you can make precise changes to eah property associated with the field or control. |
Referential Integrity | A set of rules that Access uses to ensure that the data between related tables is valid. |
Relationship | An association that you establish between two tables based on common fields. |
Run | The process in which Access searches the records in the table included in the query design, finds the records that match the specified criteria, and then displays the records in a datasheet; only the fields that have been included in the query design display. |
Select Query | A type of Access query that retrieves data from one or more tables or queries, displaying the selected data in a datasheet; also known as a simple select query. |
Sorting | The process of arranging data in a specific order based on the value in each field. |
Subdatasheet | A format for displaying related records when you click the plus sign next to a record in a table on the one side of a relationship. |
Subset | A portion of the total records available. |
Table Area | The upper area of the Query window that displays field list for the tables that are used in the query. |
Text String | A sequence of characters. |
Trust Center | An area of the Access program where you can view the security and privacy settings for your Access installation. |
Wildcard Character | In a query, a character that serves as a placeholder for one or more unknown characters in your criteria; an asterisk (*) represents one or more unknow characters, and a question mark (?) represents a single unknown character. |