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