Exam 6: Using Form Tools and Creating Custom Forms

A subform may be added to a main form by using the Subform/Subreport tool or by using the ____.

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

Text that appears in a ScreenTip when the mouse pointer is positioned above a control in a form is determined by the ____ property.

A selected control will display how many sizing handles?

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

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

A customizable form that displays multiple records from a source table or query in a datasheet format may be created using the ____ form tool.

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.

Case Based Critical Thinking Questions 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.

A value that is the result of an expression is displayed in which type of control in a form?

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

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

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

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

Which key on the keyboard may be used to ensure that a horizontal or vertical line is straight when adding a line to a form or report?