Exam 7: Using Form Tools and Creating Custom Forms

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.

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.

Which property must be set to Yes in the Property Sheet to display a control or a section in the form?

Use the ____________________ view to update data using a form.

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?

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?

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?

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

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

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

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

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.

To increase an object's window size to view more of the vertical contents of the object, collapse the ____.

In the accompanying figure, which arrow indicates the move handle of a control?

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. After reviewing the simple form, Carlos decides that he needs a form which is customized to make data entry more accurate and less cumbersome.  Because most of his products are already in the database, he would like to use a list to choose the product during data entry.  However, there are times that a product might not be available in the database, and it needs to be added. What is the best type of control for Carlos to use in his custom form to meet this requirement?

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

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

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