Question 1

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.
A) Data
B) Forms
C) Edit
D) Query

Accepted Answer

The Blank Form button is located in the Forms group on the Create tab.

Question 2

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) contain the letter S anywhere in the value
B) contain only the letter S
C) begin with the letter S
D) none of the above

Accepted Answer

The answer of Case AC 4-1 Jessica wants to find...

Question 3

When you add a control to only one of these sections, the Form Header and Form Footer sections are added to the form ____.
A) individually
B) as a pair
C) either a. or b.
D) neither a. nor b.

Accepted Answer

Adding a control to either the Form Header or Form Footer sections will result in both sections being added together as a pair. So the best choice is B.

Question 4

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

Accepted Answer

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

Question 5

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.
A) Transform
B) Find
C) Replace
D) Change

Accepted Answer

To replace data in Microsoft Excel, you need to click on the Replace button in the Find group on the Home tab. This will open up the Find and Replace dialog box with the Replace tab activated, which allows you to search for specific text or values and replace it with something else. The Transform and Change buttons are not relevant to this function, and the Find button only allows you to search for data without replacing it.

Question 6

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.
A) grids
B) rulers
C) guides
D) rows

Accepted Answer

Rulers appear on the top and left sides of the form and are used to position controls precisely.

Question 7

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 ____.
A) contain the letter S anywhere in the value
B) contain only the letter S
C) begin with the letter S
D) none of the above

Accepted Answer

Selecting the "Any Part of Field" option will search for values that contain the letter S anywhere in the value, not just at the beginning or end.

Question 8

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.
A) right-click
B) single-click
C) double-click
D) select

Accepted Answer

To open the shortcut menu for a selected control in a control layout, you need to right-click it. Then, you can point to Layout and click Remove Layout to remove the control from the layout.

Question 9

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.
A) Find
B) Look
C) Hunt
D) Replace

Accepted Answer

The "Find" command allows the user to quickly search for specific data within a table, query datasheet, form, or report. This can save time and make it easier to locate necessary information. The other options (B, C, and D) are not valid commands for finding data in databases.

Question 10

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.
A) Control Dialog box
B) task bar
C) Ribbon
D) status bar

Accepted Answer

The status bar displays the width of the control in characters as you drag it and allows for precise resizing. The Control Dialog box, task bar, and Ribbon do not provide this feature.

Question 11

To print the form with the current record displayed, you must be in ____ view and navigate to the desired record.
A) Design
B) Layout
C) Datasheet
D) Form

Accepted Answer

The form view allows for the display of the current record and printing of the form with the current record. The design and layout views are used for designing and adjusting the layout of the form, and the datasheet view is used for viewing and editing data in a tabular format.

Question 12

You can use a form to ____.
A) update the record source
B) add new records
C) delete existing records
D) all of the above

Accepted Answer

The answer of You can use a form to ____.
A)...

Question 13

A(n) ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures.
A) bound
B) unbound
C) either a. or b.
D) neither a. nor b.

Accepted Answer

An unbound control is not connected to a record source and can be used to display information, lines, rectangles, and pictures. Bound controls, on the other hand, are connected to a field in a data source and display or allow the user to modify data from that field. Therefore, the best choice for the given question is B.

Question 14

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?
A) Double-click a field in the Field List
B) Click Create Field on the Ribbon
C) Both a. and b.
D) Neither a. nor b.

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 15

The ____ section displays information at the bottom of each form.
A) Form Header
B) Form Footer
C) Query Footer
D) Query Header

Accepted Answer

The Form Footer section specifically displays information at the bottom of each form, while the other options refer to sections within queries, not forms.

Question 16

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.
A) Title
B) Heading
C) Header
D) Text

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 17

In the Form Wizard, the ____ layout displays fields across the screen in the order in which they occur.
A) Justified
B) Tabular
C) Stacked
D) Columnar

Accepted Answer

The answer of In the Form Wizard, the ____ layout...

Question 18

When a field is selected in the form, "Current field" appears in the ____ list box when you open the Find and Replace dialog box.
A) Look In
B) Look Out
C) Search In
D) Search Now

Accepted Answer

The "Current field" option allows you to search for specific content within the currently selected field in a form. It is accessed through the "Look In" list box in the Find and Replace dialog box. The other options (B, C, and D) are not relevant to this feature.

Question 19

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.
A) File
B) Create
C) Home
D) Format

Accepted Answer

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

Question 20

FIGURE AC 4-1  Referring to Figure AC 4-1 above, the form shown was created by using the ____ tool.
A) Double Form
B) Double View
C) Split Form
D) Split View

Accepted Answer

The form shown in Figure AC 4-1 is split into two sections, with a form view at the top and a datasheet view at the bottom. This is known as a Split Form. The Split Form tool allows for easy data entry and viewing of records at the same time.

Quiz 4: Creating and Modifying Forms

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.

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

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

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

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.

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

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.

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.

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.

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

You can use a form to ____.

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

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 ____ section displays information at the bottom of each form.

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.

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

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

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.

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