Access module 4

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

Use conditional formatting.

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.

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

False

To change the color of the labels in a report, select the label controls, and then click the Background Color button.

False

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

False

You can remove a control layout from a form in Form Design view or Form Layout view.

True

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

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

How is the font set for a table in Table Datasheet view?

You use the Font box on the Home tab.

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

layout

Compared to forms and datasheets, ____ give you more control over how data is arranged when printed.

reports

To close a form in Form Design view and keep Access running, you _____.

right-click the form tab, and then click Close on the shortcut menu.

In a form, how you can highlight the CustomerType text box only when it contains the value New?

Apply conditional formatting to the CustomerType text box.

In Form view, how can you navigate to the previous record in the form?

Click the Previous record button on the navigation bar.

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

Before closing a form in Form view, you must save changes you made to the data.

False

Which of the following are form views? Select all the options that apply.

Layout Form Design

Which button on the Form Design Tools Arrange tab do you use to remove a tabular layout from a form?

Remove Layout

The _____ button creates a new, blank report in Report Design view.

Report Design

When you click the Blank Report button on the Create tab, Access opens a blank report in _____.

Report Layout view

Which Access tool guides you through the steps of creating a report?

Report Wizard

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

Report tool

Which of the following formatting enhancements do themes apply to reports? Select all the options that apply.

font background color font color

After changing the _____ of a report control, you might also need to widen the control.

font size

Which of the following formatting changes can you make to a text box control in Form Design view? Select all the options that apply.

font size background color font color

Which of the following are common report enhancements?

footers font colors headers

When you remove a control layout from a report, Access ____

no longer groups the controls together in the report

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

sort order grouping field orientation

The two types of control layouts Access provides for forms are stacked and _____.

tabular

Which of the following features apply a coordinated set of changes to all the forms in the database? Select all the options that apply.

theme colors theme theme fonts

What information does the Form Wizard request as it creates a form? Select all the options that apply.

title layout fields