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

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

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

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

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

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

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 is planning her first custom form carefully. She knows that she wants a title for her form and several fields included in the form controls. Which feature will Janise use to add the appropriate section for a title to her form?

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

Describe the various methods of setting properties for a control using the Property Sheet.

In the accompanying figure, the control type for the selected control is a ____.

In the accompanying figure, which arrow indicates the Detail section bar?

The accompanying figure illustrates a form created using the ____________________ Tool which contains all fields in the source table or query.

Case Based Critical Thinking Questions Case 6-3 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 used the Header section in his main form design, but he does not plan to use the Footer section. To remove the footer section, which section property should be set to zero?

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. Carlos is creating a simple form using the Products table and would like to include all fields from the table. He would like for the form to display all of the fields using a datasheet layout. Which tool would be best for Carlos to use?

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

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

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

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

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

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

In the accompanying figure, which arrow indicates a bound control?