True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
A
single set of field values within a table is a record.
|
|
|
2.
|
A
database is a collection of related tables.
|
|
|
3.
|
Although a field has unique values in the table in which it is the primary key, it
does not have to have unique values in the table in which it is the foreign key.
|
|
|
4.
|
Query
results automatically are stored in the database.
|
|
|
5.
|
Records in a database can be displayed in a custom format by creating a
form.
|
|
|
6.
|
By
defining a report, you can create a formatted printout or display of the data contained in one or
more tables.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
7.
|
If
you close a database while the query results are displayed, what happens to the
results? a. | They are saved
with the database. | b. | They are saved in a temporary file associated with the
database. | c. | A dialog box opens and asks if you want to save changes to the
query design. | d. | This is a setting determined by the
user. | | |
|
|
|
8.
|
You
can open any Access object by using the ____ button in the Database window. a. | New | b. | Object | c. | Find | d. | Open | | |
|
|
|
9.
|
The
first step in organizing data into a database is to define the ____. a. | records | b. | formats | c. | fields | d. | reports | | |
|
|
|
10.
|
The
three basic steps to creating a database, in order, are: ____. a. | group fields in
a table, identify individual fields, enter field values for each record | b. | identify the
individual fields, group fields in a table, enter field values for each
record | c. | enter field values for each record, group fields in a table,
identify individual fields | d. | group fields in a table, identify the individual fields, enter
field values for each record | | |
|
|
|
11.
|
Which
of the following could be defined as a field in a database? a. | Customer
Name | b. | Order
Number | c. | Phone Number | d. | All of the
above | | |
|
|
|
12.
|
Every
foreign key must ____. a. | be unique | b. | be
numeric | c. | match the field value of a primary key in a related
table | d. | be defined in all tables within the
database | | |
|
|
|
13.
|
You
must first open a table in order to ____ data in that table. a. | view | b. | update | c. | add | d. | All of the above | | |
|
|
|
14.
|
Diane
is working in the customer table and needs to know if any customers are located in Texas. To find
this information, she would ____. a. | define a new table | b. | create a
query | c. | define a new form | d. | access the
Database Wizard | | |
|