Exam 3: Create Forms

In the Applications Options dialog box, you can pick one form that opens automatically when the database is opened.

When a form is used to input or modify data in a table, the data is saved to the table ________.

You CANNOT move a control within a layout to the location you want.

The Form Wizard allows the user to choose ________, Datasheet, Justified, or Columnar layout.

A form has a ________ at the bottom so you can move from one record to another.

The second screen of the Form Wizard is where you select the fields you want your form to display.

A(n) ________ is a control in a form that displays the data from a field in a table or query.

Some forms have ________ that open other database objects.

A ________ determines how data and labels are arranged in a form.

In a ________ layout, controls are arranged in rows and columns like a spreadsheet.

The first screen of the Form Wizard is where you select the layout for your form.

You CANNOT rearrange controls in a tabular layout.

When a form is selected, the Property Sheet button is found in the ________ group under the Design tab.

Most forms display in ________ view.

One way to create a form in Access is to use the ________, which can be used to select specific fields for the form.

In a one-to-many form, the main form shows data from the ________ side of the relationship.

In a form created with a tabular layout, you can insert, delete, and merge columns as needed.

Match each definition with the appropriate term. A) Input mask B) Form Wizard C) Many-to-many form D) Control grid E) Conditional Formatting F) Layout G) Columnar Form H) Navigation Form I) One-to-many form 96) The arrangement of data and labels in a form 97) A tool used to create a form where only selected fields are added to the form 98) A type of form that has a subform that displays related records from another table 99) A special set of characters that control what can and cannot be entered in a field 100) A form that contains a Navigation Control to quickly open forms

When the Conditional Formatting button is clicked, the ________ displays.

On a form, a text box displays the data from a field in a table or query.