The _____ data type is used for a field that contains text that is variable in length and that can potentially be very lengthy.
To modify the design of a table, right-click the table in the Navigation Pane, and click _____ on the shortcut menu.
To use the Input Mask Wizard, select the Input Mask property in the field's property sheet and then select the _____ button.
In the accompanying figure, the rows have been resized. To resize a row so that more data can appear, drag the lower edge of the _____ to the desired size.
In the accompanying figure, the rows have been resized. To resize a row so that more data can appear, right-click the record selector, and click _____ to change the row spacing
To undo changes to the row height, right-click the row selector, click Row Height on the shortcut menu, and then click the _____ check box in the Row Height dialog box
Create From File
To enter a picture stored on a USB drive into an OLE field, right-click the OLE field, click Insert Object and then click the _____ option button.
Bitmap Image Object
To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap), right-click the field, click _____, click Convert, and then select Picture (Device Independent Bitmap) in the Convert dialog box.
To insert data into an Attachment field, use the _____ command on the Attachment's field's shortcut menu.
To view attachments in a field, right-click the field, and then click _____ on the shortcut menu
To create a form in Design view, select the table for the form, click Create on the Ribbon, and then click _____ on the Create tab.
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.
To change the background color of a form, you can use the _____ button on the Design tab.
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 change the Tab Stop property for a control, select the control, click the _____ button on the Design tab, and change the value of the Tab Stop property from Yes to No.
To use a form to view data, right-click the form in the Navigation Pane, and then click _____ on the shortcut menu.
To view object dependencies, click the object of interest in the Navigation Pane, click the _____ tab on the Ribbon, and then click the Object Dependencies button.
The condition, _____, entered in the Criteria row of a memo field in a query window would retrieve all records where the memo field had any mention of Information.
To test for the current date in a query, type _____ in the Criteria row of the appropriate column.
To create a simple form with a datasheet, select the table that is the "one" part of a one-to-many relationship in the Navigation Pane, click Create on the Ribbon, and then click the ____ button on the Create tab.
To create a multitable form based on the "many" table, click the _____ button on the Create tab to create a form in Layout view.
If the primary key of the Course Offerings table contains the primary key for both the Client table and Course table, there is a _____ relationship between clients and seminars.
In the accompanying figure, an expression will be entered in the Expression Builder dialog box. To enter a caption for this expression, click the _____ button to display the property sheet.
To create a report from scratch, click the Create tab, and then click the _____ button.
Group & Sort
To display the Group, Sort, and Total pane, click the _____ button on the Design tab.
The contents of the _____ section are printed before the records in a particular group.
Add Existing Field
To add fields to a report, click the _____ button on the Design tab to add a field list.
To periodically view a report to gauge how it will look containing data, click _____ on the View menu.
To reverse the most recent change to a report, click the _____ button on the Quick Access Toolbar.
Use Control Wizards
The SubReport Wizard displays in the accompanying figure. To ensure that the wizard guides you through the process of adding a subreport, make sure the _____ button is selected.
The SubReport Wizard displays in the accompanying figure. To open a subreport in Design view, right-click the subreport in the Navigation Pane and click _____ on the shortcut menu.
To extend a heading over two lines, click in the appropriate position to produce an insertion point and then press the _____ key(s).
To remove blank lines that occur when a field is empty, change the value of the _____ property.
To cause the contents of the Group Header section to appear at the top of each page, change the value of the _____ property.
To display a Report Footer section, right-click any open area of the report and click _____ on the shortcut menu.