Access™ 2007 Bible

Chapter 24. Using ActiveX Controls

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

• Customizing graphs

• 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.

Note

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.

Understanding Objects

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 ...