Question 1

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

Accepted Answer

A)  Report tool 
B)  Report Wizard 
C)  Blank Report tool 
D)  Report Design tool 
A)  Report tool 
B)  Report Wizard 
C)  Blank Report tool 
D)  Report Design tool

Question 2

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

Accepted Answer

A)  Use conditional formatting. 
B)  Bold the OrderAmt text box. 
C)  Change the font color of the OrderAmt label. 
D)  Change the background color of the OrderAmt text box. 
A)  Use conditional formatting. 
B)  Bold the OrderAmt text box. 
C)  Change the font color of the OrderAmt label. 
D)  Change the background color of the OrderAmt text box.

Question 3

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

Accepted Answer

A)  font colors 
B)  layout 
C)  theme 
D)  font styles 
A)  font colors 
B)  layout 
C)  theme 
D)  font styles

Question 4

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

Accepted Answer

A)  Report Design view 
B)  Control Wizard 
C)  Report Wizard 
D)  Report Previewer 
A)  Report Design view 
B)  Control Wizard 
C)  Report Wizard 
D)  Report Previewer

Question 5

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

Accepted Answer

A)  Apply conditional formatting to the CustomerType text box. 
B)  Change the font color of the text "New" the first time it appears in the form. 
C)  Move the CustomerType text box to the top of the form. 
D)  Use the Format Painter to apply a highlight to the CustomerType text box. 
A)  Apply conditional formatting to the CustomerType text box. 
B)  Change the font color of the text "New" the first time it appears in the form. 
C)  Move the CustomerType text box to the top of the form. 
D)  Use the Format Painter to apply a highlight to the CustomerType text box.

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  Change the alternate row color in the Detail section. 
B)  Change the font color of the text box in the Report Footer. 
C)  Change the font color of the label in the Report Header. 
D)  Change the style applied to the label in the Detail section. 
A)  Change the alternate row color in the Detail section. 
B)  Change the font color of the text box in the Report Footer. 
C)  Change the font color of the label in the Report Header. 
D)  Change the style applied to the label in the Detail section.

Question 9

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

Accepted Answer

A)  When you want to view the report as it will appear when printed. 
B)  When you want to hide the data and concentrate on the report design. 
C)  When you want to view the report without any formatting. 
D)  When you want to view the data as you change the report. 
A)  When you want to view the report as it will appear when printed. 
B)  When you want to hide the data and concentrate on the report design. 
C)  When you want to view the report without any formatting. 
D)  When you want to view the data as you change the report.

Question 10

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

Accepted Answer

A)  Access controls the font automatically. 
B)  You use the Format box on the Table Tools Design tab. 
C)  Access prompts you for the font when you create the table. 
D)  You use the Font box on the Home tab. 
A)  Access controls the font automatically. 
B)  You use the Format box on the Table Tools Design tab. 
C)  Access prompts you for the font when you create the table. 
D)  You use the Font box on the Home tab.

Question 11

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

Accepted Answer

A)  Click the Back button on the Home tab. 
B)  Click the left arrow button on the left side of the form. 
C)  Click the Previous record button on the navigation bar. 
D)  Click the Previous button in the status bar. 
A)  Click the Back button on the Home tab. 
B)  Click the left arrow button on the left side of the form. 
C)  Click the Previous record button on the navigation bar. 
D)  Click the Previous button in the status bar.

Question 12

When using the Form Wizard,you can select fields from tables and _____ in the database.

Accepted Answer

A)  other forms 
B)  reports 
C)  themes 
D)  queries 
A)  other forms 
B)  reports 
C)  themes 
D)  queries

Question 13

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

Accepted Answer

A)  font color 
B)  background color 
C)  shape outline 
D)  font size 
A)  font color 
B)  background color 
C)  shape outline 
D)  font size

Question 14

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?

Accepted Answer

A)  You can change the orientation of the report to landscape. 
B)  You can change the theme colors in the report. 
C)  You can switch to Report view. 
D)  You can change the report to a different type of object. 
A)  You can change the orientation of the report to landscape. 
B)  You can change the theme colors in the report. 
C)  You can switch to Report view. 
D)  You can change the report to a different type of object.

Question 15

In Report Design view,you remove a control layout from a report using the Control Padding button.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A)  Report Design view 
B)  Report view 
C)  Print Preview 
D)  Report Layout view 
A)  Report Design view 
B)  Report view 
C)  Print Preview 
D)  Report Layout view

Question 17

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

Accepted Answer

A)  right-click the form tab,and then click Close on the shortcut menu. 
B)  right-click the form in the Navigation Pane,and then click Close on the shortcut menu. 
C)  click the Close button on the title bar 
D)  drag the form tab to the Navigation Pane 
A)  right-click the form tab,and then click Close on the shortcut menu. 
B)  right-click the form in the Navigation Pane,and then click Close on the shortcut menu. 
C)  click the Close button on the title bar 
D)  drag the form tab to the Navigation Pane

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

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

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

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

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

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

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

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

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

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

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

When using the Form Wizard,you can select fields from tables and _____ in the database.

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

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?

In Report Design view,you remove a control layout from a report using the Control Padding button.

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

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

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters

Exam 4: Analyzing and Charting Financial Data

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

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

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

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

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

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

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

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

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

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

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

When using the Form Wizard,you can select fields from tables and _____ in the database.

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

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?

In Report Design view,you remove a control layout from a report using the Control Padding button.

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

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

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters