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

Below is a preview of the questions contained within the game titled CH. 2 ACCESS TEST: Ch. 2 Access Test For Adv. MOS .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]

Play games to reveal the correct answers. Click here to play a game and get the answers.

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
To play games using the questions from the data set above, visit and enter game ID number: 14196 in the upper right hand corner at or simply click on the link above this text.

Log In
| Sign Up / Register