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
delete
B
duplicate
C
append
D
action
2) A _____ field is one in which a user must enter data.
A
default
B
action
C
duplicate
D
required
3) _________ _____________ make sure that a user's entry falls within a range of values.
A
Action rules
B
Required rules
C
Validation rules
D
Default rules
4) Access will NOT accept ____ data.
A
valid
B
invalid
C
all of these
D
default
5) If a required field contains no data, Access will enter _____.
A
a default value
B
an error message
C
an invalid data
D
none of these
6) A foreign key is a field in one table whose values match the ____ key of another table.
A
primary
B
secondary
C
action
D
default
7) To affect the way data appears in a field, you can use a ____.
A
action
B
format
C
recovery
D
none of these
8) ____ is a message that will appear if a user violates a validation rule.
A
Recovery text
B
Validation 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
validation text
B
compacting
C
recovery
D
referential integrity
10) Changing a column width changes the ____, or design, of a table.
A
recovery
B
live database
C
layout
D
back up
*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?