Manage Databases
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Ctrl+N | Open/create new database |
| 02 | Ctrl+O | Open existing database |
| 03 | Alt+F4 | Quit/ exit Access |
| 04 | Ctrl+P | Print the current or selected object |
| 05 | Ctrl+S | Save a database object (or Shift+f12) |
| 06 | F12 | Open the Save As dialog box |
Find and Replace
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Ctrl+F | Find and replace dialog box |
| 02 | Ctrl+H | (Find and) Replace dialog box |
| 03 | Shift+F4 | Find next |
| 04 | Alt+Ctrl+F | Go to the Navigation Pane search box from anywhere in the database |
Form Controls
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Ctrl+X/Ctrl+C/Ctrl+V | Cut / Copy / Paste |
| 02 | Arrow Keys | Move selected control up/down/left/right (Optionally, add Ctrl to key combination) |
| 03 | Shift+Arrow | Increase / decrease height of the selected control |
| 04 | Down/Shift+Arrow Up | Increase / decrease width of the selected control |
Wizards
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Tab | Toggle the focus forward between controls in the wizard |
| 02 | Alt+N | Move to the next page of the wizard |
| 03 | Alt+B | Move to the previous page of the wizard |
| 04 | Alt+F | Complete the wizard |
Menus
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Shift+F10 | Show the shortcut menu |
| 02 | Alt | Show the access keys (of F10) |
| 03 | Alt+Space | Show the program icon menu |
| 04 | Arrow Down/Arrow Up | Select the next / select previous command in menu |
| 05 | Arrow Left/Arrow Right | Select the menu to the left / menu to the right |
| 06 | Home/End | Select first / select last command in menu |
| 07 | Esc | Close the visible menu; or, with a submenu visible, to close the submenu |
Dialog Boxes
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Ctrl+Tab/Ctrl+Shift+Tab | Switch to next tab / switch to previous tab in a dialog |
| 02 | Tab/Shift+Tab | Move to the next / switch to previous option or option group |
| 03 | Arrow Keys | Move between options |
| 04 | Space | Select current button |
| 05 | Alt+Arrow Down | Open the selected drop-down list box |
| 06 | Esc | Close the selected drop-down list box |
| 07 | Enter | Perform the action assigned to the default button in the dialog box |
| 08 | Alt+F4 | Close a dialog box |
Text Boxes
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Home/End | Move beginning / move to end of an entry |
| 02 | Ctrl+Arrow Left/Ctrl+Arrow Right | Move one word to the left or right |
| 03 | Shift+Home/Shift+End | Select from cursor to end / to beginning |
| 04 | Shift+Arrow Left/Shift+Arrow Right | Extend selection one character to the left / to the right |
Field List Pane
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Alt+F8 | Toggle the Field List pane |
| 02 | Enter | Add the selected field to the form or report detail section |
| 03 | Arrow Up/Arrow Down | Move up / move down the Field List pane |
| 04 | Shift+Tab | Move to the upper Field List pane from the lower pane |
| 05 | Tab | Move to the lower Field List pane from the upper pane |
Select and move Fields or Columns
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Tab/Shift+Tab | Select next field / select previous field |
| 02 | F2 | Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet or design view |
| 03 | Shift+Space | Switch between selecting the current record and the first field of the current record, |
| 04 | Shift+Arrow Up/Shift+Arrow Down | Extend selection to previous record/ to next record |
| 05 | Ctrl+A | Select all records (or Ctrl+Shift+Space) |
| 06 | F8 | Turn on Extend mode |
| 07 | Arrow Left/Arrow Right | Extend a selection to adjacent fields in the same row in Datasheet view |
| 08 | Arrow Up/Arrow Down | Extend a selection to adjacent rows in Datasheet view |
| 09 | Shift+F8 | Undo the previous extension |
| 10 | Esc | Cancel Extend mode |
| 11 | Ctrl+Space | Select the current column |
| 12 | Shift+Arrow Right/Shift+Arrow Left | Select the column to the right / to the left, if the current column is selected |
| 13 | Ctrl+Shift+F8 | Turn on Move mode |
Edit Text and Data
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Arrow Right/Arrow Left | Move cursor one character to the right / to the left |
| 02 | Ctrl+Arrow Right/Ctrl+Arrow Left | Move cursor one word to the right / to the left |
| 03 | Home/End | Move cursor to the beginning / to the end of the field |
| 04 | Ctrl+Home/Ctrl+End | Move cursor to the beginning / to the end of the line in multi-line fields |
| 05 | Ctrl+Delete | Delete all characters to the right of the insertion point |
| 06 | Ctrl+Z | Undo Changes |
| 07 | Ctrl+Y | Redo Changes |
| 08 | Esc | Cancel / undo changes in the current field or current record |
Insert Data
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Ctrl+; | Insert the current date |
| 02 | Ctrl+: | Insert the current time |
| 03 | Ctrl+Alt+Space | Insert the default value for a field |
| 04 | Ctrl+’ | Insert the value from the same field in the previous record |
| 05 | Ctrl+[+] | Add a new record |
| 06 | Ctrl+- | In a datasheet, delete the current record |
| 07 | Shift+Enter | Save changes to the current record |
| 08 | Space | Switch between the values in a check box or option button |
| 09 | Ctrl+Enter | Insert a new line |
Refresh Fields
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | F9 | Recalculate the fields in the window or the contents of a Lookup field |
| 02 | Shift+F9 | Requery the underlying tables |
Design View
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | F2 | Switch between Edit and Navigation mode |
| 02 | F4 | Toggle the property sheet |
| 03 | F5 | Switch to Form view from form Design view |
| 04 | F6 | Switch between the windows, or between design panes / properties / etc |
| 05 | F7 | Open the Visual Basic Editor from a selected property in the property sheet for a form or report |
| 06 | Alt+F8 | Invokes the Field List pane in a form, report, or data access page. If the Field List pane is already open, focus moves to the Field List pane. |
| 07 | Shift+F7 | Switch to Form or Report Design View (from Visual Basic Editor with code module open) |
| 08 | Alt+Enter | Display a property sheet |
| 09 | Ctrl+X/Ctrl+C/Ctrl+V | Cut / Copy / Paste |
| 10 | Arrow Keys | Move selected control up/down/left/right along the grid |
| 11 | Ctrl+Arrow Keys | Move selected control up/down/left/right by one pixel |
| 12 | Shift+Arrow Down/Shift+Arrow Up | Increase / decrease height of the selected control |
| 13 | Shift+Arrow Right/Shift+Arrow Left | Increase / decrease width of the selected control |
Navigate in Datasheet, Subdatasheet, and Form View
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | F5 | Move to the record number box, type in number and press enter |
| 02 | Tab/Shift+Tab | Move to next / move to previous field in current record |
| 03 | Home/End | Move to first / move to last field in current record |
| 04 | Arrow Down/Arrow Up | Move to next / move to previous record |
| 05 | 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) |
| 06 | Ctrl+Home/Ctrl+End | Move to first field in first record / last field in last record |
| 07 | Page Down/Page Up | Move down one screen / move up one screen |
| 08 | Ctrl+Page Down/Ctrl+Page Up | Move right one screen / left one screen |
| 09 | Ctrl+Tab/Ctrl+Shift+Tab | In subdatasheet: Exit to next / to previous record |
| 10 | Ctrl+Shift+Arrow Down | Expand subdatasheet |
| 11 | Ctrl+Shift+Arrow Up | Collapse subdatasheet |
| 12 | Alt+F5 | Move from subdatasheet to record number box, enter record number and press enter |
Database Diagram
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Esc | Move from a table cell to the table’s title bar |
| 02 | Enter | Move from a table’s title bar to the last cell you edited |
| 03 | Tab | Move from table title bar to table title bar, or from cell to cell inside a table |
| 04 | Alt+Arrow Down | Expand a list inside a table |
| 05 | Arrow Down/Arrow Up | Move up / down in a list |
| 06 | Space | Change the setting in a check box |
| 07 | Home/End | Go to the first cell / go to last cell in row |
| 08 | Page Down/Page Up | Go to next / go to previous page of the diagram |
Query Designer
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | F6/Shift+F6 | Move forward / backwards among the Query Designer panes |
| 02 | Tab/Shift+Tab | Move forward / backwards among tables, views, functions, or join line. |
| 03 | Arrow Keys | Move between columns in a table, view, or function |
| 04 | Space | Choose the selected data column for output (or use +/-) |
| 05 | Delete | Remove the selected table, view, function, or join line |
| 06 | F2 | In Grid Pane: toggle between edit mode and cell selection mode |
| 07 | Insert | Insert row between existing columns |
Pivot Table
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Tab/Shift+Tab | Move to the right / to the left |
| 02 | Enter/Shift+Enter | Move down / move up |
| 03 | Shift+Enter | Select cell above current cell |
| 04 | Ctrl+Enter/Ctrl+Shift+Enter | Select detail cell for next item / previous item in row |
| 05 | Shift+Arrow Keys | Expand selection |
| 06 | Ctrl+A | Select entire PivotTable View |
| 07 | Shift+F10 | Display context menu |
| 08 | Alt+Enter | Display property dialog box |
| 09 | Alt+F4 | Close property dialog box |
| 10 | Esc | Cancel refresh operation in progress |
| 11 | Ctrl+E | Export contents to Excel |
| 12 | Ctrl+8 | Toggle expand indicators (plus and minus signs) |
| 13 | Ctrl+[+ on numeric keyboard | Expand selected item |
| 14 | Ctrl+- on numeric keyboard | Collapse current item |
| 15 | Alt+Arrow Down | Open list for currently selected item |
| 16 | Ctrl+T | Toggle AutoFilter |
| 17 | Ctrl+Shift+A | Sort data ascending (A-Z) |
| 18 | Ctrl+Shift+Z | Sort data descending (Z-A) |
| 19 | Alt+Shift+Arrow Up/Alt+Shift+Arrow Up | Move selected member up / down |
| 20 | Alt+Shift+Arrow Right/Alt+Shift+Arrow Left | Move selected member right / left |
| 21 | Ctrl+L | Display Field List pane |
| 22 | Ctrl+Shift+S | Add new total field using sum summary |
| 23 | Ctrl+Shift+C | Add new total field using count summary |
| 24 | Ctrl+Shift+M | Add new total field using min summary |
| 25 | Ctrl+Shift+X | Add new total field using max summary |
| 26 | Ctrl+Shift+E | Add new total field using average summary |
| 27 | Ctrl+Shift+D | Add new total field using standard deviation summary |
| 28 | Ctrl+Shift+T | Add new total field using standard deviation population summary |
| 29 | Ctrl+Shift+B | Turn subtotals and grand totals on or off for selected field |
| 30 | Ctrl+F | Add a calculated detail field |
| 31 | Ctrl+1 | Move selected field to row area |
| 32 | Ctrl+2 | Move selected field to column area |
| 33 | Ctrl+3 | Move selected field to filter area |
| 34 | Ctrl+4 | Move selected field to detail area |
| 35 | Ctrl+Arrow Left/Ctrl+Arrow Right | Move selection up one level / down one level |
| 36 | Ctrl+Shift+~ | Apply the general number format to values |
| 37 | Ctrl+Shift+$ | Apply the currency format to values |
| 38 | Ctrl+Shift+% | Apply the percentage format to values |
| 39 | Ctrl+Shift+^ | Apply the exponential number format to values |
| 40 | Ctrl+Shift+# | Apply the date format to values |
| 41 | Ctrl+Shift+@ | Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field |
| 42 | Ctrl+Shift+! | Apply the numeric format, with two decimal places, thousands separator, and a minus sign for negative values, to values in the selected total or detail field |
| 43 | Ctrl+B | Make text bold in the selected field of the PivotTable view |
| 44 | Ctrl+U | Make text underlined in the selected field of the PivotTable view |
| 45 | Ctrl+I | Make text italic in the selected field of the PivotTable view |
Manage Windows
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | F11 | Toggle the Navigation Pane |
| 02 | Ctrl+F6 | Cycle between open windows |
| 03 | Enter | Restore the selected minimized window when all windows are minimized |
| 04 | Ctrl+F8 | Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window |
| 05 | Alt+Space | Display the control menu |
| 06 | Shift+F10 | Display the shortcut menu |
| 07 | Ctrl+W/Ctrl+F4 | Close the active window |
| 08 | Alt+F11 | Switch between the Visual Basic Editor and the previous active window |
Help Window
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | Tab/Shift+Tab | Go to next / go to previous text or hyperlink |
| 02 | Enter | Perform action for currently selected item |
| 03 | Alt+Arrow Left/Alt+Arrow Right | Move back / move forward |
| 04 | Ctrl+P | Open the Print dialog box |
| 05 | Arrow Up/Arrow Down | Move up / move down in small increments |
| 06 | Page Up/Page Down | Move up / move down one one page |
| 07 | Shift+F10 | Show context menu |
Other Shortcuts
| Sr.No | Shortcut Key | Description |
|---|---|---|
| 01 | F2 | Display hyperlink |
| 02 | F7 | Check spelling |
| 03 | Shift+F2 | Open the Zoom box |
| 04 | Alt+Enter | Display a property sheet in Design view |
| 05 | Ctrl+F2 | Invoke a Builder |
| 06 | Ctrl+Arrow Right/Ctrl+Arrow Left | Toggle forward / toggle backwards between views when in a table, or other elements |
