Deck 7: Summarizing Data With Pivottables

Question 1

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

Answer 1

True

Question 2

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.

Answer 2

A, C, D

Question 3

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

Answer 3

D

Question 4

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

Question 5

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

A) Repeat

Question 6

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

Question 7

To resize a control in Report Layout view, you format an edge of the selected control.

Question 8

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

Question 9

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

Question 10

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

Question 11

In Report Layout view, you can work with sections and make changes that you cannot make in other views.

Question 12

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

Question 13

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

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

Question 14

The _____ Builder helps you create a calculated field.

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

Question 15

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

Question 16

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 17

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 18

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 19

You use the Header button to add a title to a report in Report Design view.

Question 20

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

Question 21

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

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

Question 22

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 23

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 24

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 25

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 26

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 27

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 28

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 29

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 30

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 31

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

Question 32

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

Question 33

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

Question 34

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 35

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

A) Header & Footer
B)

Question 36

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

Question 37

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 38

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

Question 39

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 40

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 41

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 42

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 43

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.