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

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-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?

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

A combo box control may only be modified in form Design view.

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

The Tab Order button, which quickly displays the Tab Order dialog box, is located on the ____ tab in Form Design view.

A ____ asks a series of questions and then uses your answers to create a control in a form or report.

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

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

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

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

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

The ____________________ property for a control will automatically resize the control and place it in the same relative position on the screen regardless of monitor size and screen resolution.

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.

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.

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

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 property must be set to Yes in the Property Sheet to display a control or a section in the form?

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