Ch. 2 Access Test Question Preview (ID: 14196)


Ch. 2 Access Test For Adv. MOS. TEACHERS: click here for quick copy question ID numbers.

The following is NOT a comparison operator:
a) equal to
b) less than
c) greater than
d) greater than or equal to

In an _____ criterion, each individual criterion must be true in order for the compound criterion to be true.
a) AND
b) OR
c) either AND or OR
d) neither AND or OR

When you sort data,
a) duplicates are normally included
b) duplicates are not normally included
c) duplicates are deleted
d) none of these

To eliminate duplicates change the Unique Values property from
a) No to Yes
b) Yes to No
c) True to False
d) False to True

Access will draw a line, called a ____ line, between matching fields in the two tables indicating that they are related.
a) join
b) connect
c) match
d) relate

A field that can be computed from another field is called a ____ field.
a) calculated
b) mathematical
c) numerical
d) addition

An ___ function performs some mathematical function against a group of records.
a) aggregate
b) calculated
c) addition
d) relational

____ means creating groups of records that share some common characteristic.
a) Grouping
b) Crosstab
c) Joining
d) Sorting

____ queries are useful for summarizing data.
a) Crosstab
b) Grouped
c) Sorted
d) Calculated

____ indicate which records appear in a join.
a) Join properties
b) Connect properties
c) Grouped properties
d) Crosstab properties

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 14196 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links