Microsoft Office Tutorials and References
In Depth Information
Importing, Embedding, and Linking Data
How do you decide which method to use when you need to use data stored in another for-
mat in Access? You import a file as a new table or append the records in the file to an exist-
ing table when you intend to use Access to maintain the data and no longer need an
updated version of the data with the source program. You link to the data when the source
program will continue to maintain the data in the file, and you need to use an updated ver-
sion of the file at all times in the destination program. When linking to the data, you can also
maintain the data using the destination program, and the source program will always use
the updated version of the file.
For objects in forms or reports, you import an object (such as a picture) when you want a
copy of the object in your form or report and you don’t intend to make any changes to the
object. You embed or link an object when you want a copy of the object in your form or
report and you intend to edit the object using the source program in the future. You embed
the object when you do not want your edits to the object in the destination program to
affect any other copies of the object used by other programs. You link the object when you
want your edits to the object in the destination program to affect the object used by other
Sarah wants you to embed a chart on the second page of the tab control.
Embedding a Chart in a Form
The Chart Wizard in Access helps you to embed a chart in a form or report. The chart is
actually created by another program, Microsoft Graph, but the Chart Wizard does the
work of embedding the chart. After embeddng the chart in a form or report, you can edit
it using the Microsoft Graph program.
Reference Window | Embedding a Chart in a Form
• In the Controls group on the Design tab in Design view, click the Insert Chart button.
• Position the + portion of the pointer where you want to position the upper-left corner of
the chart, and then click the mouse button to start the Chart Wizard.
• Select the record source, fields, and chart type.
• Edit the chart contents, and select the fields that link the object and chart, if necessary.
• Enter a chart title, select whether to include a legend, and then click the Finish button.
The tblInvoice table contains the information needed for the chart Sarah wants you to
include in the form’s right tab in the tab control.
To add a chart in the tab control and start the Chart Wizard:
1. Switch to Design view, and then click the Invoice Chart tab on the tab control, if
2. In the Controls group on the Design tab, click the Insert Chart button , and
then move the pointer to the tab control. When the pointer is inside the tab con-
trol, the rectangular portion of the tab control you can use to place controls is filled