Exam 2: Access: Multiple-Table Forms

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

To resize columns in a subform, press and hold or right-click the subform in the Navigation Pane, and tap or click ____ on the shortcut menu.

Critical Thinking Questions Case 5-1 An employee at Bavant Publishing would like to add some additional fields to the Customer table. He needs to add fields that will store the web page for a customer, as well as whether or not the customer participates in a preferred customer program. What data type should the employee assign to the field that will contain the web page?

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

To add a Form Header section to a form, press and hold or right-click anywhere on the form background and tap or click ____ on the shortcut menu.

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

Access only allows you to change the font and font size for a label on a form.

When entering data in a field that has an input mask, Access will insert the appropriate special characters in the proper positions.

To change the size of a row, you use a record's record selector .

The condition, ____, entered in the Criteria row of a long text field in a query window would retrieve all records where the long text field had any mention of education.

The best size mode to use for photographs is ____________________ size mode.

In the accompanying figure, the Comment field has been resized. To resize a field so that a larger portion of the text will appear, drag the right edge of the ____ to the desired size.

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.

To move from the last field in the main form to the first field in the subform, press the CTRL+SHIFT+TAB keys.

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 have the TAB key bypass a control, change the ___________________ property.