Exam 4: Access Lesson 4: Creating and Modifying Forms

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

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.

When you add a control to only one of these sections, the Form Header and Form Footer sections are added to 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?

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.

The Many Fields tool creates a form that lists all the fields in a datasheet format, but using a style that is similar to the form created by the Form tool.

An unbound control is connected to a field in the record source and is used to display, enter, and update data.

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.

The ____________________ tool creates a form that looks just like a datasheet.

The Form Wizard provides four form layouts from which to choose. The ____ layout displays fields in a stacked column format, with labels to the left of their controls.

To print the form with the current record displayed, you must be in ____ view and navigate to the desired record.

When you need to find and replace data, click the ____ button in the Find group on the Home tab. The Find and Replace dialog box opens with the Replace tab activated.

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

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.

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.

A control layout is a "container" that groups together the controls in a form so that you can change them as a group.

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 Whole Field option in the Match menu, she'll find values that ____.

A(n) ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures.