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

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

A(n)____ contains information about a given person, product, or event.

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

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

To define an additional field in Datasheet view, click the ____ column heading.

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?

To specify AutoCorrect rules and exceptions to the rules, click File to open the Backstage view, click ____ , and then click Proofing in the dialog box that displays.

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.

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

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

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

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

Access is a ____.

The ____________________ feature of Access corrects common mistakes when you complete a text entry in a cell.

____ words are words that have a special meaning to Access and cannot be used for the names of fields.

In the accompanying figure, the entire area that displays on the screen is called the ____________________ work area.

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

If it is desirable to have a name other than the field name appear at the top of a column in Datasheet view, change the field's ____________________ to a different name.

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

To rename a field, right-click the column heading for the field, and then click Rename Field on the shortcut menu.