IN THIS CHAPTER
Understanding the differences between bound and unbound objects
Reviewing the differences between linking and embedding
Learning the different ways of storing these objects
Modifying an existing OLE object from your form design
Creating a graph and linking it to a form
Using Office integration in Access 2007
Creating an Excel PivotTable
Creating an Excel PivotChart
Access provides many powerful tools for enhancing your forms and reports. These tools let you add pictures, graphs, sound, and even video to your database application. Chart wizards make it easy to build business graphs and add them to your forms and reports. ActiveX controls extend the power of Access 2007; new features borrowed from Microsoft Office 2007 make using Access forms more productive than ever.
In this chapter, you learn about the different types of graphical and ActiveX objects you can add to your system. You learn how to manipulate them to create professional, productive screen displays and reports. You also learn how to use some of the new Office 2007 tools that work with Access 2007 forms.
This chapter uses the
Chapter24.accdb database. If you haven't already copied it onto your machine from the CD, you'll need to do so now.
Access gives you the capability of embedding pictures, video clips, sound files, business graphs, Excel spreadsheets, and Word documents. You can also link to any OLE (Object Linking and Embedding) object ...