True/False
Indicate whether the
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.
|
Primary keys uniquely identify records in a table.
|
|
|
3.
|
Every table defined in Access must have a primary key.
|
|
|
4.
|
Redundant fields waste storage space and can result in inconsistent data within
the database.
|
|
|
5.
|
A common field is a field that is defined as a primary key in one table and is
defined as a foreign key in a second table.
|
|
|
6.
|
A field name must be unique within a database.
|
|
|
7.
|
A field defined as an AutoNumber data type cannot serve as a table’s
primary key.
|
|
|
8.
|
Records in a table are stored on disk in the order they are entered but are
displayed in primary key sequence.
|
|
|
9.
|
Certain Access data types have a predefined field size that cannot be
changed.
|
Matching
|
|
|
Identify the letter of the choice that best matches the phrase or
definition. a. | composite key | d. | data type | b. | data
redundancy | e. | entity
integrity | c. | join |
|
|
|
10.
|
When you store the same data in more than one place
|
|
|
11.
|
Determines what field values you can enter for a field
|
|
|
12.
|
Access forces you to enter a value for the primary key in every record
|
|
|
13.
|
The process of relating tables
|
|
|
14.
|
Two or more fields functioning as a primary key
|
|
|
a. | AutoNumber | d. | null value | b. | Yes / No object | e. | Lookup Wizard | c. | OLE
object |
|
|
|
15.
|
You cannot give this to the primary key field
|
|
|
16.
|
Data type that limits field values to on or off
|
|
|
17.
|
Data type that consists of integers with values controlled by Access
|
|
|
18.
|
Data type that allows field values created in other programs as objects
|
|
|
19.
|
Data type that creates a field that lets you find a value in another
table
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
20.
|
The ____ determines what field values are allowed and what other properties the
field will have.
a. | record type | c. | identity | b. | attribute | d. | data type |
|
|
|
21.
|
The maximum size of a Text data type is ___ characters.
|
|
|
22.
|
A primary key ____.
a. | must be numeric | b. | must be defined in each
table | c. | uniquely identifies each record in a table | d. | is always the first
field defined in a table |
|
|
|
23.
|
A table can be logically connected to another table by defining a ____.
a. | common field | c. | primary key | b. | foreign key | d. | hyperlink |
|
|
|
24.
|
Storing the same data field in multiple tables is called data ____.
a. | reliance | c. | networking | b. | interdependence | d. | redundancy |
|
|
|
25.
|
If a primary key from one table is also defined in a second table to form a
relationship, the field is called a ____ in the second table.
a. | hyperlink | c. | foreign key | b. | composite key | d. | redundant field |
|
|
|
26.
|
The characteristics of a field, such as name, size, and type, are called the
field ____.
a. | properties | c. | values | b. | traits | d. | qualities |
|
|
|
27.
|
You can include a graphic file in an Access database by defining a field of type
____.
a. | Hyperlink | c. | OLE Object | b. | Picture | d. | Memo |
|
|
|
28.
|
Which view would you select if you wanted to define a table yourself from start
to finish?
a. | Design view | c. | Layout view | b. | Database view | d. | Datasheet view |
|
|
|
29.
|
You can select multiple fields to make up a primary key by holding down the ____
key and clicking the row selectors for the desired fields.
|
|
|
30.
|
If you make a mistake when entering data in a field, you can erase the
characters to the left of the insertion point by pressing the ____ key.
a. | left arrow | c. | Delete | b. | Tab | d. | Backspace |
|
|
|
31.
|
You can modify an existing table's structure in ____.
a. | the Database window | c. | Design view | b. | Form view | d. | the Properties
area |
|
|
|
32.
|
To change the way your data is displayed in a field, you can change the
field's ____.
a. | description | c. | current record indicator | b. | Format
property | d. | Edit
value |
|
|
|
33.
|
Records can be copied and pasted into one table from another table if the tables
have ____.
a. | a common field | c. | two or more similar fields | b. | a primary
key | d. | the same table
structure |
|
|
|
34.
|
Calculations performed using the ____ data type are not subject to round-off
error.
a. | Memo | c. | Currency | b. | Number | d. | Decimal |
|
|
|
35.
|
The default table name assigned to a new table is ____.
a. | TableNew | c. | NewTable | b. | 1Table | d. | Table1 |
|
|
|
36.
|
Using the Number data type for the field of Country Population in a database,
with characteristics of the lowest data value starting at over 1 million and the highest at 2
billion, set the Field Size Property to _____.
a. | Byte | c. | Long Integer | b. | Integer | d. | Single |
|
|
|
37.
|
Elsa is creating the Supplier Location field, which includes major companies and
their Web site addresses. What data type should she use for this field?
a. | Text | c. | OLE object | b. | Memo | d. | Hyperlink |
|
|
|
38.
|
For unique Employee IDs such as 34A78C, use the _____ data type.
a. | AutoNumber | c. | Text | b. | Number | d. | both band c |
|
|
|
39.
|
When you right-click a row selector in Design view, Access will display a
____.
a. | warning message | c. | ToolTip | b. | Help system menu | d. | shortcut menu |
|
|
|
40.
|
To enter the picture of each customer in a new field called Picture, use the
_____ data type.
a. | Hyperlink | c. | OLE object | b. | Memo | d. | Text |
|
|
|
|
|
|
41.
|
In the figure above, the arrow labeled 1 is pointing to the ____.
a. | record selector | c. | field properties selector | b. | Table Design
grid | d. | Field Properties
pane |
|
|
|
42.
|
In the figure above, the arrow labeled 2 is pointing to the ____.
a. | key symbol indicating the table’s primary key | b. | Field Properties
pane | c. | Table Design grid | d. | none of the
above |
|
|
|
43.
|
In the figure above, the arrow labeled 3 is pointing to the ____.
a. | Design view button | c. | Layout view button | b. | Datasheet view button | d. | Print Preview
button |
|
|
|
44.
|
In the figure above, the arrow labeled 4 is pointing to the button used to
____.
a. | remove a field as primary key | c. | specify the composite
key | b. | specify the primary key | d. | all of the above |
|
Completion
Complete each
statement.
|
|
|
45.
|
You create a database by first identifying the ____________________ that will be
required for processing.
|
|
|
46.
|
Database ____________________ is the process of determining the fields, tables,
and relationships that will be required to organize the data.
|
|
|
47.
|
The characteristics of a field that determine how it is stored and displayed are
called the field ____________________.
|
|
|
48.
|
If no one field can be used to make each record unique, you can use a(n)
____________________ as the primary key.
|
|
|
49.
|
The ____________________ data type is best used for fields that will be used in
mathematical calculations (except those involving money), or for numeric values that require a high
degree of accuracy.
|
|
|
50.
|
The process of relating tables is often called performing a(n)
____________________ .
|