Exam 7: Multiple-Table Forms

To insert data into an Attachment field, use the ____________________ command on the Attachment field's shortcut menu.

To add a title to a form, tap or click the ____________________ button on the FORM DESIGN TOOLS DESIGN tab.

An input mask specifies how data is to be entered and how it will appear.

To view data, such as a picture, in an OLE field, press and hold or right-click the field, tap or click ____________________ on the shortcut menu, and then tap or click Open.

Once the tab order for fields is determined, it cannot be changed.

To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap), press and hold or right-click the field, tap or click ____, tap or click Convert, and then select Picture (Device Independent Bitmap) in the Convert dialog box.

To change the font color of a label, select the label, and tap or click the ____ arrow on the FORM DESIGN TOOLS FORMAT tab to display a color palette.

To change the tab order in which fields are encountered on a form, tap or click the Tab Order button on the ____ tab.

Rows in a datasheet may be different sizes.

Modified Multiple Choice An OLE Object field can store ____.

To change the background color of a form, you can use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

To create a form with a datasheet in Layout view, tap or click the ____ button on the CREATE tab to create a form in Layout view.

In the accompanying figure, the Comment field has been resized. You can change the size of a column by using the ___________________, which is the bar containing the field name.

To change the Tab Stop property for a control, select the control, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and change the value of the Tab Stop property from Yes to No.

The form in which the subform is contained is called the ____________________.

To switch from Design view to Form view to display the form, tap or click the ____ button.

When a form includes a subform, the ___________________ contains data from the many table in a one-to-many relationship.

In the accompanying figure, the data type of ___________________ is used for the Comment field because the field contains text that is variable in length and potentially very long.

When you enter data in a long text field, Access automatically expands the row and column to display all the data in the field.