Access chapter 1

False

A field that has the Calculated data type can store a unique sequential number that Access assigns to a record.

Short Text

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

OLE Object

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

Attachment

A field whose data type is ____ can store text that can be used as a hyperlink address.

Attachment

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

AutoNumber

A 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.

True

A unique identifier also is called a primary key. T/F

Record

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

Long Text

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

False

As shown in the accompanying figure, you can move to the end of a table to a position for entering a new record by clicking the Insert record Navigation button. T/F

False

As shown in the accompanying figure, you can move to the first record in a table by clicking the Start record Navigation button. T/F

True

As shown in the accompanying figure, you can use the Last record button to move to the last record in the table. T/F

False

Changing the column width in a datasheet changes the structure of a table. T/F

True

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship. T/F

True

Form view displays a single record at a time. T/F

False

In Access, field names cannot contain digits.

64

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

False

In Access, the columns in a table are called records. T/F

False

In Datasheet view, a table is represented as a collection of rows and columns called a list.

Relational

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

Primary Key

In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.

Row Selector

In the accompanying figure, the small box or bar to the left of each field is called the ____.

True

Layout view shows a report on the screen and allows the user to make changes to the report. T/F

True

Redundancy means storing the same fact in more than one place.

True

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

False

The AutoError Correction feature of Access corrects common data entry errors. T/F

False

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

True

The Currency data type is used for fields that contain only monetary data.

False

The DATABASE TOOLS tab provides commands to save a database with another name.

True

The Navigation Pane contains a list of all the objects in the database. T/F

True

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

New (blank)

To add a record to a table, tap or click the ____ record button.

Back Up Database

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

Design View

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

True

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu. T/F

Rename Field

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

Landscape

To change the print orientation from portrait to landscape, tap or click the ____ button on the PRINT PREVIEW tab.

Compact & Repair

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

Create

To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button

Report

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

Click to Add

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

Delete

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

Delete Field

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

False

To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu.

Delete

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).

Close

To exit Access, tap or click the ____ button on the right side of the title bar.

External Data

To import data to a table, tap or click the ____ tab on the ribbon.

False

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click Insert Column on the shortcut menu.

False

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click Insert Column on the shortcut menu. T/F

Insert Field

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.

Design View

To open a table in Design view, press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu

Shutter Bar Open/Close

To open the Navigation Pane, tap or click the ____ Button.

False

To preview and then print the contents of a table, use Table Preview. T/F

False

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation. T/F

Rename

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

Quick Access Toolbar

To save the changes to the layout of a table, tap or click the Save button on the ____.

Options

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

Undo

To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.

Open

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

Access

What is a database management system.

True

When Access first creates a database, it automatically creates a table. T/F

Caption

When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

ID

When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.

F2

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