Selects records that match two or more conditions in a query (AC 71).
Arranges records from A to Z, or smallest to largest (AC 56).
A menu that contains options for sorting data and clearing any filters that you have already applied (AC 58).
When a field displays a value that is calculated using other fields in the query (AC 75).
A matching field is also called this because it is the same in both tables involved in the relationship (AC 66).
Another term for criterion; a way of telling the query which data you are interested in seeing (AC 53).
When the condition has two or more parts to it the two conditions are called criteria (AC 53).
Another term for condition; a way of telling the query which data you are interested in seeing (AC53).
Arranges records from Z to A, or largest to smallest (AC 56).
Shows every field in each record (AC 55).
Exact match condition
When records must contain an exact equal to be displayed in the query datasheet (AC 70).
The calculation used in a calculated field (AC 75).
Temporarily displays records in a datasheet based on the condition that you specify (AC 57).
Filter By Form
Use when you need to display records that contain one or more values based on the values stored in one or more fields (AC 58).
Filter By Selection
You choose a field value (or part of a field value) in a datasheet, and then click this button in the Sort & Filter group on the Home tab. A menu opens with a list of options (AC 57).
The common field in the related table (AC 66).
After you add two related tables to the query design, this shows the relationship between the tables. It connects the common field used to relate the tables (AC 69).
A field that appears in both tables, has the same data type, and contains the same values (AC 66).
Queries that are based on more than one table. (AC69)
One record in the first table can match many records in the second table. (AC 66)
Selects records that match at least one of two or more conditions in a query.(AC 71)
First table. (AC 66)
A database object that lets you ask about the data it contains. The result is a datasheet that includes the records you asked to see(AC 53)
A condition that you can create which causes a record to be displayed in the query datasheet when the record matches a range of values.(AC 70)
Protects the data in the tables to make sure that data is not accidentally deleted or changed.(AC 66)
The second table in a relationship. (AC 66)
To create a relationship between two tables, you must design the tables so they contain a matching field. (AC 66)
Action to get the results of a query. (AC 65)
Simple query wizard
It asks you what data you want to see in a query by letting you select options in dialog boxes. (AC 56)
Arranges records from A to Z or Z to A.(AC56)
Contains the related records in the Orders table (the related table). (AC 68)
Lets you summarize relevant data, such as adding the field values in a column that stores price data. (AC 55)
When viewing a table or query datasheet you can use this to get a quick count of the number of values in a column. (AC 74)