Exam 6: Using Form Tools and Creating Custom Formsmodule

Titles,instructions,command buttons,and other controls added to the bottom of a form and that remain on the screen when the form is displayed in Form view or Layout view are added to the ____ section of the form.

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

Akash created a custom form for his supervisor that includes a subform based on a query for unpaid invoices.  After creating the form and viewing it in Form view,Akash needs to make some changes.  Decide which options are best for Akash to use to make the necessary changes to the custom form design. -Akash has included a calculated field in the subform which was created using a query for unpaid invoices.The calculated field should show the total amount of unpaid invoices from the InvoiceAmt field;however,the form does not show the calculation in Form view.Which expression will solve this problem?

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

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

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

The caption that displays in a label cannot be changed in Design view when creating a form.

Which form tool displays data in both Form view and Datasheet view at the same time?

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

A form may only be created from scratch in Form view.

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.

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

The expression =Sum([InvoiceAmt])might be found in which type of control added to a form?

The ____ property specifies the data source for a control in a form or report or for a field in a table or query.

To improve a form's readability,group related information or underline important values using the ____________________ tool in the form's Design view.

A selected column of controls may be aligned to the left or right edges of the controls using the Arrange tab on the ribbon.

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._________________________

To avoid typing errors when creating a more advanced expression for a calculated control,it is a good idea to use this Access feature.

Which symbol is used to distinguish an expression from a fieldname in a calculated control?

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