Deck 4: Analyzing and Charting Financial Data

Question 1

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

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

Answer 1

D

Question 2

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?

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.

Answer 2

A

Question 3

Conditional formatting can change the appearance of a report control based on criteria you specify.

Answer 3

True

Question 4

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

A) font size
B) font color
C) background color
D) alternate row color

Question 5

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

Question 6

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

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 7

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

A) stepped
B) tabular
C) datasheet
D) subform

Question 8

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

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?

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

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

Question 11

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

A) Layout
B) Record
C) Design
D) Form

Question 12

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

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

Question 13

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

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 14

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

Question 15

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

A) save location
B) fields
C) layout
D) title

Question 16

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

Question 17

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

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

Question 18

What happens when you apply a theme to a form?

A) The formatting changes in that form only.
B) The formatting changes in all forms and reports.
C) The original formatting is applied when you close the form.
D) The formatting changes appear in Form Design view only.

Question 19

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

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

Question 20

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

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

Question 21

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

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

Question 22

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

A) queries
B) tables
C) records
D) reports

Question 23

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

Question 24

To create a report in Report Layout view,click the Blank Report button on the Create tab.

Question 25

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

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

Question 26

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

A) Tabular
B) Stacked
C) Remove Layout
D) Split Layout

Question 27

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

A) removes the controls from the report
B) changes the arrangement of the controls
C) displays an error message
D) no longer groups the controls together in the report

Question 28

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

Question 29

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

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 30

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

A) theme
B) theme fonts
C) theme colors
D) theme margins

Question 31

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

A) page numbers
B) grouping field
C) sort order
D) orientation

Question 32

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

A) layout
B) background color
C) font color
D) font

Question 33

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

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 34

What happens in a table if you change the font color of the primary key field for the first record to red?

A) All of the records appear in red.
B) Only the first record appears in red.
C) Only the primary key field for the first record appears in red.
D) All of the primary key fields appear in red.

Question 35

Which of the following are common report enhancements?

A) font colors
B) command buttons
C) headers
D) footers

Question 36

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

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

Question 37

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