Access Query Questions: Question Preview (ID: 3922)

Below is a preview of the questions contained within the game titled ACCESS QUERY QUESTIONS: Access 2007 Tutorial 3 .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.

____ fields can be unique or nonunique.
a) Primary Key b) Sort c) Cascading d) Foreign Key
A lengthy or complicated expression will normally be too large to be shown in its entirety in the ___ text box.
a) Show b) Criteria c) Field d) Expression
A selection conditon that dictates that the value in the specified field must precisely match the condition is known as a(n) ___ match.
a) specific b) exact c) selection d) value
A temporary subset of selected records can be created by defining a ____.
a) hyperlink b) filter c) screen d) report
Access saves changes to field values automatically when you ___.
a) move the insertion point to a new field b) move the insertion point to another record c) close the table d) all of the above
After applying a filter, you can click the ___ button to toggle between filter and nonfiltered displays.
a) Run b) View all c) Remove filter d) Toggle filter
Before you can click a sort button on the toolbar to sort the data, you must first ___.
a) determine the primary key b) click the view buttons c) select a column on which to base the sort d) save the query
Filter By ___ is a simple technique for filtering records that lets you select all or part of a field value.
a) Design b) Aggregate c) Selection d) Form
Generalized queries that specify fields and records to be selected are called ___ queries.
a) simple b) select c) criteria d) normal
If a recond in one table matches several records in a related table, the relationship is called a(n) ___ relationship.
a) consistent b) one-to-many c) many-to-one d) nonunique
Play Games with the Questions above at
To play games using the questions from the data set above, visit and enter game ID number: 3922 in the upper right hand corner at or simply click on the link above this text.

Log In
| Sign Up / Register