Exam 6: Multitable Forms

Rows in a datasheet may be different sizes.

To change the size of a row, you use a record's ____________________, which is the small box at the beginning of each record.

To ensure that a collection of controls is aligned properly with each other, select all of the affected controls, and then use the appropriate alignment button on the _____ tab.

The portion of a picture that appears as well as the way it appears is determined by the size mode. What are the three possible size modes and how do they affect a picture?

To use the shortcut menu to change the background color of a form, right-click the form and select the _____ command on the shortcut menu.

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

If a field contains a date, assigning it the Date data type accomplishes three things. What are these three things?

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

To view attachments in a field, right-click the field, and then click _____ on the shortcut menu.

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

When you add a title to a form using the Title button, Access places the title in the Detail section.

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.

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

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.

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

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

You can use the OLE Object data type or the Attachment data type to store a picture.

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

If one business analyst services many clients, the relationship between business analyst and clients is called a(n) ____________________ relationship.