Jump to: Manage Databases, Manage Access Features, Working with Text and Data, Working with Access Views, The Rest
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 |
2.1 Find and Replace>
Ctrl+F | Find and replace dialog box |
Ctrl+H | (Find and) Replace dialog box |
Shift+F4 | Find next |
Alt+Ctrl+F | Go to the Navigation Pane search box from anywhere in the database |
2.2 Form Controls>
Ctrl+X/Ctrl+C/Ctrl+V | Cut / Copy / Paste |
Arrow Keys | Move selected control up/down/left/right (Optionally, add Ctrl to key combination) |
Shift+Arrow Down/Shift+Arrow Up | Increase / decrease height of the selected control |
Shift+Arrow Right/Shift+Arrow Left | Increase / decrease width of the selected control |
2.3 Wizards>
Tab | Toggle the focus forward between controls in the wizard |
Alt+N | Move to the next page of the wizard |
Alt+B | Move to the previous page of the wizard |
Alt+F | Complete the wizard |
2.4 Menus>
Shift+F10 | Show the shortcut menu |
Alt | Show the access keys (of F10) |
Alt+Space | Show the program icon menu |
Arrow Down/Arrow Up | Select the next / select previous command in menu |
Arrow Left/Arrow Right | Select the menu to the left / menu to the right |
Home/End | Select first / select last command in menu |
Alt | Close the visible menu and submenu at the same time |
Esc | Close the visible menu; or, with a submenu visible, to close the submenu |
2.5 Dialog Boxes>
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 |
2.6 Text Boxes>
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 |
2.7 Field List Pane>
Alt+F8 | Toggle the Field List pane |
Enter | Add the selected field to the form or report detail section |
Arrow Up/Arrow Down | Move up / move down the Field List pane |
Shift+Tab | Move to the upper Field List pane from the lower pane |
Tab | Move to the lower Field List pane from the upper pane |
3.1 Select and move Fields or Columns>
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 |
3.2 Edit Text and Data>
Arrow Right/Arrow Left | Move cursor one character to the right / to the left |
Ctrl+Arrow Right/Ctrl+Arrow Left | Move cursor one word to the right / to the left |
Home/End | Move cursor to the beginning / to the end of the field |
Ctrl+Home/Ctrl+End | Move cursor to the beginning / to the end of the line in multi-line fields |
Ctrl+Delete | Delete all characters to the right of the insertion point |
Ctrl+Z | Undo Changes |
Ctrl+Y | Redo Changes |
Esc | Cancel / undo changes in the current field or current record |
3.3 Insert Data>
Ctrl+; | Insert the current date |
Ctrl+: | Insert the current time |
Ctrl+Alt+Space | Insert the default value for a field |
Ctrl+' | Insert the value from the same field in the previous record |
Ctrl+[+] | Add a new record |
Ctrl+- | In a datasheet, delete the current record |
Shift+Enter | Save changes to the current record |
Space | Switch between the values in a check box or option button |
Ctrl+Enter | Insert a new line |
3.4 Refresh Fields>
F9 | Recalculate the fields in the window or the contents of a Lookup field |
Shift+F9 | Requery the underlying tables |
4.1 Design View>
F2 | Switch between Edit and Navigation mode |
F4 | Toggle the property sheet |
F5 | Switch to Form view from form Design view |
F6 | Switch between the windows, or between design panes / properties / etc |
F7 | Open the Visual Basic Editor from a selected property in the property sheet for a form or report |
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. |
Shift+F7 | Switch to Form or Report Design View (from Visual Basic Editor with code module open) |
Alt+Enter | Display a property sheet |
Ctrl+X/Ctrl+C/Ctrl+V | Cut / Copy / Paste |
Arrow Keys | Move selected control up/down/left/right along the grid |
Ctrl+Arrow Keys | Move selected control up/down/left/right by one pixel |
Shift+Arrow Down/Shift+Arrow Up | Increase / decrease height of the selected control |
Shift+Arrow Right/Shift+Arrow Left | Increase / decrease width of the selected control |
4.2 Navigate in Datasheet, Subdatasheet, and Form View>
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 |
4.3 Database Diagram>
Esc | Move from a table cell to the table's title bar |
Enter | Move from a table's title bar to the last cell you edited |
Tab | Move from table title bar to table title bar, or from cell to cell inside a table |
Alt+Arrow Down | Expand a list inside a table |
Arrow Down/Arrow Up | Move up / down in a list |
Space | Change the setting in a check box |
Home/End | Go to the first cell / go to last cell in row |
Page Down/Page Up | Go to next / go to previous page of the diagram |
4.4 Query Designer>
F6/Shift+F6 | Move forward / backwards among the Query Designer panes |
Tab/Shift+Tab | Move forward / backwards among tables, views, functions, or join line. |
Arrow Keys | Move between columns in a table, view, or function |
Space | Choose the selected data column for output (or use +/-) |
Delete | Remove the selected table, view, function, or join line |
F2 | In Grid Pane: toggle between edit mode and cell selection mode |
Insert | Insert row between existing columns |
4.5 Pivot Table>
Tab/Shift+Tab | Move to the right / to the left |
Enter/Shift+Enter | Move down / move up |
Shift+Enter | Select cell above current cell |
Ctrl+Enter/Ctrl+Shift+Enter | Select detail cell for next item / previous item in row |
Shift+Arrow Keys | Expand selection |
Ctrl+A | Select entire PivotTable View |
Shift+F10 | Display context menu |
Alt+Enter | Display property dialog box |
Alt+F4 | Close property dialog box |
Esc | Cancel refresh operation in progress |
Ctrl+E | Export contents to Excel |
Ctrl+8 | Toggle expand indicators (plus and minus signs) |
Ctrl+[+ on numeric keyboard | Expand selected item |
Ctrl+- on numeric keyboard | Collapse current item |
Alt+Arrow Down | Open list for currently selected item |
Ctrl+T | Toggle AutoFilter |
Ctrl+Shift+A | Sort data ascending (A-Z) |
Ctrl+Shift+Z | Sort data descending (Z-A) |
Alt+Shift+Arrow Up/Alt+Shift+Arrow Up | Move selected member up / down |
Alt+Shift+Arrow Right/Alt+Shift+Arrow Left | Move selected member right / left |
Ctrl+L | Display Field List pane |
Ctrl+Shift+S | Add new total field using sum summary |
Ctrl+Shift+C | Add new total field using count summary |
Ctrl+Shift+M | Add new total field using min summary |
Ctrl+Shift+X | Add new total field using max summary |
Ctrl+Shift+E | Add new total field using average summary |
Ctrl+Shift+D | Add new total field using standard deviation summary |
Ctrl+Shift+T | Add new total field using standard deviation population summary |
Ctrl+Shift+B | Turn subtotals and grand totals on or off for selected field |
Ctrl+F | Add a calculated detail field |
Ctrl+1 | Move selected field to row area |
Ctrl+2 | Move selected field to column area |
Ctrl+3 | Move selected field to filter area |
Ctrl+4 | Move selected field to detail area |
Ctrl+Arrow Left/Ctrl+Arrow Right | Move selection up one level / down one level |
Ctrl+Shift+~ | Apply the general number format to values |
Ctrl+Shift+$ | Apply the currency format to values |
Ctrl+Shift+% | Apply the percentage format to values |
Ctrl+Shift+^ | Apply the exponential number format to values |
Ctrl+Shift+# | Apply the date format to values |
Ctrl+Shift+@ | Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field |
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 |
Ctrl+B | Make text bold in the selected field of the PivotTable view |
Ctrl+U | Make text underlined in the selected field of the PivotTable view |
Ctrl+I | Make text italic in the selected field of the PivotTable view |
5.1 Manage Windows>
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 |
5.2 Print Preview>
Ctrl+P | Open the Print dialog box (or p) |
S | Open the page setup dialog box |
C | Cancel print/ layout preview (or escape) |
5.3 Help Window>
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 |
5.4 Other Shortcuts>
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 |
Advertising for Consideration:
Ads for Consideration:
Please kindly review and accept Terms of Use and Cookie & Policy Policy