Computer Information Systems Access Ch. 2 - Querying a Database
About this set
Created by:
davidhuddleston1 on May 30, 2011
Subjects:
cis1a computer information systems
Description:
Querying a Database
Log in to favorite or report as inappropriate.
Order by
23 terms
Terms | Definitions |
|---|---|
 Query | Is simply a question presented in a way that Access can process. |
| 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 characters. |
| 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 must satisfy. |
| 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. |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.