Exam 3: Access: Creating and Using a Database

In Datasheet view, a table is represented as a collection of rows and columns called a datasheet.

Grouping means creating separate collections of records sharing some common characteristic.

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

When you maximize a window, the Maximize button changes to a(n)____ button.

In addition to the top-level tabs, Access displays other tabs called ____ tabs that display when you perform certain tasks or work with certain objects such as datasheets.

A saved database is referred to as a ____.

If the Field Size for a field whose data type is Number is set to ____, the field size will be an integer value in the range of 0 to 255.

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

To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.

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

A folder is a specific location on a storage medium.

Figure 1-3 In the accompanying figure, the words Form View at the lower left of the screen appear on the ____________________.

To open a table in Design view, right-click the table in the Navigation Pane and then click ____ on the shortcut menu

To change the name of a field, right-click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name.

To quit Access, click the ____ button on the right side of the Access title bar.

A(n)____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.

One way to undo changes to a field is to click the Undo button on the Table Tools tab.