Test Android StudyStack App
Please help StudyStack get a grant! Vote here.
Reset Password Free Sign Up

incorrect cards (0)
correct cards (0)
remaining cards (0)
To flip the current card, click it or press the Spacebar key.  To move the current card to one of the three colored boxes, click on the box.  You may also press the UP ARROW key to move the card to the Correct box, the DOWN ARROW key to move the card to the Incorrect box, or the RIGHT ARROW key to move the card to the Remaining box.  You may also click on the card displayed in any of the three boxes to bring that card back to the center.

Pass complete!

Correct box contains:
Time elapsed:
restart all cards

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

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.
Asterisk Represents any collection of characters. (Gr* represents the letters, Gr followed by any collection of characters.
Question mark 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.
OR 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.)
Property sheet 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.
Join Property 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.
Export 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.
Grouping Creating groups of records that share some common characteristics.
Created by: cmccollum on 2013-12-04

Copyright ©2001-2014  StudyStack LLC   All rights reserved.