A visitor to the site asked about using ALT-TAB to switch between open Access windows.  This refers to the “Windows in Taskbar” feature which was available in Access prior to Access 2007.  You could set Access to display a button for every open Access window on the Windows Task Bar and use the standard ALT-TAB to switch between them.  I usually disabled it because I didn’t like all of those taskbar buttons for the same program.

This feature is no longer present in Access 2007 / 2010, although it’s still available for Word and Excel.  One option that is still available is the Ctrl-F6 key combination.  Using Ctrl-F6 or Shift-Ctrl-F6 (for reverse order) you can switch between all open windows in your Access program, including forms, open tables and the database widow.

Of  course, I usually design Access applications to keep only a couple windows open at a time and my forms have links or buttons that take the user back to the appropriate menu or screen.  During design time, though, or when you’re creating a quick and dirty app for analysis, this can come in handy.