Access Module 4 Test

What happens when you apply a theme to a form?

The formatting changes in all forms and reports

Besides changing the width of a report, what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?

You can change the orientation of the report to landscape.

Where do you specify the number of columns for a report?

Page Setup dialog box

How can you display the title of a report in green?

Change the font color of the label in the Report Header.

A _____ allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.

form

Which of the following options can you set when creating a report with the Report Wizard?

grouping field, sort order, orientation

In _____ view, you can make some design changes to a report while you are displaying the data.

layout

Using the Report Wizard, you can select the _____ for the report.

layout

To change the column layout in a report in Report Design view, you use the _____.

layout property

You can add fields to a form in Design view or _____.

layout view

You can insert a logo in the form header using the ____ button on the Form Design Tools tab.

logo

If a blank column of controls appears next to a column of fields in a control layout, you can _____ the columns to create a single column.

merge

When you select a control in Form Design view and then press an arrow key, you _____ the control.

move

If you move a text box in Form Design view, you _____.

move the label associated with that text box

How can you highlight report records that include values greater than $500 in the OrderAmt field?

use conditional formatting

When you create a report using the _____, Access includes all the fields in the selected table.

Report tool

To format the text in a single text box or label, you can use the _____ button.

bold

Which of the following form controls can you format by applying a style to it?

button

How do you select a row in a control layout in Report Layout view?

click to the left of the row

A control layout in an Access report is a ____.

connected set of report controls

A report is an easy-to-use data entry and navigation screen.

false

Alternate colors are a set of coordinated colors to apply to reports and other database objects.

false

In Form Design view, you can make design changes while displaying the data.

false

In Report Layout view, you use the Format Painter to change the theme of a report.

false

You switch to Report Layout view to display the entire report as it will appear when printed.

false

You use conditional formatting to highlight important data in a report.

false

A report with _____ is a good candidate for a multicolumn report.

only a few fields

Where do you specify the number of columns for a report?

page Setup dialog box

To select more than one control in Form Design view, you _____ and then click each control.

press and hold the SHIFT key

To change the fonts in all the forms and reports in the database, you can change the _____.

theme fonts

A typical report in landscape orientation is 11 inches wide and 8.5 inches tall.

true

The Form Wizard prompts you for information it needs to create a form, such as the fields, layout, and title for the form.

true

When using the Report Wizard, you can click the Back button to review previous dialog boxes.

true

You can use the arrow keys to move a selected control in Report Design view.

true

You use the Field List to add fields to a form in Form Design view.

true

You use the Report tool to quickly create a report based on the selected table.

true

As you create a report, when might you want to work in Report Layout view?

when you want to view the data as you change the report