Exam 4: Creating and Modifying Forms

To select a group of controls, click the first control, press and hold down the Tab key, click the other controls, and then release the Tab key.

The ____________________ pane contains the tables in the database and displays the fields they contain.

The Split Form tool creates a form using all the fields in the selected table or query and splits the window into four panes.

To remove one or more selected controls from a control layout, ____ the control to open the shortcut menu, point to Layout, and then click Remove Layout.

In the Form Wizard, the ____ layout displays fields across the screen in the order in which they occur.

In the bottom pane of the Split Form tool, you will see a ____ that contains the form data.

When you need to create a form to match a paper form that you are already using-or when you need to create a form that doesn't match the appearance of a form that you can create with a form tool or the Form Wizard-you can create a blank form in Query view.

When you create a form, it contains one section called the Title section.

When you resize controls in a control layout in Layout view, reducing the width of one control reduces all the widths of all other controls in the control layout at the same time.

You can see the position of objects in Design view as you are moving them, and you can position controls precisely by looking at the horizontal and vertical ____ that appear on the top and left sides of the form.

Case AC 4-2 Zack wants to create a custom form to match a paper form that he uses everyday in the office. Zack has opened the Field List pane and wants to add a field to the form. What should he do?

You can use the Undo button on the Quick Access Toolbar to restore a deleted field value, but deleting a record permanently deletes it from the record source.

When fields appear in a form, they appear in ____.

Most database experts agree that users should make all database updates by using a form, instead of by using table datasheets.

To delete a control from a form, click the control to select it, and then press ____________________.

The Form Wizard provides four form layouts from which to choose. Name and briefly describe each layout, including an example of a situation of where you would use each layout.

When a field is selected in the form, "Current field" appears in the ____ list box when you open the Find and Replace dialog box.

Case AC 4-1 Jessica wants to find and replace some data in her database. If Jessica types S in the Find What list box, and then selects the Any Part of Field option in the Match menu, she'll find values that ____.

When a form is displayed in Query view, you will see each record in the record source in a form.

When you need to create a simple form quickly, you can use the ____________________, which helps you create a form by letting you select options in dialog boxes to specify the form's record source and layout.