Deck 10: Adding Advanced Features to Reports

Question 1

The ____ Wizard will take you through the steps of creating a report.

A) Report
B) Parameter
C) Display
D) Calculate

Answer 1

A

Question 2

By adding basic formatting to a report before you apply a(n) schema , the theme formats are enhanced.

Answer 2

False

Question 3

When a report is based on a parameter query, each time you open the report, the ____ box appears.

A) control
B) combo
C) text
D) message

Answer 3

D

Question 4

Sum is an example of a function that may be used in a(n) chart .

Question 5

To reopen the Navigation pane, you can click the ____ button.

A) Reopen
B) Open
C) Open Shutter Bar
D) Reopen Shutter Bar

Question 6

Access can only create pie charts.

Question 7

By selecting multiple controls, you have the ability to apply formats to several controls at one time.

Question 8

You access the Report Wizard by clicking the Create tab on the Ribbon.

Question 9

If you change the theme, all the reports in the database with themes are ____.

A) changed when the database is closed
B) changed at the same time
C) changed when the database is restarted
D) not affected

Question 10

To view more of a report, click the Close Shutter Bar button on the Navigation pane.

Question 11

When using a report based on a parameter query, you need to create several reports.

Question 12

Avg is one of the functions available in a summary report.

Question 13

A control text box displays the actual data from the table.

Question 14

A(n) double-headed arrow is used to resize a control field.

Question 15

Clicking Close Print Preview takes you into ____ view.

A) Report
B) Design
C) Data
D) Layout

Question 16

When creating a report, you add a currency format before you apply themes.

Question 17

Basing a report on a parameter query is useful if you need to run multiple reports that display unique information.

Question 18

You can specify up to three conditions for a field.

Question 19

Charts are simple to make and format.

Question 20

You can add grouping options to a report.

Question 21

A(n) ____________________ displays a message box for you to enter parameter data each time you run the query.

Question 22

When you change control formats, you will typically be changing the text box when the ____ is displayed.

A) record
B) field
C) data
D) property

Question 23

FIGURE AC 10-17 In Figure AC 10-17 above, the expression categories area is referenced by ____.

A) Item 1
B) Item 2
C) Item 3
D) Item 4

Question 24

FIGURE AC 10-17 In Figure AC 10-17 above, the box where an expression will be entered is referenced by ____.

A) Item 1
B) Item 2
C) Item 3
D) Item 4

Question 25

Access offers formatting features that you can apply to a ____ to make it a professional representation of the data.

A) page
B) chart
C) sheet
D) document

Question 26

The controls in a report have multiple ____ that can be changed once they are added to the report.

A) styles
B) themes
C) functions
D) properties

Question 27

Case AC 10-1 John is working on the annual sales report for the Rain Flower Media Corporation. After adding the currency format to the total sales field, John runs the report and directs the results to his monitor. To his dismay, the total sales column displays pound signs (#) instead of his sales total figures. The report is due tomorrow and he desperately needs your assistance. What would you recommend John do to correct the problem with the pound signs(#) displaying?

A) Increase the width of the Sales text box.
B) Correct his calculating formula.
C) Use a wide-screen monitor.
D) Send the report to a printer.

Question 28

When you select controls in a report, you ____ to select the control.

A) click
B) double-click
C) right-click
D) triple-click

Question 29

Case AC 10-2 Stella Maroon owns the Stellar boutique in Malibu. Every month she must reconcile her inventory and take note of customer purchasing trends. One of her Paris suppliers is insisting that a blue cashmere shawl is going to be the latest trend over the next three months. Stella has some doubts, and would like to see some additional boutique sales reports to see if her clients are indeed trending towards shawls. She asks if you could assist her in creating these reports. What is a valid option selection for Stella's new report?

A) Stella can only select the Avg function.
B) The Min and Max functions cannot be selected simultaneously.
C) Stella can select the Avg, Sum, Min and Max functions simultaneously.
D) If Stella selects the Avg function, she must also select the Sum function.

Question 30

Case AC 10-1 John is working on the annual sales report for the Rain Flower Media Corporation. After adding the currency format to the total sales field, John runs the report and directs the results to his monitor. To his dismay, the total sales column displays pound signs (#) instead of his sales total figures. The report is due tomorrow and he desperately needs your assistance. Why is John's sales report displaying the pound signs (#)?

A) The calculating formula is dividing by zero.
B) Monitors cannot display reports properly.
C) The sales control may not be wide enough to display entire sales amount.
D) The calculating formula has an invalid field.

Question 31

A control has ____ parts.

A) one
B) two
C) three
D) four

Question 32

To create a chart, you use the ____ Wizard option.

A) Graph
B) Report
C) Chart
D) Presentation

Question 33

Case AC 10-2 Stella Maroon owns the Stellar boutique in Malibu. Every month she must reconcile her inventory and take note of customer purchasing trends. One of her Paris suppliers is insisting that a blue cashmere shawl is going to be the latest trend over the next three months. Stella has some doubts, and would like to see some additional boutique sales reports to see if her clients are indeed trending towards shawls. She asks if you could assist her in creating these reports. What type of report would you suggest Stella run against her data to see trends in customer purchases?

A) control report
B) parameter report
C) trend report
D) summary report

Question 34

By adding a calculated control in the report ____, the total of the sales will be displayed at the end of the report.

A) base
B) footer
C) record
D) expression builder form

Question 35

The label typically appears either above or ____ the text box.

A) to the left of
B) to the right of
C) under
D) on top of

Question 36

When a report selector is selected, it appears with a dark ____.

A) arrow
B) circle
C) triangle
D) square

Question 37

Using the ____ button, you can apply formats to more than one object, such as several labels.

A) Format Painter
B) Format
C) Painter
D) Paint

Question 38

To move a control in Design view, you can select the control, press and hold the ____ key, and then press the arrow keys to move the control right, left, up, or down.

A) CTRL
B) TAB
C) SHIFT
D) ALT

Question 39

Click the Design tab, and then click the Themes button ____ in the Themes group to display the Themes gallery.

A) check box
B) arrow
C) square
D) icon

Question 40

To begin increasing a text box width in Layout view, you place the pointer over the left side of the control until the pointer turns into a ____.

A) crosshair
B) solid black square
C) circle
D) double-headed arrow

Question 42

A(n) ____________________ control lets you use functions to add a calculation to a report.

Question 43

To select several controls, you press and hold ____________________ and then click on each control you want to select.

Question 44

Describe when to use a summary report and briefly describe the possible functions. Include a discussion on how to create a summary report.

Question 45

____________________ let you add borders, background colors, shading, and graphic effects to an entire report at one time.

Question 46

____________________ formatting allows you to add formatting features to the data based on criteria you specify.