Shared Flashcard Set

Details

Microsoft Access 2003 Set 6
Concepts and Vocabulary of Access
11
Computer Science
Not Applicable
04/03/2011

Additional Computer Science Flashcards

 


 

Cards

Term
join properties
Definition
the properties that indicate which records appear in a join
Term
calculated field
Definition
a field that can be computed from other fields
Term
name; colon; Field; square brackets
Definition
To include calculated fields in queries, you enter a ____ for the calculated field, a _____, and then the expression in one of the columns in the ____ row.  Any fields included int he expression must be enclosed in _________.
Term
Zoom
Definition
You can type the expression directly into the Field row by selecting the column and using the ____ command on the shortcut menu.
Term
*
Definition
To show multiplication, which symbol would you use?
Term
computed fields
Definition
another name for calculated fields
Term
aggregate function
Definition
function that performs come mathematical function against a group of records
Term
standard deviation
Definition
What does STDEV mean?
Term
variance
Definition
What does VAR mean?
Term
grouping
Definition
creating groups of records that share some common characteristic
Term
crosstab query
Definition
calculates a statistic for data that is grouped by two different types of information
Supporting users have an ad free experience!