Multiple Choice Identify the
choice that best completes the statement or answers the question.
|
|
1.
|
Access is a ____.
a. | word processing software tool | c. | workbook management
system | b. | file management system | d. | database management system |
|
|
2.
|
A(n) ____ contains information about a given person, product, or event.
a. | attribute | c. | field | b. | record | d. | column |
|
|
3.
|
Database ____ refers to the arrangement of data into tables and fields.
a. | language | c. | design | b. | relations | d. | management |
|
|
4.
|
A field whose data type is ____ can contain any characters.
a. | Alpha | c. | Normal | b. | Text | d. | Lookup |
|
|
5.
|
In Access, all the tables, reports, forms, and queries that are created are
stored in a single file called a ____ .
a. | container | c. | placeholder | b. | repository | d. | database |
|
|
6.
|
When you create a table in Datasheet view, Access automatically adds a field
called ____ as the first field in the table.
a. | Field1 | c. | AutoCode | b. | ID | d. | TableCode |
|
|
7.
|
To undo the most recent change to a table structure, click the ____ button on
the Quick Access Toolbar.
a. | Cancel | c. | Back | b. | Escape | d. | Undo |
|
|
8.
|
To delete a field in a table, right-click the column heading for the field, and
then click ____ on the shortcut menu.
a. | Delete Field | c. | Delete Column | b. | Remove Field | d. | Remove Column |
|
|
9.
|
To change the name of a field, right-click the column heading for the field,
click ____ on the shortcut menu, and then type the desired field name.
a. | Rename Field | c. | Change Field | b. | Rename Column | d. | Change Column |
|
|
10.
|
To insert a field between existing fields, right-click the column heading for
the field that will follow the new field, and then click ____ on the shortcut menu.
a. | Insert Field | c. | Add Field | b. | Insert Column | d. | Add Column |
|
|
11.
|
To open a table in Design view, right-click the table in the Navigation Pane and
then click ____ on the shortcut menu
a. | Table Design | c. | Structure View | b. | Design View | d. | Layout View |
|
|
12.
|
To delete a record, click the record selector for the record, and then press the
____ key(s).
a. | CTRL+DELETE | c. | DELETE | b. | CTRL+Y | d. | CTRL+K |
|
|
13.
|
To change the print orientation from portrait to landscape, click the ____
button on the Print Preview tab.
a. | Portrait/Landscape | c. | Landscape | b. | Orientation | d. | Switch
Orientation |
|
|
14.
|
To import data to a table, click the ____ tab on the Ribbon.
a. | Database Tools | c. | Import | b. | File | d. | External Data |
|
|
15.
|
To open the Navigation Pane, click the ____ Button.
a. | Open Navigation Pane | c. | Open Pane | b. | Shutter Bar Open/Close | d. | Navigation Bar
Show/Hide |
|
|
16.
|
To create a query using the Query Wizard, click ____ on the Ribbon and then
click the Query Wizard button.
a. | Insert | c. | Create | b. | New Object | d. | Report |
|
|
17.
|
To change the design of a query, right-click the query in the Navigation Pane
and then click ____ on the shortcut menu.
a. | Open | c. | SQL | b. | Query Window | d. | Design View |
|
|
18.
|
To create an initial report that can be modified in Layout view, click ____ on
the Create tab.
a. | Layout | c. | Report Layout | b. | Report | d. | Simple Report |
|
|
19.
|
To compact and repair a database, click the ___ button in the Information
gallery in the Backstage view.
a. | Restore | c. | Compaction | b. | Fix | d. | Compact &
Repair |
|
|
20.
|
To back up a database, use the Back Up Database command on the ____ tab in the
Backstage view.
a. | Save Object As | c. | Tools | b. | Save & Publish | d. | Options |
|