Microsoft Access Keyboard shortcuts- A complete list of hot keys

Microsoft Access Keyboard shortcuts

[su_spoiler title=”Design-time shortcut keys” style=”fancy” icon=”plus-circle”]

These shortcut keys are available when you are customizing an app in Access. Many of the shortcuts listed underDesktop database shortcut keys are also available when customizing an app.

To do thisPress
Advance through all tables and views (when not in Edit mode)TAB
Move a table or view selectorArrow keys
Show or hide the Navigation PaneF11
Advance through the controls on a view (when in Edit mode)TAB
Move the selected control(s)Arrow keys
Open or close the properties for the selected controlF4
Show or hide the Field ListAlt+F8

[/su_spoiler]

[su_spoiler title=”Runtime (browser) shortcut keys” style=”fancy” icon=”plus-circle”]

These shortcut keys are available when you are using an Access app in the browser. You can also use any shortcut keys that are provided by the browser itself.

To do thisPress
New itemN
Delete itemDelete
Edit itemE
Save itemCtrl+S
CancelEscape
Edit filter/
Close a popup viewEscape

When working in the browser, press Tab, Shift+Tab, and the arrow keys to move between the table list, the view selector, the action bar, the search box, and controls on views.

[/su_spoiler]

Desktop database shortcut keys

Global Access shortcut keys

[su_spoiler title=”Opening databases” style=”fancy” icon=”plus-circle”]

To do thisPress
Open a new databaseCTRL+N
Open an existing databaseCTRL+O

[/su_spoiler]

[su_spoiler title=”Printing and saving” style=”fancy” icon=”plus-circle”]

To do thisPress
Print the current or selected objectCTRL+P
Open the Print dialog box from Print PreviewP or CTRL+P
Open the Page Setup dialog box from Print PreviewS
Cancel Print Preview or Layout PreviewC or ESC
Save a database objectCTRL+S or SHIFT+F12
Open the Save As dialog boxF12

[/su_spoiler]

[su_spoiler title=”Using a combo box or list box” style=”fancy” icon=”plus-circle”]

To do thisPress
Open a combo boxF4 or ALT+DOWN ARROW
Refresh the contents of a Lookup field list box or combo boxF9
Move down one lineDOWN ARROW
Move down one pagePAGE DOWN
Move up one lineUP ARROW
Move up one pagePAGE UP
Exit the combo box or list boxTAB

[/su_spoiler]

[su_spoiler title=”Finding and replacing text or data” style=”fancy” icon=”plus-circle”]

To do thisPress
Open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only)CTRL+F
Open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only)CTRL+H
Find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only)SHIFT+F4

[/su_spoiler]

[su_spoiler title=”Working in Design, Layout, or Datasheet view” style=”fancy” icon=”plus-circle”]

To do thisPress
Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet. When working in a form or report, press ESC to leave Navigation mode.F2
Switch to the property sheet (Design view and Layout view in forms and reports)F4
Switch to Form view from form Design viewF5
Switch between the upper and lower portions of a window (Design view of queries, and the Advanced Filter/Sort window)F6
Cycle through the field grid, field properties, the Navigation Pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (Design view of tables)F6
Open the Choose Builder dialog box from a selected control on a form or report (Design view only)F7
Open the Visual Basic Editor from a selected property in the property sheet for a form or reportF7
Switch from the Visual Basic Editor back to form or report Design viewALT+F11

[/su_spoiler]

[su_spoiler title=”Editing controls in form and report Design view” style=”fancy” icon=”plus-circle”]

To do thisPress
Copy the selected control to the ClipboardCTRL+C
Cut the selected control and copy it to the ClipboardCTRL+X
Paste the contents of the Clipboard in the upper-left corner of the selected sectionCTRL+V
Move the selected control to the right (except controls that are part of a layout)RIGHT ARROW or CTRL+RIGHT ARROW
Move the selected control to the left (except controls that are part of a layout)LEFT ARROW or CTRL+LEFT ARROW
Move the selected control up (except controls that are part of a layout)UP ARROW or CTRL+UP ARROW
Move the selected control down (except controls that are part of a layout)DOWN ARROW or CTRL+DOWN ARROW
Increase the height of the selected controlNOTE    If used with controls that are in a layout, the entire row of the layout is resized.SHIFT+DOWN ARROW
Increase the width of the selected controlNOTE    If used with controls that are in a layout, the entire column of the layout is resized.SHIFT+RIGHT ARROW
Reduce the height of the selected controlNOTE    If used with controls that are in a layout, the entire row of the layout is resized.SHIFT+UP ARROW
Reduce the width of the selected controlNOTE    If used with controls that are in a layout, the entire column of the layout is resized.SHIFT+LEFT ARROW

[/su_spoiler]

[su_spoiler title=”Window operations” style=”fancy” icon=”plus-circle”]

By default, Access databases display as tabbed documents. To use windowed documents, Click the File tab., and then click Options. In the Access Options dialog box, click Current Database and, under Document Window Options, click Overlapping Windows.

To do thisPress
Toggle the Navigation PaneF11
Cycle between open windowsCTRL+F6
Restore the selected minimized window when all windows are minimizedENTER
Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window, then press Enter to apply the new size.CTRL+F8
Display the control menuALT+SPACEBAR
Display the shortcut menuShortcut menu key (near the lower right of most keyboards)
Close the active windowCTRL+W or CTRL+F4
Switch between the Visual Basic Editor and the previous active windowALT+F11

[/su_spoiler]

[su_spoiler title=”Working with Wizards” style=”fancy” icon=”plus-circle”]

To do thisPress
Toggle the focus forward between controls in the wizardTAB
Move to the next page of the wizardALT+N
Move to the previous page of the wizardALT+B
Complete the wizardALT+F

[/su_spoiler]

[su_spoiler title=”Miscellaneous” style=”fancy” icon=”plus-circle”]

To do thisPress
Display the complete hyperlink address for a selected hyperlinkF2
Check spellingF7
Open the Zoom box to conveniently enter expressions and other text in small input areasSHIFT+F2
Display a property sheet in Design viewALT+ENTER
Exit AccessALT+F4
Invoke a BuilderCTRL+F2
Toggle forward between views when in a table, query, form, or report. If there are additional views available, successive keystrokes will move to the next available view.CTRL+RIGHT ARROW or CRTL+COMMA (,)
Toggle back between views when in a table, query, form, or report. If there are additional views available, successive keystrokes will move to the previous view.NOTE   CTRL+PERIOD (.) does not work under all conditions with all objects.CTRL+LEFT ARROW or CRTL+PERIOD (.)

[/su_spoiler]

[su_spoiler title=”The Navigation Pane shortcut keys” style=”fancy” icon=”plus-circle”]

To do thisPress
Show or hide the Navigation PaneF11
Go to the Navigation Pane Search box (if focus is already on the Navigation Pane)CTRL+F

[/su_spoiler]

[su_spoiler title=”Editing and navigating the Object list” style=”fancy” icon=”plus-circle”]

To do thisPress
Rename a selected objectF2
Move down one lineDOWN ARROW
Move down one windowPAGE DOWN
Move to the last objectEND
Move up one lineUP ARROW
Move up one windowPAGE UP

[/su_spoiler]

[su_spoiler title=”Navigating and opening objects” style=”fancy” icon=”plus-circle”]

To do thisPress
Open the selected table or query in Datasheet viewENTER
Open the selected form or reportENTER
Run the selected macroENTER
Open the selected table, query, form, report, macro, or module in Design viewCTRL+ENTER
Display the Immediate window in the Visual Basic EditorCTRL+G

[/su_spoiler]

[su_spoiler title=”Work with menus” style=”fancy” icon=”plus-circle”]

To do thisPress
Show the shortcut menuShortcut key (near the lower right of most keyboards)
Show the access keysALT or F10
Show the program icon menu (on the program title bar)ALT+SPACEBAR
With the menu or submenu visible, select the next or previous commandDOWN ARROW or UP ARROW
Select the menu to the left or right; or, when a submenu is visible, to switch between the main menu and the submenuLEFT ARROW or RIGHT ARROW
Select the first or last command on the menu or submenuHOME or END
Close the visible menu and submenu at the same timeALT
Close the visible menu; or, with a submenu visible, to close the submenu onlyESC

[/su_spoiler]

Work in windows and dialog boxes

[su_spoiler title=”Using a program window” style=”fancy” icon=”plus-circle”]

To do thisPress
Switch to the next programALT+TAB
Switch to the previous programALT+SHIFT+TAB
Show the Windows Start menuCTRL+ESC
Close the active database windowCTRL+W
Switch to the next database windowCTRL+F6
Switch to the previous database windowCTRL+SHIFT+F6
Restore the selected minimized window when all windows are minimizedENTER

[/su_spoiler]

[su_spoiler title=”Using a dialog box” style=”fancy” icon=”plus-circle”]

To do thisPress
Switch to the next tab in a dialog boxCTRL+TAB
Switch to the previous tab in a dialog boxCTRL+SHIFT+TAB
Move to the next option or option groupTAB
Move to the previous option or option groupSHIFT+TAB
Move between options in the selected drop-down list box, or to move between some options in a group of optionsArrow keys
Perform the action assigned to the selected button; select or clear the check boxSPACEBAR
Move to the option by the first letter in the option name in a drop-down list boxLetter key for the first letter in the option name you want (when a drop-down list box is selected)
Select the option, or to select or clear the check box by the letter underlined in the option nameALT+letter key
Open the selected drop-down list boxALT+DOWN ARROW
Close the selected drop-down list boxESC
Perform the action assigned to the default button in the dialog boxENTER
Cancel the command and close the dialog boxESC

[/su_spoiler]

[su_spoiler title=”Editing in a text box” style=”fancy” icon=”plus-circle”]

To do thisPress
Move to the beginning of the entryHOME
Move to the end of the entryEND
Move one character to the left or rightLEFT ARROW or RIGHT ARROW
Move one word to the left or rightCTRL+LEFT ARROW or CTRL+RIGHT ARROW
Select from the insertion point to the beginning of the text entrySHIFT+HOME
Select from the insertion point to the end of the text entrySHIFT+END
Change the selection by one character to the leftSHIFT+LEFT ARROW
Change the selection by one character to the rightSHIFT+RIGHT ARROW
Change the selection by one word to the leftCTRL+SHIFT+LEFT ARROW
Change the selection by one word to the rightCTRL+SHIFT+RIGHT ARROW

[/su_spoiler]

Work with property sheets

[su_spoiler title=”Using a property sheet with a form or report in Design view or Layout view” style=”fancy” icon=”plus-circle”]

To do thisPress
Show or hide the Property SheetF4
Move among choices in the control selection drop-down list one item at a timeDOWN ARROW or UP ARROW
Move among choices in the control selection drop-down list one page at a timePAGE DOWN or PAGE UP
Move to the property sheet tabs from the control selection drop-down listTAB
Move among the property sheet tabs with a tab selected, but no property selectedLEFT ARROW or RIGHT ARROW
With a property already selected, move down one property on a tabTAB
With a property selected, move up one property on a tab; or if already at the top, move to the tabSHIFT+TAB
Toggle forward between tabs when a property is selectedCTRL+TAB
Toggle backward between tabs when a property is selectedCTRL+SHIFT+TAB

[/su_spoiler]

[su_spoiler title=”Using a property sheet with a table or query in Design view” style=”fancy” icon=”plus-circle”]

To do thisPress
Show or hide the Property SheetF4
With a tab selected, but no property selected, move among the property sheet tabsLEFT ARROW or RIGHT ARROW
Move to the property sheet tabs when a property is selectedCTRL+TAB
Move to the first property of a tab when no property is selectedTAB
Move down one property on a tabTAB
Move up one property on a tab; or if already at the top, select the tab itselfSHIFT+TAB
Toggle forward between tabs when a property is selectedCTRL+TAB
Toggle backward between tabs when a property is selectedCTRL+SHIFT+TAB

Using the Field List pane with a form or report in Design view or Layout view

To do thisPress
Show or hide the Field List paneALT+F8
Add the selected field to the form or report detail sectionENTER
Move up or down the Field List paneUP ARROW or DOWN ARROW
Move between the upper and lower panes of the Field ListTAB

[/su_spoiler]

Keys for working with text and data

Select text and data

[su_spoiler title=”Selecting text in a field” style=”fancy” icon=”plus-circle”]

To do thisPress
Change the size of the selection by one character to the rightSHIFT+RIGHT ARROW
Change the size of the selection by one word to the rightCTRL+SHIFT+RIGHT ARROW
Change the size of the selection by one character to the leftSHIFT+LEFT ARROW
Change the size of the selection by one word to the leftCTRL+SHIFT+LEFT ARROW

[/su_spoiler]

[su_spoiler title=”Selecting a field or record” style=”fancy” icon=”plus-circle”]

To do thisPress
Select the next fieldTAB
Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet. When using a form or report, press ESC to leave Navigation mode.F2
Switch between selecting the current record and the first field of the current record, in Navigation modeSHIFT+SPACEBAR
Extend selection to the previous record, if the current record is selectedSHIFT+UP ARROW
Extend selection to the next record, if the current record is selectedSHIFT+DOWN ARROW
Select all recordsCTRL+A or CTRL+SHIFT+SPACEBAR

[/su_spoiler]

[su_spoiler title=”Extending a selection” style=”fancy” icon=”plus-circle”]

To do thisPress
Turn on Extend mode (in Datasheet view, Extended Selection appears in the lower-right corner of the window); pressing F8 repeatedly extends the selection to the word, the field, the record, and all recordsF8
Extend a selection to adjacent fields in the same row in Datasheet viewLEFT ARROW or RIGHT ARROW
Extend a selection to adjacent rows in Datasheet viewUP ARROW or DOWN ARROW
Undo the previous extensionSHIFT+F8
Cancel Extend modeESC

[/su_spoiler]

[su_spoiler title=”Selecting and moving a column in Datasheet view” style=”fancy” icon=”plus-circle”]

To do thisPress
Select the current column or cancel the column selection, in Navigation mode onlyCTRL+SPACEBAR
Extend the selection one column to the right, if the current column is selectedSHIFT+RIGHT ARROW
Extend the selection one column to the left, if the current column is selectedSHIFT+LEFT ARROW
Turn on Move mode; then press the RIGHT ARROW or LEFT ARROW key to move selected column(s) to the right or leftCTRL+SHIFT+F8

[/su_spoiler]

Edit text and data

[su_spoiler title=”Moving the insertion point in a field” style=”fancy” icon=”plus-circle”]

To do thisPress
Move the insertion point one character to the rightRIGHT ARROW
Move the insertion point one word to the rightCTRL+RIGHT ARROW
Move the insertion point one character to the leftLEFT ARROW
Move the insertion point one word to the leftCTRL+LEFT ARROW
Move the insertion point to the end of the field, in single-line fields; or to move it to the end of the line in multi-line fieldsEND
Move the insertion point to the end of the field, in multiple-line fieldsCTRL+END
Move the insertion point to the beginning of the field, in single-line fields; or to move it to the beginning of the line in multi-line fieldsHOME
Move the insertion point to the beginning of the field, in multiple-line fieldsCTRL+HOME

[/su_spoiler]

[su_spoiler title=”Copying, moving, or deleting text” style=”fancy” icon=”plus-circle”]

To do thisPress
Copy the selection to the ClipboardCTRL+C
Cut the selection and copy it to the ClipboardCTRL+X
Paste the contents of the Clipboard at the insertion pointCTRL+V
Delete the selection or the character to the left of the insertion pointBACKSPACE
Delete the selection or the character to the right of the insertion pointDELETE
Delete all characters to the right of the insertion pointCTRL+DELETE

[/su_spoiler]

[su_spoiler title=”Undoing changes” style=”fancy” icon=”plus-circle”]

To do thisPress
Undo typingCTRL+Z or ALT+BACKSPACE
Undo changes in the current field or current record; if both have been changed, press ESC twice to undo changes, first in the current field and then in the current recordESC

[/su_spoiler]

[su_spoiler title=”Entering data in Datasheet or Form view” style=”fancy” icon=”plus-circle”]

To do thisPress
Insert the current dateCTRL+SEMICOLON (;)
Insert the current timeCTRL+SHIFT+COLON (:)
Insert the default value for a fieldCTRL+ALT+SPACEBAR
Insert the value from the same field in the previous recordCTRL+APOSTROPHE (‘)
Add a new recordCTRL+PLUS SIGN (+)
In a datasheet, delete the current recordCTRL+MINUS SIGN (-)
Save changes to the current recordSHIFT+ENTER
Switch between the values in a check box or option buttonSPACEBAR
Insert a new line in a Short Text or Long Text fieldCTRL+ENTER

[/su_spoiler]

[su_spoiler title=”Refreshing fields with current data” style=”fancy” icon=”plus-circle”]

To do thisPress
Recalculate the fields in the windowF9
Requery the underlying tables; in a subform, this requeries the underlying table for the subform onlySHIFT+F9
Refresh the contents of a Lookup field list box or combo boxF9

[/su_spoiler]

Keys for navigating records

[su_spoiler title=”Navigate in Design view” style=”fancy” icon=”plus-circle”]

To do thisPress
Switch between Edit mode (with insertion point displayed) and Navigation modeF2
Toggle the property sheetF4 or ALT+ENTER
Switch to Form view from form Design viewF5
Switch between the upper and lower portions of a window (Design view of macros, queries, and the Advanced Filter/Sort window) Use F6 when the TAB key does not take you to the section of the screen you want.F6
Toggle forward between the design pane, properties, Navigation Pane, access keys, and Zoom controls (Design view of tables, forms, and reports)F6
Open the Visual Basic Editor from a selected property in the property sheet for a form or reportF7
Invokes the Field List pane in a form, or report. If the Field List pane is already open, focus moves to the Field List pane.ALT+F8
When you have a code module open, switch from the Visual Basic Editor to form or report Design viewSHIFT+F7
Switch from a control’s property sheet in form or report Design view to the design surface without changing the control focusSHIFT+F7
Copy the selected control to the ClipboardCTRL+C
Cut the selected control and copy it to the ClipboardCTRL+X
Paste the contents of the Clipboard in the upper-left corner of the selected sectionCTRL+V
Move the selected control to the right by a pixel along the page’s gridRIGHT ARROW
Move the selected control to the left by a pixel along the page’s gridLEFT ARROW
Move the selected control up by a pixel along the page’s gridNOTE   For controls in a stacked layout, this switches the position of the selected control with the control directly above it, unless it is already the uppermost control in the layout.UP ARROW
Move the selected control down by a pixel along the page’s gridNOTE   For controls in a stacked layout, this switches the position of the selected control with the control directly below it, unless it is already the lowermost control in the layout.DOWN ARROW
Move the selected control to the right by a pixel (irrespective of the page’s grid)CTRL+RIGHT ARROW
Move the selected control to the left by a pixel (irrespective of the page’s grid)CTRL+LEFT ARROW
Move the selected control up by a pixel (irrespective of the page’s grid)NOTE   For controls in a stacked layout, this switches the position of the selected control with the control directly above it, unless it is already the uppermost control in the layout.CTRL+UP ARROW
Move the selected control down by a pixel (irrespective of the page’s grid)NOTE   For controls in a stacked layout, this switches the position of the selected control with the control directly below it, unless it is already the lowermost control in the layout.CTRL+DOWN ARROW
Increase the width of the selected control (to the right) by a pixelNOTE   For controls in a stacked layout, this increases the width of the whole layout.SHIFT+RIGHT ARROW
Decrease the width of the selected control (to the left) by a pixelNOTE   For controls in a stacked layout, this decreases the width of the whole layout.SHIFT+LEFT ARROW
Decrease the height of the selected control (from the bottom) by a pixelSHIFT+UP ARROW
Increase the height of the selected control (from the bottom) by a pixelSHIFT+DOWN ARROW

[/su_spoiler]

Navigate in Datasheet view

[su_spoiler title=”Going to a specific record” style=”fancy” icon=”plus-circle”]

To do thisPress
Move to the record number box; then type the record number and press ENTERF5

[/su_spoiler]

[su_spoiler title=”Navigating between fields and records” style=”fancy” icon=”plus-circle”]

To do thisPress
Move to the next fieldTAB or RIGHT ARROW
Move to the last field in the current record, in Navigation modeEND
Move to the previous fieldSHIFT+TAB, or LEFT ARROW
Move to the first field in the current record, in Navigation modeHOME
Move to the current field in the next recordDOWN ARROW
Move to the current field in the last record, in Navigation modeCTRL+DOWN ARROW
Move to the last field in the last record, in Navigation modeCTRL+END
Move to the current field in the previous recordUP ARROW
Move to the current field in the first record, in Navigation modeCTRL+UP ARROW
Move to the first field in the first record, in Navigation modeCTRL+HOME

[/su_spoiler]

[su_spoiler title=”Navigating to another screen of data” style=”fancy” icon=”plus-circle”]

To do thisPress
Move down one screenPAGE DOWN
Move up one screenPAGE UP
Move right one screenCTRL+PAGE DOWN
Move left one screenCTRL+PAGE UP

[/su_spoiler]

Navigate in subdatasheets

[su_spoiler title=”Going to a specific record” style=”fancy” icon=”plus-circle”]

To do thisPress
Move from the subdatasheet to move to the record number box; then type the record number and press ENTERALT+F5

[/su_spoiler]

[su_spoiler title=”Expanding and collapsing subdatasheet” style=”fancy” icon=”plus-circle”]

To do thisPress
Move from the datasheet to expand the record’s subdatasheetCTRL+SHIFT+DOWN ARROW
Collapse the subdatasheetCTRL+SHIFT+UP ARROW

[/su_spoiler]

[su_spoiler title=”Navigating between the datasheet and subdatasheet” style=”fancy” icon=”plus-circle”]

To do thisPress
Enter the subdatasheet from the last field of the previous record in the datasheetTAB
Enter the subdatasheet from the first field of the following record in the datasheetSHIFT+TAB
Exit the subdatasheet and move to the first field of the next record in the datasheetCTRL+TAB
Exit the subdatasheet and move to the last field of the previous record in the datasheetCTRL+SHIFT+TAB
From the last field in the subdatasheet to enter the next field in the datasheetTAB
From the datasheet to bypass the subdatasheet and move to the next record in the datasheetDOWN ARROW
From the datasheet to bypass the subdatasheet and move to the previous record in the datasheetUP ARROW

[/su_spoiler]

Navigate in Form view

[su_spoiler title=”Going to a specific record” style=”fancy” icon=”plus-circle”]

To do thisPress
Move to the record number box; then type the record number and press ENTERF5

[/su_spoiler]

[su_spoiler title=”Navigating between fields and records” style=”fancy” icon=”plus-circle”]

To do thisPress
Move to the next fieldTAB
Move to the previous fieldSHIFT+TAB
Move to the last control on the form and remain in the current record, in Navigation modeEND
Move to the last control on the form and set focus in the last record, in Navigation modeCTRL+END
Move to the first control on the form and remain in the current record, in Navigation modeHOME
Move to the first control on the form and set focus in the first record, in Navigation modeCTRL+HOME
Move to the current field in the next recordCTRL+PAGE DOWN
Move to the current field in the previous recordCTRL+PAGE UP

[/su_spoiler]

[su_spoiler title=”Navigating in forms with more than one page” style=”fancy” icon=”plus-circle”]

To do thisPress
Move down one page; at the end of the record, moves to the equivalent page on the next recordPAGE DOWN
Move up one page; at the end of the record, moves to the equivalent page on the previous recordPAGE UP

[/su_spoiler]

[su_spoiler title=”Navigating between a main form and a subform” style=”fancy” icon=”plus-circle”]

To do thisPress
Enter the subform from the preceding field in the main formTAB
Enter the subform from the following field in the main formSHIFT+TAB
Exit the subform and move to the next field in the master form or next recordCTRL+TAB
Exit the subform and move to the previous field in the main form or previous recordCTRL+SHIFT+TAB

[/su_spoiler]

Navigate in Print Preview and Layout Preview

[su_spoiler title=”Dialog box and window operations” style=”fancy” icon=”plus-circle”]

To do thisPress
Open the Print dialog box from PrintCTRL+P (for datasheets, forms, and reports)
Open the Page Setup dialog box (forms and reports only)S
Zoom in or out on a part of the pageZ
Cancel Print Preview or Layout PreviewC or ESC

[/su_spoiler]

[su_spoiler title=”Viewing different pages” style=”fancy” icon=”plus-circle”]

To do thisPress
Move to the page number box; then type the page number and press ENTERALT+F5
View the next page (when Fit To Window is selected)PAGE DOWN or DOWN ARROW
View the previous page (when Fit To Window is selected)PAGE UP or UP ARROW

[/su_spoiler]

[su_spoiler title=”Navigating in Print Preview and Layout Preview” style=”fancy” icon=”plus-circle”]

To do thisPress
Scroll down in small incrementsDOWN ARROW
Scroll down one full screenPAGE DOWN
Move to the bottom of the pageCTRL+DOWN ARROW
Scroll up in small incrementsUP ARROW
Scroll up one full screenPAGE UP
Move to the top of the pageCTRL+UP ARROW
Scroll to the right in small incrementsRIGHT ARROW
Move to the right edge of the pageEND
Move to the lower-right corner of the pageCTRL+END
Scroll to the left in small incrementsLEFT ARROW
Move to the left edge of the pageHOME
Move to the upper-left corner of the pageCTRL+HOME

[/su_spoiler]

[su_spoiler title=”Any Pane” style=”fancy” icon=”plus-circle”]Hidden content[/su_spoiler]

[su_spoiler title=”Display and use windows” style=”fancy” icon=”plus-circle”]

To do thisPress
Move among the Query Designer panesF6, SHIFT+F6

[/su_spoiler]

[su_spoiler title=”Diagram Pane” style=”fancy” icon=”plus-circle”]

To do thisPress
Move among tables, views, and functions, (and to join lines, if available)TAB, or SHIFT+TAB
Move between columns in a table, view, or functionArrow keys
Choose the selected data column for outputSPACEBAR or PLUS key
Remove the selected data column from the query outputSPACEBAR or MINUS key
Remove the selected table, view, or function, or join line from the queryDELETE

[/su_spoiler]

[su_spoiler title=”Grid Pane” style=”fancy” icon=”plus-circle”]

To do thisPress
Move among cellsArrow keys or TAB or SHIFT+TAB
Move to the last row in the current columnCTRL+DOWN ARROW
Move to the first row in the current columnCTRL+UP ARROW
Move to the top left cell in the visible portion of gridCTRL+HOME
Move to the bottom right cellCTRL+END
Move in a drop-down listUP ARROW or DOWN ARROW
Select an entire grid columnCTRL+SPACEBAR
Toggle between edit mode and cell selection modeF2
Copy selected text in cell to the Clipboard (in edit mode)CTRL+C
Cut selected text in cell and place it on the Clipboard (in edit mode)CTRL+X
Paste text from the Clipboard (in edit mode)CTRL+V
Toggle between insert and overstrike mode while editing in a cellINS
Toggle the check box in the Output columnNOTE    If multiple items are selected, pressing this key affects all selected items.SPACEBAR
Clear the selected contents of a cellDELETE
Clear all values for a selected grid columnDELETE

[/su_spoiler]

Online Help

[su_spoiler title=”Keyboard shortcuts for using the Help window” style=”fancy” icon=”plus-circle”]

The Help window provides access to all Office Help content. The Help window displays topics and other Help content.

In the Help window

To do thisPress
Open the Help window.F1
Switch between the Help window and the active program.ALT+TAB
Go back to Program Name Home.ALT+HOME
Select the next item in the Help window.TAB
Select the previous item in the Help window.SHIFT+TAB
Perform the action for the selected item.ENTER
In the Browse Program Name Help section of the Help window, select the next or previous item, respectively.TAB or SHIFT+TAB
In the Browse Program Name Help section of the Help window, expand or collapse the selected item, respectively.ENTER
Select the next hidden text or hyperlink, including Show All or Hide All at the top of a topic.TAB
Select the previous hidden text or hyperlink.SHIFT+TAB
Perform the action for the selected Show All, Hide All, hidden text, or hyperlink.ENTER
Move back to the previous Help topic (Back button).ALT+LEFT ARROW or BACKSPACE
Move forward to the next Help topic (Forward button).ALT+RIGHT ARROW
Scroll small amounts up or down, respectively, within the currently displayed Help topic.UP ARROW, DOWN ARROW
Scroll larger amounts up or down, respectively, within the currently displayed Help topic.PAGE UP, PAGE DOWN
Stop the last action (Stop button).ESC
Refresh the window (Refresh button).F5
Print the current Help topic.NOTE    If the cursor is not in the current Help topic, press F6, and then press CTRL+P.CTRL+P
Change the connection state.F6, and then press ENTER to open the list of choices
Switch among areas in the Help window; for example, switch between the toolbar and the Search list.F6
In a Table of Contents in tree view, select the next or previous item, respectively.UP ARROW, DOWN ARROW
In a Table of Contents in tree view, expand or collapse the selected item, respectively.LEFT ARROW, RIGHT ARROW

[/su_spoiler]

Microsoft Office basics

[su_spoiler title=”Use Open and Save As in the Backstage” style=”fancy” icon=”plus-circle”]

To do thisPress
View Open in the Backstage.Ctrl+O
View Save As in the Backstage.Ctrl+S
Continue saving an Office file (after giving the file a name and location)Ctrl+S
View Save As in the Backstage (after giving the file a name and location)Alt+F+S
Return to your Office file.Esc

[/su_spoiler]

[su_spoiler title=”Use the Open and Save As dialog boxes” style=”fancy” icon=”plus-circle”]

To do thisPress
View the Open dialog box.Ctrl+F12
View the Save As dialog box.F12
Open the selected folder or file.ENTER
Open the folder one level above the selected folder.BACKSPACE
Delete the selected folder or file.DELETE
Display a shortcut menu for a selected item such as a folder or file.SHIFT+F10
Move forward through options.TAB
Move back through options.SHIFT+TAB
Open the Look in list.F4 or ALT+I

[/su_spoiler]

[su_spoiler title=”Display and use windows” style=”fancy” icon=”plus-circle”]

To do thisPress
Switch to the next window.ALT+TAB
Switch to the previous window.ALT+SHIFT+TAB
Close the active window.CTRL+W or CTRL+F4
Move to a task pane from another pane in the program window (clockwise direction). You might need to press F6 more than once.NOTE    If pressing F6 doesn’t display the task pane you want, try pressing ALT to place focus on the ribbon and then pressing CTRL+TAB to move to the task pane.F6
When more than one window is open, switch to the next window.CTRL+F6
Switch to the previous window.CTRL+SHIFT+F6
When a document window is not maximized, perform the Size command (on the Controlmenu for the window). Press the arrow keys to resize the window, and, when finished, press ENTER.CTRL+F8
Minimize a window to an icon (works for only some Microsoft Office programs).CTRL+F9
Maximize or restore a selected window.CTRL+F10
Copy a picture of the screen to the Clipboard.PRINT SCREEN
Copy a picture of the selected window to the Clipboard.ALT+PRINT SCREEN

[/su_spoiler]

[su_spoiler title=”Move around in text or cells” style=”fancy” icon=”plus-circle”]

To do thisPress
Move one character to the left.LEFT ARROW
Move one character to the right.RIGHT ARROW
Move one line up.UP ARROW
Move one line down.DOWN ARROW
Move one word to the left.CTRL+LEFT ARROW
Move one word to the right.CTRL+RIGHT ARROW
Move to the end of a line.END
Move to the beginning of a line.HOME
Move up one paragraph.CTRL+UP ARROW
Move down one paragraph.CTRL+DOWN ARROW
Move to the end of a text box.CTRL+END
Move to the beginning of a text box.CTRL+HOME
Repeat the last Find action.SHIFT+F4

[/su_spoiler]

[su_spoiler title=”Move around in and work in tables” style=”fancy” icon=”plus-circle”]

To do thisPress
Move to the next cell.TAB
Move to the preceding cell.SHIFT+TAB
Move to the next row.DOWN ARROW
Move to the preceding row.UP ARROW
Insert a tab in a cell.CTRL+TAB
Start a new paragraph.ENTER
Add a new row at the bottom of the table.TAB at the end of the last row

[/su_spoiler]

[su_spoiler title=”Access and use task panes” style=”fancy” icon=”plus-circle”]

To do thisPress
Move to a task pane from another pane in the program window. (You might need to press F6 more than once.)NOTE    If pressing F6 doesn’t display the task pane you want, try pressing ALT to place the focus on the ribbon and then pressing CTRL+TAB to move to the task pane.F6
When a task pane is active, select the next or previous option in the task pane.TAB or SHIFT+TAB
Display the full set of commands on the task pane menu.CTRL+DOWN ARROW
Move among choices on a selected submenu; move among certain options in a group of options in a dialog box.DOWN ARROW or UP ARROW
Open the selected menu, or perform the action assigned to the selected button.SPACEBAR or ENTER
Open a shortcut menu; open a drop-down menu for the selected gallery item.SHIFT+F10
When a menu or submenu is visible, select the first or last command on the menu or submenu.HOME or END
Scroll up or down in the selected gallery list.PAGE UP or PAGE DOWN
Move to the top or bottom of the selected gallery list.CTRL+HOME or CTRL+END

[/su_spoiler]

Tips

[su_spoiler title=”Use dialog boxes” style=”fancy” icon=”plus-circle”]

To do thisPress
Move to the next option or option group.TAB
Move to the previous option or option group.SHIFT+TAB
Switch to the next tab in a dialog box.CTRL+TAB
Switch to the previous tab in a dialog box.CTRL+SHIFT+TAB
Move between options in an open drop-down list, or between options in a group of options.Arrow keys
Perform the action assigned to the selected button; select or clear the selected check box.SPACEBAR
Open the list if it is closed and move to that option in the list.First letter of an option in a drop-down list
Select an option; select or clear a check box.ALT+ the letter underlined in an option
Open a selected drop-down list.ALT+DOWN ARROW
Close a selected drop-down list; cancel a command and close a dialog box.ESC
Perform the action assigned to a default button in a dialog box.ENTER

[/su_spoiler]

[su_spoiler title=”Use edit boxes within dialog boxes” style=”fancy” icon=”plus-circle”]

An edit box is a blank in which you type or paste an entry, such as your user name or the path of a folder.

To do thisPress
Move to the beginning of the entry.HOME
Move to the end of the entry.END
Move one character to the left or right.LEFT ARROW or RIGHT ARROW
Move one word to the left.CTRL+LEFT ARROW
Move one word to the right.CTRL+RIGHT ARROW
Select or cancel selection one character to the left.SHIFT+LEFT ARROW
Select or cancel selection one character to the right.SHIFT+RIGHT ARROW
Select or cancel selection one word to the left.CTRL+SHIFT+LEFT ARROW
Select or cancel selection one word to the right.CTRL+SHIFT+RIGHT ARROW
Select from the insertion point to the beginning of the entry.SHIFT+HOME
Select from the insertion point to the end of the entry.SHIFT+END

[/su_spoiler]

So this is Microsoft Access keyboard shortcuts a complete list.

WE RECOMMEND

Microsoft Excel Keyboard shortcuts

Microsoft Word Keyboard shortcuts

Microsoft Outlook 2013 Keyboard shortcuts

Microsoft PowerPoint keyboard shortcuts

Compsmag - Tech News, Best lists, Reviews and How to Tutorials