Access 2010 For Dummies Cheat Sheet
Access 2010 makes managing your data easy, enabling you to set up a database quickly, build records into that database, and then use that data in several useful ways. With Access 2010, you can organize data into tables, design forms, and reports for editing and presenting information, and create queries for selecting and combining information — and you can do it all without having to go out and get a degree in Information technology!
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.
Access 2010 Keyboard Shortcuts to Know
These keyboard shortcuts are especially useful in Access 2010. Some keystrokes work anywhere in Access 2010, while others work only in specific views, as noted.
|F1||Opens the Help window|
|Alt+f||Opens Backstage view|
|Ctrl+n||Create a new blank database|
|Ctrl+o||Open an existing database|
|Ctrl+p||Opens Print dialog box|
|F11||Show/hide Navigation Pane|
|F6||Cycles different areas of program window|
|Alt+h||Displays Home tab on the Ribbon.|
|Alt+c||Displays the Create tab on the Ribbon|
|Alt+x||Displays the External Data tab on the Ribbon|
|Ctrl+s||Saves the current object in design mode|
|Ctrl+c||Copies selection to the clipboard|
|Ctrl+v||Pastes selection to the clipboard|
|F12||Opens the Save As dialog box|
|Ctrl+F4||Closes the active document window|
|Alt+F4||Closes the active application window|
|Ctrl+z||Undoes last operation|
|Ctrl+;||Inserts the current date|
|Ctrl+:||Inserts the current time|
|Ctrl+’||Copies same field data from previous record.|
|F2||Toggles selecting all data in the field or placing cursor in
|F9||Recalculates fields on a form or refreshes a lookup combo or
list box list
|Ctrl+Enter||Inserts a line break in datasheet and form view|
|Ctrl+Enter||Opens selected object from Navigation Pane in design view|
|Ctrl+Shift++||Inserts a new record|
|Ctrl+Shift+-||Deletes current record|
|Ctrl+Right Arrow||Moves selected control to the right in design or layout
|Ctrl+ Left Arrow||Moves selected control to the left in design or layout
|Ctrl+ Down Arrow||Moves selected control down in design or layout view|
|Ctrl+ Up Arrow||Moves selected control up in design or layout view|
|Shift+Right Arrow||Increases selected control width in design or layout view|
|Shift+ Left Arrow||Decreases selected control width in design or layout view|
|Shift+ Down Arrow||Increases selected control height in design or layout view|
|Shift+ Up Arrow||Decreases selected control height in design or layout view|
|F4||Toggles property sheet window in design view|
|Shift+F2||Zooms in on current field in datasheet and form view|