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
Primary Key
B
Sort
C
Foreign Key
D
Cascading
2) A lengthy or complicated expression will normally be too large to be shown in its entirety in the ___ text box.
A
Expression
B
Criteria
C
Show
D
Field
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
specific
B
value
C
exact
D
selection
4) A temporary subset of selected records can be created by defining a ____.
A
report
B
filter
C
screen
D
hyperlink
5) Access saves changes to field values automatically when you ___.
A
move the insertion point to a new field
B
all of the above
C
move the insertion point to another record
D
close the table
6) After applying a filter, you can click the ___ button to toggle between filter and nonfiltered displays.
A
Remove filter
B
Run
C
View all
D
Toggle filter
7) Before you can click a sort button on the toolbar to sort the data, you must first ___.
A
click the view buttons
B
determine the primary key
C
select a column on which to base the sort
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
Selection
B
Aggregate
C
Design
D
Form
9) Generalized queries that specify fields and records to be selected are called ___ queries.
A
select
B
normal
C
simple
D
criteria
10) If a recond in one table matches several records in a related table, the relationship is called a(n) ___ relationship.
A
many-to-one
B
consistent
C
nonunique
D
one-to-many
*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?