Navigating the Access 2010 Ribbon with Key Tips
If you like to use the keyboard as much as possible when you’re working with software, Access 2010 makes it somewhat easy to do that — somewhat because you need to use a special key in order to make the rest of the keyboard work as a commander.
When you want to switch tabs and issue commands with the keyboard in Access 2010 (rather than with the mouse), press the Alt key. As shown in the first figure, pressing Alt causes numbers and letters to appear in small squares on the Quick Access toolbar and the Ribbon’s tabs.
When the numbers and letters are visible, you can press one of those characters on your keyboard to issue a command (such as pressing 1 to Save) or to switch to a tab (such as pressing C to get to the Create tab).
Press the Alt key.
Key Tips appear on the Ribbon, the Microsoft Office Button, and the Quick Access Toolbar.
Press a Key Tip to set the focus to that item (like C in this case for the Create tab).
Key Tips appear for the item.
Press a Key Tip (like TN to create a new table).
The command assigned to the Key Tip runs.
For a full listing of Access keyboard shortcuts, search the Help system for Keyboard shortcuts for Access.