Field whose data type is ____ can contain any characters.

AText
BLookup
CAlpha
DNormal


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.

AIncremental
BAutoNumber
CAutoSequence
DSequential

Access is a ____.

Aword processing software tool
Bfile management system
Cworkbook management system
Ddatabase management system

Database ____ refers to the arrangement of data into tables and fields.

Amanagement
Brelations
Clanguage
Ddesign

In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a ____ .

Arepository
Bcontainer
Cplaceholder
Ddatabase

In Access, table and field names can be up to ____ characters in length.

A32
B64
C128
D255

To back up a database, use the Back Up Database command on the ____ tab in the Backstage view.

ASave Object As
BTools
CSave & Publish
DOptions

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.

AChange Field
BRename Field
CChange Column
DRename Column

To create a query using the Query Wizard, click ____ on the Ribbon and then click the Query Wizard button.

AInsert
BReport
CNew Object
DCreate

To compact and repair a database, click the ___ button in the Information gallery in the Backstage view.

ARestore
BCompaction
CFix
DCompact & Repair

To define an additional field in Datasheet view, click the ____ column heading.

ABlank Field
BNew Field
CClick to Add
DInsert Field

To delete a field in a table, right-click the column heading for the field, and then click ____ on the shortcut menu.

ADelete Column
BRemove Field
CRemove Column
DDelete Field

To import data to a table, click the ____ tab on the Ribbon.

AFile
BDatabase Tools
CExternal Data
DImport

To rename a database object, right-click the object in the Navigation Pane and then click ____ on the shortcut menu.

ARename
BRedefine
CSave Name
DNew Name

You can place an insertion point by clicking in the field or by pressing ____.

AF3
BF5
CF4
DF2