Is simply a question presented in a way that Access can
Are simply questions, the answers to which are in the database.
Which is a condition that the records to be included must satisfy.
Data in a fi eld whose data type is Text.
Are symbols that represent any character or combination of
One common wildcard.
Another wildcard symbol.
Which is a query that prompts for input whenever it is used.
The comparison operators are > (greater than), < (less than), >= (greater than or equal to), <= (less than or equal to), and NOT (not equal to).
One criterion that the data for which you are searching
Each individual criterion must be true in order for the compound
criterion to be true.
Is true provided either individual criterion is true.
To order the records in the answer to a query in a particular way.
The field or fi elds on which the records are sorted.
also calledthe primary sort key) and the less important field (Amount Paid) is called the minor key
(also called the secondary sort key).
Less important field (Amount Paid) is called the minor key.
Is a window containing
the various properties of the object.
Allows you to quantify the results.
To find records in the two tables that have identical values in matching fields.
Access will draw a line between matching fields in the two tables indicating that the tables are related.
which are the properties that indicate which records appear in a join, of the query, as
in the following steps.
An individual record calculation.
a function that performs some mathematical function against a group of records.