Exam 2: Databases and Database Objects: an Introduction

Access is a ____.

Form view displays a single record at a time.

____________________ refers to the arrangement of data into tables and fields.

To move a field, click the row selector for the field to be moved to select the field, and then drag the field to the desired position.

____________________ is the storing of a piece of data in more than one place.

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

In the accompanying figure, the ____________________ Pane contains a list of all the objects in the database.

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

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

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

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

Modified Multiple Choice Table names cannot contain _____.

In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a ____ .

One way to create a table, is to click ____ on the Ribbon and then click the Table button.

In the accompanying figure, analyst names appear more than once in the table. Storing this data on multiple records is an example of redundancy which can cause several problems. What are these problems? What is the solution to the problem?

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

Modified Multiple Choice File names cannot contain a(n) ____.

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

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