| A | B |
|---|
| action query | Changes the data in its data source or creates a new table. |
| aggregate function | Performs a calculation on a set of values and then returns a single value. |
| append query | An action query that adds the records in a query's result set to the end of an existing table |
| calculated field | A column in a query that results from an expression. |
| cross join | A join in which each row from one table is combined with each row from another table. |
| crosstab query | A query that calculates a sum, average, count, or other type of total on records and then groups the results by two types of information: one down the left side of the datasheet and the other across the top. |
| delete query | An action query that removes rows matching the criteria that you specify from one or more tables. |
| inner join | Most common type of join; includes rows in the query only when the joined field matches records in both tables. |
| join | A relationship between identical fields in different tables. |
| left outer join | A join that includes all of the rows from the first table in the query and only those records from the second table that match the join field in the first table. |
| make table query | An action query that creates a new table and then creates records in it by copying records from an existing table. |
| outer join | A join that includes all of the rows from one table and only those rows from the other table that match the join field in the first table. |
| right outer join | A join that includes all of the rows from the second table in the query and only those records from the first table that match the join field in the second table. |
| SELECT statement | An SQL command that instructs the Microsoft Access database engine to return information from the database as a set of records. |
| subquery | An SQL SELECT statement that is inside another select or action query. |
| unequal join | A join that is not based on the equivalence of the joined fields. |
| update query | An action query that changes a set of records according to specified criteria. |
