Ch. 3 Access Test: Question Preview (ID: 14521)

Below is a preview of the questions contained within the game titled CH. 3 ACCESS TEST: Review For Ch. 3 Access Question Test For Adv. MOS .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]

Play games to reveal the correct answers. Click here to play a game and get the answers.

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
To play games using the questions from the data set above, visit and enter game ID number: 14521 in the upper right hand corner at or simply click on the link above this text.

Log In
| Sign Up / Register