The default format is the normal display in Microsoft Office

Paint PDF 417 in Microsoft Office The default format is the normal display

Figure 8-3: You have several comparisons from which to choose when selecting conditional formatting

9 10

Microsoft Of ce Access 2007 QuickSteps Preparing Your Data for Presentation PC QuickSteps Getting to Know Your PC

163 163

If the control contains a value, click the comparison down arrow (the default is Between) to choose from a list of comparison operators Type a constant value in the text box (the third box) and, depending on what you chose as your comparison operator, type another constant value in the fourth box Or

Click the formatting you want to appear for values (or expressions) that are true for the condition you set:

Click B to make the font bold Click I to set the font in italics Click U to underline the text Click the Fill/Back Color tool down arrow

6 7 8

to display a choice of background colors (clicking the tool itself applies the color displayed on the tool) to choose the font color

Right-click the form tab, and click Report View to see how your report looks with the conditional formatting applied, as seen in Figure 8-4

1 2 3 4

In the Design tab Tools group, click Property Sheet Click the Format tab Click the Back Style down arrow, and change the setting to Normal Right-click the form tab, and click Report View You should see the background color

You can add charts by copying them from other programs, such as Microsoft Excel; by creating your own using the Excel menus and tools within Access; or by using the Access Chart Wizard

164 164

Microsoft Of ce Access 2007 QuickSteps PC PC QuickSteps Getting to Know Your Preparing Your Data for Presentation

1 2 3 4 5 6 7

1 2 3 4

Open Microsoft Excel and locate the chart you want to insert Right-click the chart and click Copy Open the report or form in Design View, and right-click where you want to place the chart (See Select Design View Components, later in the chapter) Click Paste The chart is placed in an Unbound Object Frame box, which you can resize and move as necessary

9 10

Microsoft Of ce Access 2007 QuickSteps Preparing Your Data for Presentation PC QuickSteps Getting to Know Your PC

165 165

1 2 3

Open the report or form in Design View In the Design tab Controls group, click the Unbound Object Frame icon The Unbound Object Frame mouse pointer will appear Drag a rectangle on your form or report where you want to place the chart The Microsoft Office Access dialog box appears Click Create New In the Object Type list box, click Microsoft Office Excel Chart, and then click OK A sample chart opens and the Access ribbon is replaced with the

166 166

Microsoft Of ce Access 2007 QuickSteps PC PC QuickSteps Getting to Know Your Preparing Your Data for Presentation

To learn more about using Excel and charting, see Microsoft Office Excel 2007 QuickSteps, also published by McGraw-Hill

ribbon from Microsoft Office Excel 2007, containing charting tools and features, as shown in Figure 8-5

5 6

Click Change Chart Type in the Chart Tools Design tab Type group, or use the other tools to build the chart Click outside the chart to return to full Access functionality To edit the chart with Excel features, double-click it

1 2 3 4 5 6

Open the report or form in Design View In the Design tab Controls group, click the Insert Chart icon Drag a rectangle in the location where you want the chart The Chart Wizard appears Choose the table or query whose data you want to use Click Next Select the fields from the table or query that contain the data you want to see charted Click Next Choose a chart type Click a chart type to see its description displayed in the wizard, as shown in Figure 8-6

4 5 6 7