Identify the letter of the choice that best matches the phrase or definition.

A. Displays all records in one table that have corresponding values in the common field in another table
B. Compares the value in a field with a range of values in a criterion
C. Restricts data in a single table to create a temporary subset of records
D. Allows you to ask a question based on one or more tables in a database
E. A special type of Totals query that performs aggregate function calculations on the values of one database field and allows you to determine exactly how your summary data appears in the results
F. An arithmetic formula used to make a calculation
G. Used to test values that can only be true or false
H. A phrase, usually in the form of a question or instruction, enclosed in square brackets
I. A mathematical or statistical operation that you apply to records that meet a query’s selection criteria
J. Includes all of the records from the table on the left in Design view, even if there are no matching values for records in the table on the right
K. Lets you modify data in a table, add records to or delete records from a table, or create a new table based on expressions you enter and criteria you set
L. Includes all of the records from the table on the right in Design view, even if there are no matching values for records in the table on the left

A. inner join
B. comparison operator
C. filter
D. select query
E. crosstab query
F. expression
G. logical operator
H. parameter value
I. aggregate functions
J. left outer join
K. action query
L. right outer join