Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Ch. 2 Access Test
Test Description: Ch. 2 Access Test for Adv. MOS
Instructions: Answer all questions to get your test result.
1) The following is NOT a comparison operator:
A
less than
B
greater than or equal to
C
equal to
D
greater than
2) In an _____ criterion, each individual criterion must be true in order for the compound criterion to be true.
A
OR
B
neither AND or OR
C
AND
D
either AND or OR
3) When you sort data,
A
duplicates are not normally included
B
none of these
C
duplicates are deleted
D
duplicates are normally included
4) 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
5) Access will draw a line, called a ____ line, between matching fields in the two tables indicating that they are related.
A
connect
B
relate
C
match
D
join
6) A field that can be computed from another field is called a ____ field.
A
mathematical
B
calculated
C
addition
D
numerical
7) An ___ function performs some mathematical function against a group of records.
A
addition
B
calculated
C
relational
D
aggregate
8) ____ means creating groups of records that share some common characteristic.
A
Sorting
B
Joining
C
Grouping
D
Crosstab
9) ____ queries are useful for summarizing data.
A
Crosstab
B
Calculated
C
Sorted
D
Grouped
10) ____ indicate which records appear in a join.
A
Grouped properties
B
Join properties
C
Crosstab properties
D
Connect properties
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?