O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

J.3. Access Managers

In addition to builders and wizards, Access has five very powerful managers. Granted, there are times that it works well to create your own tools or use add-ins to provide these functions, but for the most part, the managers do an incredible job. The beauty of managers is that they work right out of the box. They are quick and easy to use, and they provide consistency. There are no changes to the managers in Access 2007, so if you've been using the managers, they will be like old friends.

ManagerDescriptionLocation
Add-InIn addition to installing and uninstalling wizards, builders, and add-ins, the Add-In Manager helps create wizards and helps you to install your own add-ins.Database Tools Ribbon tab; select Add-ins in the Database Tools group.
Linked TableAllows linking and changing links to tables in external databases as well as through some ODBC connections, such as with Excel.Database Tools Ribbon tab; select Linked Table Manager in the Database Tools group.
Manage Data Collection MessagesTracks the status and allows changes to settings of e-mails used for data collections. Allows messages to be resent or deleted.External Data ribbon tab, on Collect Data, click Manage Replies.
Manage Data TasksView and manage saved import and export specifications. Allows changes to general aspects such as the specification name and file path, but does not allow changes to details, such as the tables, fields, and worksheets. Can create an Outlook Task.External Data Ribbon ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required