Exam 7: Multiple-Table Forms

In the accompanying figure, the Comment field has been resized. To resize a field so that a larger portion of the text will appear, press and hold or right-click the field selector, and tap or click ____ to change the column size.

Any row and column spacing changes made to a datasheet are saved automatically when you close the table.

To undo changes to the column width, press and hold or right-click the field selector, tap or click Field Width on the shortcut menu, and then tap or click the ____ check box in the dialog box.

To insert data into an Attachment field, use the ____ command on the Attachment field's 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 test for the current date in a query, type ____ in the Criteria row of the appropriate column.

When data, such as a picture, is inserted into an OLE field, Access does not immediately display the picture.

To select more than one control at a time, press and hold down the ____________________ key(s) as you select additional controls.

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.

What data type is appropriate for a field that indicates whether the customer participates in the preferred customer program?

Modified Multiple Choice You can use the ____ data type for a Picture field.

In the accompanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. With the Zoom size mode, the entire picture will appear and be proportioned correctly.

In the accompanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. The Cut size mode displays only the portion of the picture that will fit in the space allocated to it.

In Datasheet view, an Attachment field appears as a paper clip rather than the field name.

To go to a specific record in the main form, enter the record number in the ____ box for the main form.

You cannot change the size of the property sheet.

To change the special effect of a label, select the label, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the Special Effect property arrow.

Only pictures that have been created in Microsoft Drawing can be inserted into OLE fields in Access.