Exam 6: Using Form Tools and Creating Custom Forms

The label attached to a bound control displays which of the following?

To create a custom form, the user may modify an existing form in Form view or Design view. _________________________

Which view or tool allows the form designer the most control and precision when designing a form?

The ____________________ function calculates the total of an expression in a form or report.

A form created from related tables usually consists of a ____ table which is the "one" side of the one-to-many relationship with a subform.

The Bound Column property specifies the default control used to display a field. _________________________

Text box controls arranged vertically in Form Design view with a label control to the left of each text box control is the tabular layout.

A(n)____________________ control in a form design is created using a field selected from the table or query used as the record source for the form.

The Layout view or the Design view may be used to create a ____ form.

A ____ asks a series of questions and then uses your answers to create a control in a form or report.

Spacing around the text inside a control is determined using the ____ property.

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.

The subform used to create a form from related tables represents the records in the ____________________ side of the relationship.

Case Based Critical Thinking Questions Janise's College Pet Sitting business is growing rapidly.  She has expanded to include more pet sitters and is creating forms for the sitters to enter information in the business database. She is creating only custom forms. Determine the best methods, features, and tools for Janise to use when creating her custom forms. -Janise will now add selected fields from the Customer table to her form. Which section of the form will contain the fields from the selected table?

Tab order may only be changed in form Design view.

A control that combines the features of a text box and a list box is a ____.

The number of occurrences of an expression is determined using the ____ function in a form or report.

When resizing controls in Design view, the user can see actual field values while resizing the controls. _________________________

The record source for a subform must be a table.

Tab order allows a user to navigate the label boxes in a form by pressing the Tab key on the keyboard. _________________________