Exam 7: Using Form Tools and Creating Custom Forms

The record source for a subform must be a table.

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. Before typing the title, which tool should Janise choose from the DESIGN tab on the Ribbon?

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

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?

A selected control will display how many sizing handles?

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

The ____ option in the Tab Order dialog box allows a tab order of left-to-right or top-to-bottom.

Text box controls arranged in a datasheet format with a label above each column indicates the ____ layout.

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

Tab order allows a user to navigate the label boxes in a form by pressing the Tab key on the keyboard. _________________________

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

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

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

The caption that displays in a label cannot be changed in Design view when creating a form.

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?

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

Titles, instructions, command buttons, and other controls added to the bottom of a form and that remain on the screen when the form is displayed in Form view or Layout view are added to the ____ section of the form.

The Layout view or the Design view may be used to create a ____ form.

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