K.3. Access Managers

In addition to builders and wizards, Access has three very powerful managers. We don't know what we would do without the Linked Table Manager to quickly link or re-link to data files. Granted, we could create our own tools or use add-ins to provide these functions, but for the most part, these do an incredible job. I admit that I often create my own main menu, but there are still plenty of instances in which a switchboard is ideal.

These managers are consistent, they work, and they are quick and easy to use.

ManagerDescriptionLocation
Add-In Manager*In addition to installing and uninstalling wizards, builders, and add-ins, the Add-In Manger helps to create wizards and install your own add-inTools | Add-Ins
Linked Table Manager*Allows linking and changing links to tables in external databases as well as through some ODBC connections, such as with Excel.Tools | Database Utilities
Switchboard ManagerCreates and manages switchboard forms for applicationsTools | Database Utilities

Get Access 2003 VBA Programmer's Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.