True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
When
designing a database, the first thing you should do is to identify the fields that will be
required.
|
|
|
2.
|
A
primary key that consists of more than one field is called a composite key.
|
|
|
3.
|
A
field in one table that establishes a relationship to another table is called a redundant
field.
|
|
|
4.
|
Experienced users of databases typically avoid extremely long field names because they
are difficult to remember and use.
|
|
|
5.
|
Records in a table are stored on disk in the order they are entered but are displayed
in primary key sequence.
|
|
|
6.
|
A
primary key is allowed to have a null value.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
7.
|
It
would be wasteful to use the Long Integer setting when defining a field that will only store whole
numbers ranging from 0 to 255, because the Long Integer setting will use ____ bytes of storage
space.
|
|
|
8.
|
The
name of any object defined in an Access database can have a maximum length of ____
characters.
|
|
|
9.
|
As
you define fields, the default data type, ____, appears highlighted in the Data Type text
box. a. | Memo | b. | Text | c. | Number | d. | Date/Time | | |
|
|
|
Figure 2-10
|
|
|
10.
|
Figure 2-10 shows that the current (EmployerID) field is currently
____. a. | not required and
is a number field | b. | required and is a text field | c. | not required and
is a text field | d. | required and is a number field | | |
|
|
|
11.
|
When
you right-click a row selector in Design view, Access will display a ____. a. | warning
message | b. | Help system menu | c. | ToolTip | d. | shortcut menu | | |
|
|
|
12.
|
The
number of databases you can have open at one time is ____. a. | controlled by
the data administrator | b. | one | c. | limited by the amount of memory
available | d. | specified in the Preferences dialog
box | | |
|
Essay
|
|
|
13.
|
Bonus:
|