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

A selected control will display how many sizing handles?

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

A tool used to form a group of related controls or to separate the group from other controls is the ____ tool.

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 ____________________ function calculates the total of an expression in a form or report.

The Control Source property for a calculated control may be either a(n) ____________________ or a(n) ____________________.

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

Set the ____ property to No to prevent users from using the Tab key to navigate to a control.

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

Access assigns names to control boxes if the Name property for the control is not set when the form is created.

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.

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

Tab order may only be changed in form Design view.

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

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. To add the control to the form that meets his requirements, Carlos will use the ____ from the DESIGN tab in the Forms Layout Group on the Ribbon.

All of the fields added to the form are from the Customer table. These controls are called ____ controls because they are connected to a field in the database.

Only a field name or an expression may be used for the ____ property in a calculated control.

The default Form Footer section Height property is set to ____ when the Form Footer is added in Design view.

To select an entire form and set properties for the form, click on the ____________________ at the intersection of the horizontal and vertical rulers.

When there is a finite number of choices for a form entry, a combo box control should be used.