Create custom reports - Microsoft Access 2013 - page 258

Adding hyperlinks, charts, and buttons
A variety of additional controls are available to enhance the usefulness of reports and
forms, such as the following:
▪ Hyperlink Clicking the Hyperlink button in the Controls gallery displays the
Insert Hyperlink dialog box. You can insert a static link to a file, a webpage,
another object in the database, or an email message window by using the same
techniques you would use to insert a hyperlink in other Microsoft Office 2013 pro-
grams. For example, you might want to add a link to your organization's website.
TIP In forms, you can use a Web Browser control to insert a dynamic hyperlink
that changes depending on the data displayed. To set up dynamic links, click
Hyperlink Builder in the Link to bar of the Insert Hyperlink dialog box to separate
the target address into its component parts. For more information about the Web
Browser control, search for Add Web browsing to a form in Access Help.
▪ Chart You can use the Chart wizard to plot the data in an existing table or query
(or both). In the Controls gallery, click the Chart button, and then drag to create
the control that will hold the chart and start the Chart wizard. Follow the wizard's
instructions to select the data that will be plotted, the type of chart, and the lay-
out. When you click Finish , the chart appears in the control, which you can move
and size like any other control.
▪ Button You can create a button that performs a specific task, such as displaying
the Print dialog box. To add a button to a report, click the Button button, and
click to create the button control. Right-click the control, and click Build Event .
Double-click Macro Builder , and in the Actions area in the Action Catalog pane,
expand the type of action you want. Double-click the action to open a page on
which you can add any information the macro needs, and then close the page. You
can assign a name and picture to the button on the Format page of its Property
Sheet pane.
TIP Adding a button to a form is much easier than adding one to a report. In
the Controls gallery, click the Button button, and then click to create the button
control and start the Command Button wizard. Follow the wizard's instructions to
select the action, icon, and name for the button. Click Finish to insert the button
in the location you clicked. You can then move and size it like any other control.
Behind the scenes, the wizard embeds a macro in the control's On Click property.
To view the macro, display the Event page of the button's Property Sheet pane,
and then click the Ellipsis button to open the page containing the macro.