| A | B |
|---|
| Multiple Query | Used to search a database for more than one criteria |
| Delete Query | Used to remove records from a database |
| Sort | Ensures that query results appear in a specific order |
| Append | Adds the results of a query to an existing table in a database |
| >="X" | Numeric criterion to find a specific number that equals, or is larger than, the number inside the quotation marks (where X represents a number) |
| Expression Builder | Displays totals for multiple outcomes; may also sum the values for each outcome |
| And | Comparison operator used to find how many, or to get a total |
| Query | Tool used to locate and save records that meet certain criteria within a database |
| Or | Comparison operator that chooses between two or more fields of data |
| * | Wildcard operator that can search strings of data with more than one operator |
| Query Design View | Query type used to modify an existing query |
| Make Table Query | Used to create a new table from two or more existing tables |
| <= | Operator to find an amount up to and including a given maximum |
| Comparison | Type of operator that enables a user to compare two values in a query criterion |
| Simple query | Allows the user to query a database to find the number of empty seats in a classroom |
| Multiple Operators | Combination of operators that create criteria to find specific data. Examples: <X AND Y OR Z |
| Simple Query View | Like the Datasheet View, shows the results of a query |
| Update | Enables a user to make the same changes to all records satisfying a certain criterion |
| Crosstab Query | Query that subtotals and displays data from multiple groups |
| <=,and | Query operators used to determine how many students in a class failed and assignment and are boys |
