Field whose data type is ____ can contain any characters.
a. Text
b. Lookup
c. Alpha
d. Normal
Field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.
a. Incremental
b. AutoNumber
c. AutoSequence
d. Sequential
Access is a ____.
a. word processing software tool
b. file management system
c. workbook management system
d. database management system
Database ____ refers to the arrangement of data into tables and fields.
a. management
b. relations
c. language
d. design
In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a ____ .
a. repository
b. container
c. placeholder
d. database
In Access, table and field names can be up to ____ characters in length.
a. 32
b. 64
c. 128
d. 255
To back up a database, use the Back Up Database command on the ____ tab in the Backstage view.
a. Save Object As
b. Tools
c. Save & Publish
d. Options
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. Change Field
b. Rename Field
c. Change Column
d. Rename Column
To create a query using the Query Wizard, click ____ on the Ribbon and then click the Query Wizard button.
a. Insert
b. Report
c. New Object
d. Create
To compact and repair a database, click the ___ button in the Information gallery in the Backstage view.
a. Restore
b. Compaction
c. Fix
d. Compact & Repair
To define an additional field in Datasheet view, click the ____ column heading.
a. Blank Field
b. New Field
c. Click to Add
d. Insert Field
To delete a field in a table, right-click the column heading for the field, and then click ____ on the shortcut menu.
a. Delete Column
b. Remove Field
c. Remove Column
d. Delete Field
To import data to a table, click the ____ tab on the Ribbon.
a. File
b. Database Tools
c. External Data
d. Import
To rename a database object, right-click the object in the Navigation Pane and then click ____ on the shortcut menu.
a. Rename
b. Redefine
c. Save Name
d. New Name
You can place an insertion point by clicking in the field or by pressing ____.
a. F3
b. F5
c. F4
d. F2