Question 1

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

Accepted Answer

Selecting the "Any Part of Field" option in the Match menu will search for values that contain the letter S anywhere in the value, regardless of whether it is at the beginning, middle, or end.

Question 2

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

Accepted Answer

The answer of The ____________________ tool creates a form that...

Question 3

FIGURE AC 4-1  Referring to Figure AC 4-1 above, to create this type of form, click the More Forms button in the Forms group on the ____ tab.

Accepted Answer

To create this type of form, you need to click the More Forms button in the Forms group which is located on the Create tab.

Question 4

You can use a form to ____.

Accepted Answer

A form can be used to update the record source, add new records, and delete existing records.

Question 5

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

Accepted Answer

The "Justified" layout in the Form Wizard displays fields across the screen in the order they occur, filling the available space.

Question 6

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.

Accepted Answer

To open the shortcut menu on a control, you need to right-click on it. Therefore, the correct choice is A) right-click.

Question 7

You can also resize a control precisely by watching the lower-left corner of the ____ to see the width of the control in characters as you drag it.

Accepted Answer

The status bar displays the width in characters of the control being resized, allowing for precise resizing.

Question 8

Another option for finding data quickly is to use the ____ command, which is available when you are using a table or query datasheet, form, or report.

Accepted Answer

The "Find" command allows you to quickly search for specific data within a table or query datasheet, form, or report. This can save time and make it easier to locate important information. The other options ("Look," "Hunt," and "Replace") are not valid commands for finding data in a database.

Question 9

Case AC 4-2 Zack wants to create a custom form to match a paper form that he uses everyday in the office. To create a blank form, Zack needs to click the Create tab on the Ribbon, and then click the Blank Form button in the ____ group.

Accepted Answer

To create a custom form in Microsoft Access, one needs to click on the "Create" tab on the Ribbon, and then click the "Blank Form" button in the "Forms" group. This allows for the creation of a form from scratch and designing it to match a paper form or any other desired format.

Question 10

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

Accepted Answer

Selecting the Whole Field option means that only fields that exactly match the letter S will be found, so the value must contain only the letter S.

Question 11

To add a title to a form, which adds an unbound control to the form, click the ____ button in the Header/Footer group on the Design tab.

Accepted Answer

The Title button in the Header/Footer group on the Design tab is used to add an unbound control, such as a title, to a form in database applications like Microsoft Access.

Question 12

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

Accepted Answer

The "Look In" list box allows you to specify where to search for the text. When a field is selected, "Current field" will appear as an option in this list box.

Question 13

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

Accepted Answer

An unbound control is not connected to a record source and can be used to display various objects such as lines, rectangles, and pictures. Bound controls, on the other hand, are connected to a specific field in a record source and display data from that field.

Question 14

The ____ section displays information at the bottom of each form.

Accepted Answer

The Form Footer section displays information at the bottom of each form. The Form Header section displays information at the top of each form, while the Query Footer and Query Header sections are used in a different type of object (a query) and are not relevant to the question.

Question 15

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?

Accepted Answer

Zack should double-click a field in the Field List pane to add it to the custom form. This will automatically add the field to the form and place it in the appropriate location. Clicking the Create Field button on the Ribbon will prompt Zack to manually add and configure the field, which may take longer and be more prone to errors.

Question 16

FIGURE AC 4-1  Referring to Figure AC 4-1 above, the form shown was created by using the ____ tool.

Accepted Answer

The form shown in Figure AC 4-1 is a Split Form, which displays both a Form view and a Datasheet view of the same table or query. This allows for easy data entry and manipulation, as well as quick reference to existing data. The other options (Double Form, Double View, and Split View) do not accurately describe the form shown in the figure.

Question 17

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

Accepted Answer

Only the Form view allows you to view one record at a time and print the current record. The Design and Layout views are for designing the form and the Datasheet view is for working with the underlying data in a spreadsheet-like view.

Question 18

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.

Accepted Answer

The horizontal and vertical rulers appear on the top and left sides of the form and allow you to position controls precisely. The other options (grids, guides, rows) do not specifically refer to the horizontal and vertical markers used for positioning controls.

Question 19

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.

Accepted Answer

The Replace button is used to find and replace data in a worksheet. This button is located in the Find group on the Home tab, and it opens the Find and Replace dialog box with the Replace tab activated.

Question 20

When you add a control to only one of these sections, the Form Header and Form Footer sections are added to the form ____.

Accepted Answer

The Form Header and Form Footer sections are added as a pair. When you add a control to one of them, they are both automatically added to the form.

Quiz 4: Access Lesson 4: Creating and Modifying Forms