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

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

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

File names cannot contain a(n)____.

To move a field, click the column heading for the field to be moved to select the field, and then ____________________ the field to the desired position.

A field with a Yes/No data type can store only one of two values.The choices are ____.

____________________ view has more functionality for creating a table than Datasheet view.

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

When Access first creates a database, it automatically creates a table.

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 Add record Navigation button.

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

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

You can create a table in ____.

Table names cannot contain _____.

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

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

The Database Tools tab provides commands to compact and repair a database.