ch06.htm

Microsoft_Access_97_Quick_Reference.zip

			</BLOCKQUOTE>

			<H2><FONT COLOR="#000077"><B>Chart: Edit</B></FONT></H2>
			<P>In order to add labels, change colors, or change chart types, you need to be in
			Microsoft Graph, the applet that comes with Microsoft Office. The <I>Chart Wizard</I>
			automatically uses Microsoft Graph but you can also double-click a chart to enter
			this applet.
			<H3><FONT COLOR="#000077"><B>Steps</B></FONT></H3>
			<OL>
				<B>1.</B> In <I>Design View</I> of a <I>report</I> or <I>form</I>, double-click the
				chart to open Microsoft Graph.
				<P><B>2.</B> Select the part of the chart you want to modify. For data series, you
				click once to select an entire data series. You click a second time to select an
				individual point in the series. To select the entire chart, click outside the chart.</P>
				<P><B>3.</B> Right-click the selected object to bring up the shortcut menu. Make
				choices on the dialog boxes specific to the object. Choose OK when finished with
				each dialog box.</P>
				<P><B>4.</B> Repeat Steps 2 and 3 for each object you want to change.</P>
				<P><B>5.</B> When finished with your changes, click the Close (X) button in Microsoft
				Graph's upper right corner.</P>
				<P><B>6.</B> Back in Design View of the report or form, click the Save button to
				save the changes to your chart.
			</OL>
			<H2><FONT COLOR="#000077"><B>Chart: Grid Display</B></FONT></H2>
			<P>Use <I>gridlines</I> to help viewers compare markers and read values in a chart.
			If you use the Chart Wizard to create a chart, Access enables you to add gridlines
			as you are creating the chart.</P>
			<P>You can add gridlines that originate from either the category or value axis, or
			both.
			<H3><FONT COLOR="#000077"><B>Steps</B></FONT></H3>
			<OL>
				<B>1.</B> In <I>Design View</I> of a <I>report</I> or <I>form</I>, double-click the
				chart to open Microsoft Graph.
				<P><B>2.</B> Click the Category Axis Gridlines or Value Axis Gridlines buttons on
				the toolbar to turn gridlines on or off.
			</OL>
			<H2><FONT COLOR="#000077"><B>Chart: Labels Enter</B></FONT></H2>
			<P>You can add a <I>label</I> attached to a specific portion of a chart (See also
			&quot;Chart: Titles Add&quot; and &quot;Chart: Data Labels&quot;) or add a label
			and move it anywhere you want.
			<H3><FONT COLOR="#000077"><B>Steps</B></FONT></H3>
			<OL>
				<B>1.</B> In Design View of a report or form, double-click the chart to open Microsoft
				Graph.
				<P><B>2.</B> Type new text and press Enter.
			</OL>
			<P>You can move the label by selecting it and then dragging an edge of the title
			with the left mouse button to the desired location. If you select an existing label
			and then type, you replace the existing text. To delete a label, select it and press
			Delete. To edit a label, click once to select it and then position the mouse I-beam
			in the text and add or delete text.
			<H2><FONT COLOR="#000077"><B>Chart: Legend Display</B></FONT></H2>
			<P>A legend explains the markers or symbols used in a chart. When you use the <I>Chart
			Wizard</I> to create a chart, Access asks if you want to create a legend by default,
			based on the labels of the values you added to the Series box. You can edit the chart
			to add or remove the legend. You also can customize a legend with border, pattern,
			and font selections.
			<H3><FONT COLOR="#000077"><B>Steps</B></FONT></H3>
			<OL>
				<B>1.</B> In Design<I> </I>View of a report or form, double-click the chart to open
				Microsoft Graph.
				<P><B>2.</B> Click the Legend button on the toolbar to turn the legend on or off.
			</OL>
			<P>You can move the legend by selecting it and then dragging the legend to the desired
			location. To resize the legend, select it and then drag one of the black handles
			surrounding the legend.


			<BLOCKQUOTE>
			<P>
<HR>
<FONT COLOR="#000077"><B>TIP:</B></FONT><B> </B>To format the legend, right-click
			the legend and choose F<U>o</U>rmat Legend from the shortcut menu. Make your desired
			selections from the Format Legend <I>dialog box</I> and then click OK. 
<HR>


			</BLOCKQUOTE>

			<H2><FONT COLOR="#000077"><B>Chart: Titles Add</B></FONT></H2>
			<P>You can add titles to help explain the data in your chart. Normally, you should
			include a main chart title, as well as titles for the category and value axes. If
			you use the <I>Chart Wizard</I> to create a chart, Access enables you to add chart
			titles as you are creating the chart. You also can choose to add chart titles later,
			or modify existing chart titles.
			<H3><FONT COLOR="#000077"><B>Steps</B></FONT></H3>
			<OL>
				<B>1.</B> In <I>Design View</I> of a <I>report</I> or <I>form</I>, double-click the
				chart to open Microsoft Graph.
				<P><B>2.</B> Choose <U>C</U>hart, Chart <U>O</U>ptions; then click the Titles tab
				in the Chart Options <I>dialog box</I>.</P>
				<P><B>3.</B> Select the <I>text box</I> for the title you want to add (such as Chart
				<U>T</U>itle), and type the title; then click OK.
			</OL>
			<P>You can move the title by selecting it and then dragging an edge of the title
			to the desired location. To delete a title, select it and press Delete.


			<BLOCKQUOTE>
			<P>
<HR>
<FONT COLOR="#000077"><B>TIP:</B></FONT><B> </B>To format a chart title, right-click
			the title and choose F<U>o</U>rmat Title from the shortcut menu. Make your desired
			selections from the Format Title dialog box and then click OK. 
<HR>


			</BLOCKQUOTE>

			<H2><FONT COLOR="#000077"><B>Chart: Trendlines</B></FONT></H2>
			<P>You can add a trendline to a chart to show the direction of the charted data and
			to make predictions. Regression analysis is used to create the trendline from the
			chart data. You can choose from five types of regression lines or calculate a line
			that displays moving averages.
			<H3><FONT COLOR="#000077"><B>Steps</B></FONT></H3>
			<OL>
				<B>1.</B> In <I>Design View</I> of a <I>report</I> or <I>form</I>, double-click the
				chart to open Microsoft Graph.
				<P><B>2.</B> Choose <U>C</U>hart, Add T<U>r</U>endline; then select the Type tab
				in the Add Trendline <I>dialog box</I>.</P>
				<P><B>3.</B> Select the data series for which you want to create a trendline in the
				Based On <U>S</U>eries list.</P>
				<P><B>4.</B> Select from the six Trend/Regression types: <U>L</U>inear, L_ogarithmic,
				<U>P</U>olynomial, Po<U>w</U>er, E_xponential, and <U>M</U>oving Average. For more
				information on these types, click the question mark in the title bar of the dialog
				box, then click the option for which you want more information.</P>
				<P><B>5.</B> Select the Options tab if you want to set any additional options for
				the trendline, such as the Trendline Name or Forecast options. Click OK.
			</OL>
			<H2><FONT COLOR="#000077"><B>Chart: Type Change</B></FONT></H2>
			<P>You can change an Access chart type to represent another type of data. You can
			change to any of the chart types that Access offers--bar charts, line charts, pie
			charts, or special custom charts like floating bar charts.


			<BLOCKQUOTE>
			<P>
<HR>
<FONT COLOR="#000077"><B>NOTE:</B></FONT><B> </B>While it is fun to play with all
			the different chart types that come with Access, try to pick something that your
			audience will understand and that is appropriate to understanding the data. 
<HR>


			</BLOCKQUOTE>

			<H3><FONT COLOR="#000077"><B>When to Change Chart Types</B></FONT></H3>
			<P>You should use an appropriate chart type for the data you want to chart. The following
			list illustrates some common chart types and explains their purpose. For more detailed
			information on all the chart types, and examples of their use, search on &quot;example
			chart types&quot; in Microsoft Graph help.
			<UL>
				<B>Column chart</B>. Illustrates individual values at a specific point in time or
				summarizes changes in a text value. The column chart emphasizes variation over time.
				<P><B>Bar chart</B>. Same as a column chart, but displays bars horizontally rather
				than vertically. This emphasizes values and there is less focus on time.</P>
				<P><B>Line chart</B>. Illustrates changes in a large number of values over equal
				time intervals.</P>
				<P><B>Pie chart</B>. Shows the <I>relationship</I> of each item to the sum of the
				items.</P>
				<P><B>XY (Scatter) chart</B>. Plots two groups of numbers as one series of XY coordinates;
				commonly used in scientific applications.</P>
				<P><B>Area chart</B>. Shows how volume changes over time and emphasizes the amount
				of change.
			</UL>
			<H3><FONT COLOR="#000077"><B>Steps</B></FONT></H3>
			<OL>
				<B>1.</B> In <I>Design View</I> of a <I>report</I> or <I>form</I>, double-click the
				chart to open Microsoft Graph.
				<P><B>2.</B> Right-click in a blank area of the chart, and choose Chart <U>T</U>ype
				from the shortcut menu.</P>
				<P><B>3.</B> In the Chart Type <I>dialog box</I>, click the Standard Types or Custom
				Types tab.</P>
				<P><B>4.</B> Select the chart type you want; then click OK. Resize the chart, if
				necessary.
			</OL>


			<BLOCKQUOTE>
			<P>
<HR>
<FONT COLOR="#000077"><B>NOTE:</B></FONT><B> </B>In some cases, data can be more
			effective when presented in a Totals <I>query</I> or report. (See also &quot;Calculations:
			Sum of Values&quot; in the Calculations part of this book.) Don't overload your charts
			with too many data points. Combine data into logical units to make your charts more
			effective. 
<HR>
</P>
			<P>
<HR>
<FONT COLOR="#000077"><B>TIP:</B></FONT><B> </B>You can change the chart type for
			just one of the of the series. Right-click the bar or line for the series and choose
			Chart <U>T</U>ype. The other data series are graphed in the old type, while the selected
			series is graphed with the new type. 
<HR>


			</BLOCKQUOTE>

			<H2><FONT COLOR="#000077"><B>Controls: ActiveX Add</B></FONT></H2>
			<P><I>ActiveX controls</I> provide additional functionality for your forms. They
			provide additional input options or show feedback. The Calendar <I>control</I> is
			an option you can select during setup. If you have the Developer Edition of Microsoft
			Office, you have access to additional ActiveX controls. You can also buy additional
			controls from third-party vendors and perhaps download controls from the Web. Before
			you can complete this task, you must register the ActiveX control. (See also &quot;Controls:
			ActiveX Register.&quot;)


			<BLOCKQUOTE>
			<P>
<HR>
<FONT COLOR="#000077"><B>NOTE:</B></FONT><B> </B>In versions prior to Access 97,
			ActiveX controls were referred to as OLE (Object Linking and Embedding) controls
			or custom controls. 
<HR>


			</BLOCKQUOTE>

			<H3><FONT COLOR="#000077"><B>Steps</B></FONT></H3>
			<OL>
				<B>1.</B> Open a <I>form</I> in <I>Design View</I>.
				<P><B>2.</B> Click the More Controls button on the <I>Toolbox</I> and select the
				control from the list.</P>
				<P><B>3.</B> Drag the mouse to draw the location where you want the control to be
				placed on your form.</P>
				<P><B>4.</B> After the control appears on your form, right-click the <I>object</I>
				and set its specific properties through the controlname <U>O</U>bject choice on the
				shortcut menu.</P>
				<P><B>5.</B> To program other properties and events, right-click the object and choose
				the item in the <I>Property</I> sheet.
			</OL>


			<BLOCKQUOTE>
			<P>
<HR>
<FONT COLOR="#000077"><B>NOTE:</B></FONT><B> </B>For additional help on specific
			ActiveX controls, reference them in help. For Developer Edition tools, the help will
			be integrated with Access Contents and <I>Index</I> help (not necessarily the <I>Office
			Assistant</I>). For other controls, you will need to read the help that comes with
			the controls. 
<HR>


			</BLOCKQUOTE>

			<H2><FONT COLOR="#000077"><B>Controls: ActiveX Register</B></FONT></H2>
			<P>Before you can use an ActiveX control, you need to register it. Some controls