ÍNDICE DE FIGURAS
PLANIFICACIÓN DE UN ECOE
label from all the group headers.
6
Click the control containing A, and drag it to the left edge of the header. Notice that when you release the mouse button, all the corresponding controls move to the corresponding location in their own group headers.KEYBOARD SHORTCUT Press the Arrow keys to move the selected control in small increments. When the shadow box is positioned where you want it, click away from the control. For a list of keyboard shortcuts, see “Keyboard shortcuts” at the end of this book.
7
Point to the right border of the selected A control, and when the pointer changes to a double-headed arrow, drag to the left until the control is just big enough to hold its contents. Notice that this action changes the size of all the corresponding controls.It is easier to work with the controls in the group header when the report details are hidden.
Let’s consolidate the controls in the group header so that they require less room.
8
With the A control still selected, hold down the Ctrl key, and in turn, click theProduct Name, Quantity Per Unit, and Units In Stock label controls to add them to the selection.
9
On the Design tab, in the Tools group, click the Property Sheet button to open theBecause more than one control is selected, the Selection Type in the Property Sheet pane is Multiple Selection.
10
On the Format page of the Property Sheet pane, in the Top property box, enter0 .25” and press the Enter key to align the controls a quarter inch from the top of the group header. Then close the Property Sheet pane.
11
To view how the group header looks with its data, in the Grouping & Totals group, click the Hide Details button to turn it off.The numbers in the Units In Stock column are right-aligned. Let’s center them.
12
Click the first text box control in the Units In Stock column, and on the Format tool tab, in the Font group, click the Center button.Modifying report design 147
5
Now let’s add some color and format the text.
13
On the Design tool tab, in the Themes group, click the Themes button, and in the gallery, click the Whisp thumbnail.TIP Although nothing much appears to change, the report has taken on the color scheme and font scheme assigned to the selected theme.
14
Inside the shaded area of the report header, but away from the title, click a blank area. On the Format tool tab, in the Control Formatting group, click the Shape Fillbutton. Then in the Theme Colors palette, click the third swatch in the third column row (Light Green, Background 2, Darker 25%).
By default, alternate group headers are a different color, which confuses rather than
clarifies the report structure. Let’s turn off this alternate row color.
15
Click outside the dotted border to the left of the first group header. In the Backgroundgroup, click the Alternate Row Color arrow, and in the menu, below the palettes, click
No Color.
16
In the Control Formatting group, click the Shape Fill button, and in the Theme Colors palette, click a light orange color. (We chose the third swatch in the sixth column: Orange, Accent 2, Lighter 60%.)TIP The entire group header is shaded except the alphabet controls (A, B, C, and so on) that you moved earlier. If you want them to be shaded, select one of them and repeat step 16 to apply the light orange fill.
17
Click outside the dotted border to the left of the first row of data in the report, andremove the alternate row color of the data rows. Then click the white space above the report header to verify that only the backgrounds of the report header and group headers are now colored.
TIP In Layout view, the only places you can click that don’t select at least one object are above the first object and below the last object.
Removing the alternate row color makes the structure of this report more obvious.
Next let’s format the text in the controls. It is usually most efficient to change the
character formatting of all the controls and then adjust the ones you want to be different.
18
Click any control, and then on the Format tool tab, in the Selection group, click theSelect All button.
KEYBOARD SHORTCUT Press Ctrl+A to select all the controls.
19
In the Font group, click the Font Size arrow, and then click 9.20
Click the report’s title control, and then use the commands in the Font group to make the text 24 points, Bold, and dark green. (We chose the fifth swatch in theninth column, Olive Green, Accent 5, Darker 25%.)
21
Select the controls in the group header, and make them bold and dark green.22
Scroll the report, noticing that a few of the values in the Units In Stock column are 0. Let’s make zero values bold and red so that they stand out in the report and alert buyers that it is time to order more of these products.23
Click any control in the Units In Stock column. Then in the Control Formatting group, click the Conditional Formatting button to open the Conditional Formatting Rules Manager.Modifying report design 149