Term
|
Definition
| calculates a sum, average, count, or other type of total on records and then groups the results by two types of info: one down the left side of the datasheet and the other across the top. |
|
|
Term
|
Definition
| is a statement that is inside another select or action query |
|
|
Term
|
Definition
| is a SQL command that instructs the Microsoft Access database engine to return info from the database as a set of records. |
|
|
Term
|
Definition
| Changes the data in its datasource or creates a new table. |
|
|
Term
|
Definition
| adds the records in the query's result set to the end of an existing table |
|
|
Term
|
Definition
| removes rows matching the criteria that you specify from one or more tables. |
|
|
Term
|
Definition
| changes a set of records according to criteria that you specify |
|
|
Term
|
Definition
| creates a new table and then creates records in it by copying records from an existing table. |
|
|
Term
|
Definition
| includes rows in the query only when the joined field matches records in both tables |
|
|
Term
|
Definition
| includes all of the rows from one table in the query results and only those rows from the other table that match the join field in the first table |
|
|
Term
|
Definition
| each row from one table is combined with each row from another table |
|
|
