Access 2013 lesson 12 vocab

Match it! Select the correct answer from the pull down...Good luck!

An action query that removes rows matching the criteria that you specify from one or more tables.

An action query that creates a new table and then creates records in it by copying records from an existing table.

A relationship between identical fields in different tables.

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.

A join in which each row from one table is combined with each row from another table.

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.

A column in a query that results from an expression.

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.