True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
Access is a database program.
|
|
|
2.
|
The Access screen is similar to other Office 2007 applications.
|
|
|
3.
|
You can open multiple databases at a time in an Access window.
|
|
|
4.
|
Objects are organized into categories in the Navigation Pane.
|
|
|
5.
|
When you create a new database, the first step is to name the database
file.
|
|
|
6.
|
You cannot use the Save As command to name and save objects in the
database.
|
|
|
7.
|
You can create as many tables as you need to store the information for a
database.
|
|
|
8.
|
You can only add fields in Design view.
|
|
|
9.
|
Unlike Word and Excel, Access does not have a standard document view.
|
|
|
10.
|
Once you have deleted a record, you can use the Undo command to restore
it.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
11.
|
A ____ is an object that stores data in columns and rows.
a. | table | c. | report | b. | form | d. | query |
|
|
|
12.
|
A ____ makes it easy for you to view, enter, and edit data in a table.
a. | table | c. | report | b. | form | d. | query |
|
|
|
13.
|
A ____ finds and shows data that meet a specified criteria.
a. | table | c. | report | b. | form | d. | query |
|
|
|
14.
|
The ____ is useful in sorting records, and it prevents duplicate entries.
a. | primary key | c. | datasheet | b. | field name | d. | field |
|
|
|
15.
|
In ____ view, the table looks much like a spreadsheet.
a. | Design | c. | Field | b. | Datasheet | d. | Print |
|
|
|
16.
|
____ is the shortcut for creating a new blank database.
a. | Ctrl+D | c. | Ctrl+B | b. | Ctrl+N | d. | Ctrl+A |
|
|
|
17.
|
The ____ determines what type of data the field can store, such as text or
numbers.
a. | record | c. | data type | b. | field name | d. | field
properties |
|
|
|
18.
|
____ define the characteristics and behavior of a field, such as the number of
characters allowed.
a. | Data types | c. | Entries | b. | Primary keys | d. | Field
properties |
|
|
|
19.
|
When you work in ____ view, the changes are saved as they are made.
a. | Design | c. | Datasheet | b. | Form | d. | Report |
|
|
|
20.
|
Access stores cut or copied text in the ____.
a. | Navigation Pane | c. | field | b. | Clipboard | d. | entry |
|
|
|
21.
|
____ is the illegal copying or use of programs.
a. | Intellectual property | c. | Shareware | b. | The Copyright Act | d. | Software piracy |
|
|
|
22.
|
____ is software that can be accessed for free.
a. | Software piracy | c. | The honor system | b. | Shareware | d. | Intellectual
property |
|
|
|
23.
|
The ____ key moves the insertion point to the next field.
a. | Home | c. | Tab | b. | End | d. | Up arrow |
|
|
|
24.
|
The Next record button is located in the ____.
a. | Navigation pane | c. | Ribbon | b. | Navigation bar | d. | Status bar |
|
|
|
25.
|
The default data type for a field is ____.
a. | Number | c. | Currency | b. | Text | d. | Yes/No |
|
|
|
26.
|
The Blank Database button is located in the ____.
a. | Home tab on the Ribbon | c. | Navigation pane | b. | Create tab on the Ribbon | d. | Getting Started with Microsoft Office Access
window |
|
|
|
27.
|
Fields appear as columns, and each column has a ____.
a. | datasheet | c. | field name | b. | record | d. | primary key |
|
|
|
28.
|
The ____ key moves the insertion point to the first field in the current
record.
a. | Home | c. | Up arrow | b. | End | d. | Down arrow |
|
|
|
FIGURE 22-1 
|
|
|
29.
|
What is the arrow pointing to in Figure 22-1 above?
a. | Status bar | c. | Restore Down button | b. | Vertical scroll box | d. | Shutter Bar Open/Close
button |
|
|
|
FIGURE 22-2 
|
|
|
30.
|
Which view is displayed in Figure 22-2 above?
a. | Datasheet | c. | Table | b. | Format | d. | Design |
|
|
|
Case 22-1
Dana has just been hired to create and maintain a database
for a local sports organization. The organization has several different sports with many teams and
divisions. She is creating the database in Design view.
|
|
|
31.
|
What setting will allow Dana to change the number of characters allowed in a
field?
a. | Primary key | c. | Field properties | b. | Field name | d. | Data type |
|
|
|
32.
|
If Dana doesn’t save the table in Design view and switches to Datasheet
view, what will happen?
a. | She will lose all the data in the table. | b. | She will be prompted
to save the table. | c. | Nothing. Access saves automatically in Design
view. | d. | The database will be closed and all data will be
lost. |
|
|
|
Case 22-2
Jamir works for a distribution company and has taken over
responsibility of the customer database. He has several changes to make to it in order to update the
information.
|
|
|
33.
|
To remove a table field and all the data for the field, Jamir should delete the
____.
a. | column | c. | field name | b. | record | d. | entry |
|
|
|
34.
|
Jamir needs to delete a record. He needs to select it and press ____ to remove
the data.
a. | Undo | c. | the Delete key | b. | Redo | d. | the Enter key |
|
Matching
|
|
|
Identify the letter of the choice that best matches the phrase or
definition.
a. | table | b. | field | c. | field
name | d. | record | e. | primary key |
|
|
|
35.
|
A single piece of database information.
|
|
|
36.
|
A unique identifier for each record in the table.
|
|
|
37.
|
A group of related fields in a database.
|
|
|
38.
|
The primary object in the database.
|
|
|
39.
|
A label that helps identify the field.
|