Microsoft Office Tutorials and References
In Depth Information
Integrating Access with Other Programs
When you create a form or report in Access, you include more than just the data from
the record source table or query. You’ve added controls such as lines, rectangles, tab con-
trols, and graphics in your forms and reports to improve their appearance and usability.
You can also add charts, drawings, and other objects to your forms and reports, but
Access doesn’t have the capability to create them. Instead, you create these other objects
using other programs and then place them in a form or report using the appropriate inte-
When you integrate information between programs, the program containing the origi-
nal information, or object, is called the source program , and the program in which you
place the information created by the source program is called the destination program .
Access offers three ways for you to integrate objects created by other programs.
• Importing . When you import an object, you include the contents of a file in a new
table or append it to an existing table, or you include the contents of the file in a form,
report, or field. For example, in Tutorial 2 you added a picture to a form, or imported it
into the form, and in this tutorial you imported CSV and XML files as new tables in the
Panorama database. The imported picture is a file with a .bmp extension that was cre-
ated by a graphics program, and the CSV and XML files were created by other
programs. Once an object is imported, it has no relation to the program in which it
was created. Any changes made to the object using the source program are not
reflected in the imported objects.
• Embedding . When you embed an object in a form, report, or field, you preserve its
connection to the source program, which enables you to edit the object, if necessary,
using the features of the source program. Any changes you make to the object are
reflected only in the form, report, or field in which it is embedded; the changes do not
affect the original object in the file from which it was embedded. Likewise, if you start
the source program outside Access and make any changes to the original object, these
changes are not reflected in the embedded object.
• Linking . When you link an object to a form, report, or field, you include a connection
in the destination program to the original file maintained by the source program; you
do not store data from the file in the destination program. Any changes you made to
the original file using the source program are reflected in the linked file version in the