Exam 4: Access: Databases and Database Objects: an Introduction

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

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.

One way to undo changes to a field is to click the Undo button on the status bar.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -Field can store a unique sequential number that Access assigns to the record.

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

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

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

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

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.

The Short Text data type replaces the ____________________ data type in previous editions of Access.

-In the accompanying figure,the words Datasheet View at the lower left of the screen appear on the ____________________.

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

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -View that shows a report as it will appear when printed.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -Field can contain any characters and the total numbers of characters cannot exceed 255.

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

The Access window consists of a variety of components.These include the ____.

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

____________________ refers to the process of determining the tables and fields that make up the database.

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.