Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Access Query Questions
Test Description: Access 2007 Tutorial 3
Instructions: Answer all questions to get your test result.
1) ____ fields can be unique or nonunique.
A
Cascading
B
Primary Key
C
Sort
D
Foreign Key
2) A lengthy or complicated expression will normally be too large to be shown in its entirety in the ___ text box.
A
Field
B
Criteria
C
Expression
D
Show
3) A selection conditon that dictates that the value in the specified field must precisely match the condition is known as a(n) ___ match.
A
value
B
exact
C
selection
D
specific
4) A temporary subset of selected records can be created by defining a ____.
A
screen
B
filter
C
report
D
hyperlink
5) Access saves changes to field values automatically when you ___.
A
move the insertion point to another record
B
close the table
C
move the insertion point to a new field
D
all of the above
6) After applying a filter, you can click the ___ button to toggle between filter and nonfiltered displays.
A
View all
B
Toggle filter
C
Run
D
Remove filter
7) Before you can click a sort button on the toolbar to sort the data, you must first ___.
A
select a column on which to base the sort
B
determine the primary key
C
click the view buttons
D
save the query
8) Filter By ___ is a simple technique for filtering records that lets you select all or part of a field value.
A
Design
B
Form
C
Aggregate
D
Selection
9) Generalized queries that specify fields and records to be selected are called ___ queries.
A
criteria
B
normal
C
simple
D
select
10) If a recond in one table matches several records in a related table, the relationship is called a(n) ___ relationship.
A
nonunique
B
one-to-many
C
consistent
D
many-to-one
*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?