True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Queries created in Access can select data from only one table at a time.
|
|
|
2.
|
In
Design view, the Select Query window contains the standard title bar, menu bar, status bar, and the
Query Design toolbar.
|
|
|
3.
|
One
way to transfer all the fields from the field list to the design grid is to double-click the asterisk
in the field list; the advantage of using this method is that changes to the table structure are
reflected automatically in the query.
|
|
|
4.
|
Multiple selection conditions can be specified in a query by using relational
operators.
|
|
|
5.
|
Aggregate functions perform arithmetic and statistical operations on selected
records.
|
|
|
6.
|
Selected records can be divided into groups based on values in a specified field by
using the Group By operator.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
7.
|
A
query can be run at any time during the creation of the query by clicking the ____ button on the
Query Design toolbar. a. | Display | b. | Show | c. | View | d. | Query | | |
|
|
|
8.
|
When
two tables are related, data can be extracted from both tables using one query even though the tables
are ____. a. | both primary
tables | b. | both related tables | c. | separate | d. | unique | | |
|
|
|
9.
|
The
cascade deletes option ____. a. | deletes all records in a related
table | b. | deletes all records in a primary
table | c. | deletes all matching records in a related table when a record
is deleted from the primary table | d. | is automatically activated when a relationship is
created | | |
|
|
|
10.
|
To
use the sort buttons on the toolbar to sort a query with multiple sort keys, the sort keys must be
____. a. | unique | b. | consistent | c. | adjacent | d. | primary keys | | |
|
|
|
11.
|
A
selection condition 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 | | |
|
|
|
12.
|
The
____ operator is a comparison operator that allows you to check whether or not a particular field
value is part of a list of values. a. | Like | b. | Between | c. | In | d. | List | | |
|
Essay
|
|
|
13.
|
Bonus:
|