| A | B |
|---|
| Action Query | A query that creates a new table or changes data in an existing table. |
| Aggregate Functions | Calculations such as MIN, MAX, AVG, and SUM that are performed on a group of records. |
| Append Query | An action query that adds new records to an existing table by adding data from another Acces database or from a table in the same database. |
| Arithmetic Operators | Mathematical symbols used in building expressions. |
| Caluculated Field | A field that stores the value of a mathematical operation. |
| Cross Join | A join that displays when each row from one table is combinded with each row in a related table, usually cerated unintentionally when you do not ceate a join line between related tables. |
| 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. |
| Delete Query | An action query that removes records from an existing table in the same database. |
| Destination Table | The table to which you import or append data. |
| Expression | 1. A combination of function, field values, constants, and operators that produce a result. 2. The formula that will perform a calculation. |
| Find Duplicates Query Wizard | A query that is udes to locate duplicate records in a table. |
| Find Unmatched Query Wizard | A query used to locate unmatched records so they can be deleted from the table. |
| Inner Join | A join that allows only the records where the common field exists in both related tables to be displayed in query results. |
| Join | A relationship that helps a query return only the records from each table you want to see, based on how those tables are related to other tables in the query. |
| Left Outer Join | A join used when you want to display all of the records on the one side of a one-to-many relationship, whether or not there are matching records in the table on the many side of the relationship. |
| Make Table Query | An action query that creates a new table by extracting data from one or more tables. |
| Multivalued Fields | Fields that hold multiple values. |
| Outer Join | A join that is typically used to display records from both tables, regardless of whether ther are matching records. |
| Parameter | A value that can be changed. |
| Parameter Query | A query that prompts you for criteria before running the query. |
| Right Outer Join | A join used when you want to display all of the records on the many side of the one-to-many relationship, whether or not there are matching records in the table on the one side of the relationship. This should not occur if referential integrity has been reforced because all orders should have related customer. |
| Source Table | The table from which records are being extracted or copied. |
| Static Data | Data that does not change. |
| Totals Query | A query that calculates subtotals across groups of records. |
| Unequal Join | A join that is used to combine rows from two data sources based on field values that are not equal; can be created only in SQL view. |
| Unmatched Records | Records in one table that have no matching records in a related table. |
| Update query | an action query used to add, change, or delete data in fields of one or more existing records |
