MS Access : All Shortcut Keys
General Shortcuts
Database
Navigation Keys
Others
| Shortcut Keys | Functions | 
| F1 | Display the Microsoft Access Help, This may be context-sensitive help depending on what you are positioned on | 
| F11 | Display the Database window | 
| F12 | Open the Save As dialog box | 
| CTRL+N | Open a new database | 
| CTRL+O | Open an existing database | 
| CTRL+P | Print the current or selected object | 
| CTRL+S | Save the current database object | 
| CTRL+W | Close the active window | 
| ALT+SPACEBAR | Display the Control menu | 
| ALT+F11 | Toggle between the Visual Basic editor and the Access Database window | 
| SHIFT+F10 | Display the shortcut menu (ie: popup menu) | 
Database
| Shortcut Keys | Functions | 
| Ctrl+N | Open/create new database | 
| Ctrl+O | Open existing database | 
| Alt+F4 | Quit/ exit Access | 
| Ctrl+P | Print the current or selected object | 
| Ctrl+S | Save a database object (or Shift+f12) | 
| F12 | Open the Save As dialog box | 
Navigation Keys
| Shortcut Keys | Functions | 
| Ctrl+Tab/Ctrl+Shift+Tab | Switch to next tab / switch to previous tab in a dialog box | 
| Tab/Shift+Tab | Move to the next / switch to previous option or option group | 
| Arrow Keys | Move between options | 
| Space | Select current button | 
| Alt+Arrow Down | Open the selected drop-down list box | 
| Esc | Close the selected drop-down list box | 
| Enter | Perform the action assigned to the default button in the dialog box | 
| Esc | Cancel the command and close the dialog box | 
| Alt+F4 | Close a dialog box | 
| Home/End | Move beginning / move to end of an entry | 
| Ctrl+Arrow Left/Ctrl+Arrow Right | Move one word to the left or right | 
| Shift+Home/Shift+End | Select from cursor to end / to beginning | 
| Shift+Arrow Left/Shift+Arrow Right | Extend selection one character to the left / to the right | 
| Tab/Shift+Tab | Select next field / select previous field | 
| Shift+Space | Switch between selecting the current record and the first field of the current record | 
| Shift+Arrow Up/Shift+Arrow Down | Extend selection to previous record/ to next record | 
| Ctrl+A | Select all records (or Ctrl+Shift+Space) | 
| F8 | Turn on Extend mode | 
| Arrow Left/Arrow Right | Extend a selection to adjacent fields in the same row in Datasheet view | 
| Arrow Up/Arrow Down | Extend a selection to adjacent rows in Datasheet view | 
| Shift+F8 | Undo the previous extension | 
| Esc | Cancel Extend mode | 
| Ctrl+Space | Select the current column | 
| Shift+Arrow Right/Shift+Arrow Left | Select the column to the right / to the left, if the current column is selected | 
| Ctrl+Shift+F8 | Turn on Move mode | 
| F5 | Move to the record number box, type in number and press enter | 
| Tab/Shift+Tab | Move to next / move to previous field in current record | 
| Home/End | Move to first / move to last field in current record | 
| Arrow Down/Arrow Up | Move to next / move to previous record | 
| Ctrl+Arrow Down/Ctrl+Arrow Up | Move to last record / move to first record (or current field in next record / in previous record when in subdatasheet) | 
| Ctrl+Home/Ctrl+End | Move to first field in first record / last field in last record | 
| Page Down/Page Up | Move down one screen / move up one screen | 
| Ctrl+Page Down/Ctrl+Page Up | Move right one screen / left one screen | 
| Ctrl+Tab/Ctrl+Shift+Tab | In subdatasheet: Exit to next / to previous record | 
| Ctrl+Shift+Arrow Down | Expand subdatasheet | 
| Ctrl+Shift+Arrow Up | Collapse subdatasheet | 
| Alt+F5 | Move from subdatasheet to record number box, enter record number and press enter | 
Others
| Shortcut Keys | Functions | 
| F11 | Toggle the Navigation Pane | 
| Ctrl+F6 | Cycle between open windows | 
| Enter | Restore the selected minimized window when all windows are minimized | 
| Ctrl+F8 | Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window | 
| Alt+Space | Display the control menu | 
| Shift+F10 | Display the shortcut menu | 
| Ctrl+W/Ctrl+F4 | Close the active window | 
| Alt+F11 | Switch between the Visual Basic Editor and the previous active window | 
| Ctrl+P | Open the Print dialog box (or p) | 
| S | Open the page setup dialog box | 
| C | Cancel print/ layout preview (or escape) | 
| Tab/Shift+Tab | Go to next / go to previous text or hyperlink | 
| Enter | Perform action for currently selected item | 
| Alt+Arrow Left/Alt+Arrow Right | Move back / move forward | 
| Ctrl+P | Open the Print dialog box | 
| Arrow Up/Arrow Down | Move up / move down in small increments | 
| Page Up/Page Down | Move up / move down one one page | 
| Shift+F10 | Show context menu | 
| F2 | Display hyperlink | 
| F7 | Check spelling | 
| Shift+F2 | Open the Zoom box | 
| Alt+Enter | Display a property sheet in Design view | 
| Ctrl+F2 | Invoke a Builder | 
| Ctrl+Arrow Right/Ctrl+Arrow Left | Toggle forward / toggle backwards between views when in a table, or other elements | 

Comments
Post a Comment