Exam 5: Multiple-Table Forms Question MC

If you create a form with the Form button for a table that is the "one" table in a one-to-many relationship, Access automatically includes the "many" table in a subform .

To insert data into an OLE Object field, use ____ sammand on the OLE's shortcut menu.

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

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 santain the web page?

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

To select more than one santrol at a time on a form, press and hold down the ALT key as you select additional santrols.

To give a label an etched appearance, change the ________________________ property for the label.

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

A field with the Hyperlink data type can santain links to ____.

To view object dependencies, tap or click the object of interest in the Navigation Pane, tap or click the ____ tab on the ribbon, and then tap or click the Object Dependencies button.

There are at least two reasons for viewing information on dependencies between database objects. What are these reasons?

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

An employee at Bavant Publishing would like to query the Book Rep table. She has created a query and entered the fields she wants to display in the result in the design grid. Now, she enters the criteria. What would the employee enter in the Criteria row of the Start Date field to find all book reps who started before January 1, 2013?

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

In the acsampanying figure, the rows have been resized. To resize a row so that more data can appear, press and hold or right-click the resard selector, and tap or click ____ to change the row spacing.

The acsampanying figure shows the Book Rep table. The Phone Number field in this table uses a(n) ____________________, which specifies how data is to be entered and how it will appear.

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.

When you insert data in an OLE field, you either can create a new object or insert an already created object in the field.

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

To enter data into a Hyperlink field, press and hold or right-click the Hyperlink field, tap or click Hyperlink on the shortcut menu, and then tap or click ____ on the Hyperlink submenu.