Exam 7: Using Form Tools and Creating Custom Forms

Bound controls, unbound controls, and calculated controls are placed in the ____________________ section of the Design view when creating a form.

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.

To quickly open the Property Sheet for a control in Layout view, press the F4 key on the keyboard. _________________________

In the accompanying figure, which number indicates the Selection type entry?

Case Based Critical Thinking Questions Case 6-2 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?

Controls placed at the top of a form in the ____________________ remain on the screen when the form is displayed in Form view or Layout view and do not change when the contents of the Detail section are changed or when navigating from one record to another record.

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

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

____________________ is the default name for the first form created in a database using Design view.

Flat, Raised, Sunken, Etched, Shadowed, and Chiseled are options for the ____ control property.

Which button on the FORMAT tab is used to change the background color of a control, section, or object?

Options on the ARRANGE tab apply only to the datasheet when the Split Form tool has been used to create the form. _________________________

If a form does not need both a Form Header and a Form Footer section, the section which is not needed may be removed by setting the height of the section to zero . _________________________

The Record Source property specifies the table or query on which a form is based.

To find records in a form using a Combo box, it is necessary to change the ____ form property of the form to the table or query that is the source for all the bound controls in the Detail section.

Case Based Critical Thinking Questions Case 6-1 Carlos has created several tables for his Organic Produce farm database including Customers, Vendors, and Products. Now he wants to create forms that will make it easier to enter data in the database. Determine the best methods for Carlos to use when creating forms for his specific needs. The new custom form meets Carlos' requirements; however, some of the labels do not clearly describe the data that needs to be entered in the form.  Which label property should Carlos change to make the label more descriptive and clear to the user?

Number signs indicate that a text box has been resized too small to display the contents properly.

It is a good idea to review the progress being made on a form as it is being created by switching to ____________________ view periodically.

A control that allows users to type an entry is a(n) text box . _________________________