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