Ch. 3 Access Test Question Preview (ID: 14521)
Review For Ch. 3 Access Question Test For Adv. MOS.
TEACHERS: click here for quick copy question ID numbers.
A(n) ____ query adds a group of records from one table to the end of another table.
a) append
b) action
c) delete
d) duplicate
A _____ field is one in which a user must enter data.
a) required
b) duplicate
c) action
d) default
_________ _____________ make sure that a user's entry falls within a range of values.
a) Validation rules
b) Required rules
c) Action rules
d) Default rules
Access will NOT accept ____ data.
a) invalid
b) valid
c) default
d) all of these
If a required field contains no data, Access will enter _____.
a) an error message
b) a default value
c) an invalid data
d) none of these
A foreign key is a field in one table whose values match the ____ key of another table.
a) primary
b) secondary
c) default
d) action
To affect the way data appears in a field, you can use a ____.
a) format
b) action
c) recovery
d) none of these
____ 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
The property that ensures that the value in a foreign key must match that of another table's primary key is called ____.
a) referential integrity
b) validation text
c) recovery
d) compacting
Changing a column width changes the ____, or design, of a table.
a) layout
b) recovery
c) live database
d) back up
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 14521 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 14521 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register