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