Exam 6: Using Form Tools and Creating Custom Forms

The caption that displays in a label cannot be changed in 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 ____.

Options on the Arrange tab apply only to the datasheet when the Split Form tool has been used to create the form. _________________________

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

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

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 form tool displays data in both Form view and Datasheet view at the same time?

Number signs indicate that a text box has been resized too small to display the contents properly.

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

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

The Access tool that allows the user (or designer)to create detailed documentation of all, or selected, objects in a database is the ____.

A(n)____________________ is an unbound control that displays text.

Flat, Raised, Sunken, Etched, Shadowed, and Chiseled are options for the ____ control property.

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

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. -The new custom form meets Carlos' requirements; however, some of the labels do not clearly describe the data that needs to be entered in the form.  Which label property should Carlos change to make the label more descriptive and clear to the user?

Only a field name or an expression may be used for the ____ property in a calculated control.

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.

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.

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

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