Exam 1: Microsoft Access Basics

In Datasheet view, the table displays its data in rows and columns in a ____.

Access combines compacting and repairing into one step.

If you make changes to the layout of a datasheet and try to close the table, Access will ____.

By default, the rows in a datasheet are displayed with ____.

The ____ object is similar to a macro, but allows more complex programming of database operations.

When you want to display more of the open object, you can close the Navigation Pane by clicking the Shutter Bar Open/Close Button at the top of the Navigation Pane.

A(n) ____________________ is a collection of objects.

FIGURE AC 1-1 Referring to Figure AC 1-1 above, if you sorted the database on Last Name, you would be sorting on a ____.

When you enter an improper field value, a(n) ____ message appears and tells you what to do to correct your mistake.

You can select all of the records in a table by clicking the ____________________, which is the box in the upper-left corner of a datasheet.

Access is a DBBS program.

Imagine that you are a Sales Manager at a Toy Company, and give an example of a business situation where you would use each of these database objects: query, report, and macro.

Access opens in ____ view.

In ____, you can rearrange the order of the fields in a datasheet by dragging them to a new location.

When you change the row height of a datasheet, the change ____.

A database management system does not need to be computerized.

When you open a database, Access assumes that the database might contain something that could damage your computer.

To freeze columns, select the field selectors for the columns that you want to freeze, click the More button in the Layout group on the File tab, and then click Freeze Fields.

Best of class automatically resizes the column to the best width for the data contained in the column.