Exam 4: Creating and Modifying Forms

Explore all topics

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

Free

(Multiple Choice)

4.8/5

(37)

Question 1

Correct Answer:

Verified

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

Free

(Multiple Choice)

4.9/5

(35)

Question 2

Correct Answer:

Verified

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.

Free

(Multiple Choice)

4.8/5

(33)

Question 3

Correct Answer:

Verified

Table, form, and report objects in the database can have the same name.

(True/False)

4.8/5

(29)

Question 4

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

(Multiple Choice)

4.9/5

(31)

Question 5

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

(True/False)

4.8/5

(32)

Question 6

You can use a form to ____.

(Multiple Choice)

4.8/5

(38)

Question 7

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

(Multiple Choice)

4.9/5

(33)

Question 8

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.

(Multiple Choice)

4.9/5

(33)

Question 9

The Form Footer section displays information at the top of each form.

(True/False)

4.8/5

(46)

Question 10

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.

(True/False)

4.8/5

(33)

Question 11

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

(Multiple Choice)

4.8/5

(43)

Question 12

A form's style, also called a(n) ____________________, formats the form and its controls using a predefined color, font, and design scheme.

(Short Answer)

4.7/5

(46)

Question 13

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.

(Multiple Choice)

4.9/5

(50)

Question 14

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

(Multiple Choice)

4.7/5

(30)

Question 15

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

(True/False)

4.9/5

(40)

Question 16

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.

(Multiple Choice)

4.9/5

(37)

Question 17

Identify the letter of the choice that best matches the phrase or definition.

To print all records in the form, click the ____ tab, click Print on the navigation bar, and then click Print to open the Print dialog box.

New

You can change the default font size, color, and style of the title text using the buttons in the Font group on the ____ tab.

File

To add a new record, click the ____ button in the Records group on the Home tab to open a blank form.

Format

Correct Answer:

Verified

To print all records in the form, click the ____ tab, click Print on the navigation bar, and then click Print to open the Print dialog box.

You can change the default font size, color, and style of the title text using the buttons in the Font group on the ____ tab.

To add a new record, click the ____ button in the Records group on the Home tab to open a blank form.

If you do not see the Field List pane, click the Add Existing Fields button in the ____ group on the Design tab.

When you click the Find button in the Find group on the ____ tab, the Find and Replace dialog box opens.

(Matching)

4.8/5

(38)

Question 18

In the Form Wizard, the ____ layout displays fields with the labels at the top of a column that contains the field values.

(Multiple Choice)

4.7/5

(34)

Question 19

You must be in Design view to add controls such as lines, rectangles, and labels to a form.

(True/False)

4.9/5

(34)

Question 20

Showing 1 - 20 of 46

Exam 4: Creating and Modifying Forms

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

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

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.

Table, form, and report objects in the database can have the same name.

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

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

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.

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.

The Form Footer section displays information at the top of each form.

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.

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

A form's style, also called a(n) ____________________, formats the form and its controls using a predefined color, font, and design scheme.

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.

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

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

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.

In the Form Wizard, the ____ layout displays fields with the labels at the top of a column that contains the field values.

You must be in Design view to add controls such as lines, rectangles, and labels to a form.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters