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