Comp tech Access Chapter 1

A field whose data type is ____ can contain any characters.

text

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

database

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.

rename field

In the accompanying figure, the key symbol that appears in the row selector for the Business Analyst Number field indicates that Business Analyst Number is the ____for the table.

primary key

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

external data

One way to create a table, is to click _____ on the Ribbon and then click the Table button.

Create

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

Click to add

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

Delete column

To save the changes to the layout of a table, click the Save button on the ___

data field

To change the design of a query, right-click the query in the Navigation Pane and then click ___ on the shortcut menu.

Design View

To create an initial report that can be modified in Layout view, click ____ on the Create tab.

report

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

compact and repair

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

save and public

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

rename

Access is a

database management system

A(n)____ contains information about a given person, product, or event.

Record

___ words are words that have a special meaning to Access and cannot be used for the names of fields.

Reserved

In Access, table and field names can be up to____characters in length.

64