Access 2007 Tip: Navigation Pane Search and Sort

Submitted by admin on Mon, 03/29/2010 - 00:00

Right-click the title bar of the navigation pane in Access 2007 for two useful options.

The Search bar performs a like *value* filter on the object name. This is really handy if you have a naming convention and want to quickly narrow down the displayed list.

The Custom Sort option allows you to sort the objects in a custom order.
Another easy way to locate and open objects is with the keyboard shortcuts. Ctrl+F will automatically turn on the search bar. You can use the down arrow to select an item then press Enter key to open it.