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

Modified Multiple Choice You can create a table in ____.

A field whose data type is ____ can contain any characters.

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

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

To preview and then print the contents of a table, use Table Preview.

In the accompanying figure, book rep 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?

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

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

The rows in the tables are called ____________________.

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

To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu.