Exam 22: Getting Started With Access Essentials

The ____ key moves the insertion point to the next field.

A ____ is an object that stores data in columns and rows.

Case 22-2 Jamir works for a distribution company and has taken over responsibility of the customer database. He has several changes to make to it in order to update the information. Jamir needs to delete a record. He needs to select it and press ____ to remove the data.

Access stores cut or copied text in the ____.

FIGURE 22-1 What is the arrow pointing to in Figure 22-1 above?

____ is software that can be accessed for free.

Datasheet view shows details about the structure of the object, including the data type and the field properties.

A query is an object that organizes data in a specific layout.

When you enter data into a cell, it is called a(n) ____________________.

Once you have deleted a record, you can use the Undo command to restore it.

A table is often referred to as a(n) ____________________.

You can only add fields in Design view.

Case 22-2 Jamir works for a distribution company and has taken over responsibility of the customer database. He has several changes to make to it in order to update the information. To remove a table field and all the data for the field, Jamir should delete the ____.

The default Field Size property for the Text data type is 50 characters.

FIGURE 22-2 Which view is displayed in Figure 22-2 above?

You can open multiple databases at a time in an Access window.

In ____ view, the table looks much like a spreadsheet.

The Next record button is located in the ____.

When you create a new database, the first step is to name the database file.

A ____ makes it easy for you to view, enter, and edit data in a table.