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

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

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

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

Discuss the difference between the way Access saves a record and the way Excel saves a row in a worksheet.

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 compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

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

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

In the accompanying figure, ____________________ for the open objects appear at the top of the work area.

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

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

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.

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

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.

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.

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