Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Ch. 3 Access Test
Test Description: Review for Ch. 3 Access question Test for Adv. MOS
Instructions: Answer all questions to get your test result.
1) A(n) ____ query adds a group of records from one table to the end of another table.
A
duplicate
B
delete
C
append
D
action
2) A _____ field is one in which a user must enter data.
A
required
B
default
C
duplicate
D
action
3) _________ _____________ make sure that a user's entry falls within a range of values.
A
Required rules
B
Action rules
C
Validation rules
D
Default rules
4) Access will NOT accept ____ data.
A
invalid
B
default
C
valid
D
all of these
5) If a required field contains no data, Access will enter _____.
A
a default value
B
an invalid data
C
none of these
D
an error message
6) A foreign key is a field in one table whose values match the ____ key of another table.
A
default
B
secondary
C
action
D
primary
7) To affect the way data appears in a field, you can use a ____.
A
action
B
recovery
C
none of these
D
format
8) ____ is a message that will appear if a user violates a validation rule.
A
Validation text
B
Recovery text
C
Default text
D
Secondary text
9) The property that ensures that the value in a foreign key must match that of another table's primary key is called ____.
A
compacting
B
validation text
C
referential integrity
D
recovery
10) Changing a column width changes the ____, or design, of a table.
A
back up
B
recovery
C
layout
D
live database
*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?