CBA: Access-Ch. 2
Terms and Definitions for Access Chapter 2
|Query ||A question presented in a way that Access can process.|
|Queries ||Questions to which the answers are in the database.|
|Text data ||Data in a field whose data is text.|
|Wildcards ||Symbols that represent any character or combination of characters.|
||Represents any collection of characters. (Gr* represents the letters, Gr followed by any collection of characters.|
||Represents any individual character. (T?m represents the letter T, followed by any single character, followed by the letter, m—Tim or Tom.|
|Parameter query ||A query that prompts for input whenever it is used.
|Comparison operator ||Used when you want something other than the exact match. They are > greater than, < less than, >= greater than or equal to, <= less than or equal to.|
|Compound criterion ||Data that you are searching for that must meet more than one criterion.
||Is true provided either individual criterion is true. (Just one criterion has to be true.)|
|AND criterion ||Each individual criterion must be true in order for the compound criterion to be true. (Both must be true.)
|AND operator ||Used when you want to create a criterion involving a range of values in a single field. (All clients whose amount paid is >= $1,000 and <=$4,000.)
|BETWEEN operator ||Used to select values in a given range. (All clients whose amount paid is between $1,000 and $4,000.)
|Sort key ||The field or fields on which the records are sorted.|
|Primary sort key ||The major key which is the more important field and is on the left.
|Secondary sort key ||The minor key and the less important field and is on the right.|
|IN operator ||Used to select values in a list. (Used to find clients whose business analyst number is 11 or 14.)
||A window containing the various properties of the object.|
|Top-values query ||Allows you to quantify the results such as showing only a specified number of records or a percentage of records in a query.
|Join line ||A line drawn by Access between matching fields in the two tables, indicating that the tables are related.
|Join ||Find records in two tables that have identical values in matching fields.
||The properties that indicate which records appear in a join.|
|Form ||Is a formatted document with fields that contain data. Forms allow you to view and maintain data.
||Copy data from an Access database so that another application can use the data.|
|Delimited files ||Each record is on a separate line.
|Delimiter ||The files are separated by a special character such as tabs, semicolons, commas, and spaces.|
|Fixed-width files ||The width of any field is the same on every record.|
|Calculated field ||A field that can be computed from other fields. (Also called computed field.)|
|Aggregate function ||A function that performs some mathematical functions against a group of records.|
Creating groups of records that share some common characteristics.|