Exam 2: Access: Using Form Tools and Creating Custom Forms

With a split form when the datasheet is active the options in the group marked ____ in the accompanying figure do not apply except for the Add Existing Fields button which applies to both the form and the datasheet.

The join line indicated in the accompanying figure indicates a many-to-one relationship.

When you add an unbound control for a form Access adds a text box and a label.

Controls placed in the Form Header or Form Footer sections do not remain on the screen when the form is displayed.

Nothing and Names Data Types Sizes and Properties are examples of ____ documentation options.

To create a(n)____________________ form you can modify an existing form or design and create a form from scratch.

To calculate the total of an expression you use the ____________________ function.

One guideline for working with forms is to use a consistent ____ for all forms in a database.

You use a(n)____ control to display text.

You can click one of the view buttons on the left side of the status bar to switch to another view.

A Multiple Items form cannot be displayed in ____ view.

With a split form when the datasheet is active the selected option in the group marked ____ in the accompanying figure applies to every field value in the datasheet.

You can design a custom form to match a paper form to display some fields side by side and others top to bottom or to add special buttons and list boxes.

The ____ layout arranges text box controls in a datasheet format with labels above each column.

When a field changes from a lookup field to a text box an arrow will appear in the field.

To remove the lookup feature from a field you would change the Default Control property which specifies the default control used to display a field.

When you add a bound control to a form Access adds a text box and to its left a(n)____.

The ____ function determines the number of occurrences of an expression.

In addition to printing the Relationships window you can use the ____________________ to create detailed documentation of all or selected objects in a database.