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

Identify the letter of the choice that best matches the phrase or definition. -Field can contain only monetary data.

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

Identify the letter of the choice that best matches the phrase or definition. -A commonly accepted shorthand representation for showing the structure of a relational database.

To define an additional field in Datasheet view,tap or click the ____________________ column heading,select the data type,and then type the field name.

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.

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.

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

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.

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

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

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

You can create a table in ____.

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

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

-In the accompanying figure,the Book Rep table displays in ____.

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

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

A(n)____________________ contains a specific piece of information within a record.

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

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