Deck 7: Summarizing Data With Pivottables

Question 1

To add a title to a report in Report Layout view,you click the _____ button on the Design tab.

A) Logo
B) Header
C) Title
D) Heading

Answer 1

C

Question 2

When you resize a label in Form Design view,_____.

A) you do not see the changes until you switch to Form view
B) you disconnect the label from its text box
C) you resize the label in all the other views
D) you do not have to save the design change

Answer 2

C

Question 3

After creating a report with the Report Wizard,you cannot add a sort to the report.

Answer 3

False

Question 4

Which of the following views provides the most options for creating and modifying a report?

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

Question 5

You can display page numbers on a report in a "Page 1 of 2" format.

Question 6

Which report section is most commonly used for dates and page numbers?

A) Page Header
B) Detail
C) Report Footer
D) Group Header

Question 7

You select a control layout so that you can move or change the controls as a group.

Question 8

To add a sort to a report in Report Design view,you use the _____ button.

A) Header & Footer
B) Sections
C) Group & Sort
D) A to Z

Question 9

Report Design View gives you full control of all aspects of a report.

Question 10

When you select a control in Form Design view,you can use _____ to resize the control.

A) arrow keys
B) conditional sizing
C) resizing handles
D) smart guides

Question 11

To add totals to a report column in Report Design view,you create a calculated control.

Question 12

If you want a query to select records for customers living in Ohio,which of the following fields should you add to the query design grid?

A) Phone
B) State
C) OrderAmt
D) Street

Question 13

In Report Design view,you add a field to a report using the _____.

A) Navigation Pane
B) Report Setup dialog box
C) Group,Sort,and Total pane
D) Field List

Question 14

To add a field to a report in Report Design view,you use the report's property sheet.

Question 15

Which of the following techniques can you use to resize a selected control in Report Design view? Select all the options that apply.

A) Drag a sizing handle.
B) Press an arrow key.
C) Press and hold the SHIFT key and then press an arrow key.
D) Double-click the control and then change the Height or Width property.

Question 16

You can change the margins of a report using the Margins button on the Print Preview tab.

Question 17

Changing the title of a report in Report Layout view also changes the name of the report.

Question 18

You can use the Format property to display dates in a report using a Short Date format.

Question 19

What property should you set to have the Department header section appear at the top of every printed page?

A) Repeat Section
B) Print Section
C) Every Page
D) After Section

Question 20

The _____ Builder helps you create a calculated field.

A) Syntax
B) Expression
C) Calculation
D) Field

Question 21

How can you quickly add the date and time to a report in Report Design view?

A) Add a calculated control containing the expression =DateAndTime().
B) Click the Calendar button on the Design tab.
C) Right-click a report section,and then click Calendar Picker on the shortcut menu.
D) Click the Date and Time button on the Design tab.

Question 22

When you delete a control from a form,you also delete the data it contains.

Question 23

Which of the following are Size options you can apply to selected controls? Select all the options that apply.

A) To Default
B) To Fit
C) To Tallest
D) To Widest

Question 24

Which of the following buttons on the Arrange tab do you use to increase the horizontal space between form controls?

A) Anchoring
B) Size/Space
C) Control Margins
D) Align

Question 25

You use a toggle button on a form to _____.

A) apply conditional formatting to the form
B) indicate a "yes" or "no" value
C) display a list of possible entries
D) provide tabbed pages of other controls

Question 26

Which of the following report controls can you format in bold?

A) Line
B) Label
C) Check box
D) Rectangle

Question 27

How do you align the right edges of selected controls in Form Design view?

A) Click the Align Right button on the Home tab.
B) Click the Align button on the Form Design Tools Arrange tab,and then click Right.
C) Click the Size/Space button on the Form Design tools Arrange tab,and then click Right.
D) Click the Align button on the Form Design Tools Format tab.

Question 28

Which of the following are formatting properties you can apply to many report controls?

A) Format
B) Text Align
C) Data Type
D) Width

Question 29

To select a control layout in Form Design view,you _____,and then click the plus sign icon to the left of the layout.

A) click a control in the layout
B) click the Selection button on the Home tab
C) click the vertical ruler next to the layout
D) switch to Form view

Question 30

Which of the following are formats you can apply to a Date control in Report Layout view? Select all the options that apply.

A) Short Date
B) General Date
C) Long Date
D) Year Only Date

Question 31

Which of the following pages numbers is displayed in the "Page N of M" format?

A) Page 1
B) Page 1 of 5
C) 1 of 5
D) Page 1/5

Question 32

To create a report based on an existing report named Clients,you can _____.

A) create a blank report and then import the Clients report
B) use the Report Wizard to select the Clients report as the record source
C) create a blank report using the property sheet from the Clients report
D) copy the Clients report and then paste it into the database with a new name

Question 33

You can use the _____ to apply the same formatting to multiple controls in a report.

A) Conditional Formatter
B) Format Painter
C) Shape Effects tool
D) Report tool

Question 34

What can you do when a report has blank pages in Print Preview?

A) Delete the blank page.
B) Click the Margins button on the Print Preview tab to change the report margins.
C) Insert a page break control.
D) Click the Zoom button on the Print Preview tab to hide the blank pages.

Question 35

Which of the following actions selects all the report controls in Report Design view?

A) Drag in the vertical ruler from the top to the bottom of the report.
B) Click each control in the report.
C) Double-click the report selector button.
D) Click a selector bar,press and hold the SHIFT key,and then click the other selector bars.

Question 36

Which of the following options are available on the navigation bar in Print Preview of a report? Select all the options that apply.

A) Next Page
B) New Page
C) First Page
D) Last Page

Question 37

In Print Preview,you can display the next page of a report by pressing the PAGE DOWN key.

Question 38

Which of the following techniques can you use to select all the controls in Report Design view? Select all the options that apply.

A) Click the Select All button on the Format tab.
B) Drag in the horizontal ruler from the left to the right margin of the report.
C) Click one control,press and hold the SHIFT key,and then click the other controls.
D) Click the report selector button.

Question 39

Which of the following features can the Format Painter apply to a label control in Form Layout view? Select all the options that apply.

A) underlining
B) text in the label
C) outline color and style
D) background color

Question 40

In Form Design view,you can align controls and their contents.