Microsoft Access 2019 keyboard shortcuts ‒ defkey

0	Alt	or F10 Select the active tab of the ribbon and activate KeyTips
0	Alt + H	Open the Home tab
-1	F6	Move the focus to a different pane of the window
0	Ctrl + O	Open an existing database
-1	or Ctrl + F12
-2	F11	Show or hide the Navigation Pane
-2	F4	Show or hide a property sheet
1	F2	Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet or design view
0	F5	Switch to Form view from form Design view
0	Tab	Move to the next or previous field in a Datasheet view
0	or ↑ Shift + Tab
1	F5	Go to a specific record in a Datasheet view
0	Ctrl + P	Open the Print dialog box from Print (for datasheets, forms, and reports)
0	S	Open the Page Setup dialog box (for forms and reports)
0	Z	Zoom in or out on a part of the page
0	Ctrl + F	Open the Find tab in the Find and Replace dialog box in the Datasheet view or Form view
0	Ctrl + H	Open the Replace tab in the Find and Replace dialog box in the Datasheet view or Form view
0	Ctrl + +	Add a new record in Datasheet view or Form view
0	F1	Open the Help window
0	Alt + F4	Exit Access

There are two ways to navigate the tabs in the ribbon:
To get to the ribbon, press Alt, and then, to move between tabs, use the Right Arrow and Left Arrow keys.
To go directly to a tab on the ribbon, press one of the following KeyTips:
0	Alt + F	Open the File page
0	Alt + H	Open the Home tab
0	Alt + C	Open the Create tab
0	Alt + X	Open the External Data tab
0	Alt + Y	Open the Database Tools tab
0	Alt + J then B	B Open the Fields tab
0	Alt + J then T	T Open the Table tab
0	Alt + X then 2	2 Open the Add-ins tab, if present
0	Alt + Q	and then enter the search term to open the Tell me box on the ribbon
0	Ctrl + ← →	Move between groups on a ribbon
0	Tab	Move between commands within a group
0	or ↑ Shift + Tab
You activate controls in different ways, depending upon the type of control.
If the selected command is a button, to activate it, press Spacebar or Enter.
If the selected command is a split button (that is, a button that opens a menu of additional options), to activate it, press Alt+Down Arrow. Tab through the options. To select the current option, press Spacebar or Enter.
If the selected command is a list (such as the Font list), to open the list, press the Down Arrow key. Then, to move between items, press the Up Arrow key or the Down Arrow key.
If the selected command is a gallery, to select the command, press Spacebar or Enter. Then, tab through the items.
Here is the ways to move the focus by using the keyboard:
0	Alt	Select the active tab of the ribbon and activate KeyTips
0	or F10
0	← ↑ → ← ↓ →	Move to a different tab
0	Tab	Move the focus to commands on the ribbon
0	or ↑ Shift + Tab
0	← ↑ → ← ↓ →	Move among the items on the ribbon
0	Ctrl + F1	Expand or collapse the ribbon
0	↑ Shift + F10	Display the shortcut menu for the selected item
1	F6	Move the focus to a different pane of the window
0	Tab	Move to the next or previous command on the ribbon
0	or ↑ Shift + Tab
0	Space	Activate the selected command or control on the ribbon
0	or ⤶ Enter
0	Space	Open the selected menu or gallery on the ribbon
0	or ⤶ Enter
0	↓	Open the selected list on the ribbon, such as the Font list
0	Tab	Move between items in an open menu or gallery
0	⤶ Enter	Finish modifying a value in a control on the ribbon, and move the focus back to the document

0	Ctrl + N	Open a new database
0	Ctrl + O	Open an existing database
-1	or Ctrl + F12
0	⤶ Enter	Open the selected folder or file
0	Backspace	Open the folder one level above the selected folder
0	Del	Delete the selected folder or file
0	↑ Shift + F10	Display a shortcut menu for a selected item such as a folder or file
0	Tab	Move forward through options
0	↑ Shift + Tab	Move backward through options
0	F4	Open the Look in list
0	or Alt + I
0	Ctrl + S	Save a database object
0	or ↑ Shift + F12
0	F12 or Alt + F + S	Open the Save As dialog box

0	Ctrl + P	Print the current or selected object
0	P	From Print Preview, open the Print dialog box
0	or Ctrl + P
0	S	From Print Preview, open the Page Setup dialog box
0	C	or Esc Cancel Print Preview or Layout Preview
0	Esc	From the Backstage, return to your database

By default, Access databases display as tabbed documents. To switch to windowed documents instead, on the File tab, select Options. In the Access Options dialog box, select Current Database and, under Document Window Options, select Overlapping Windows.
-1	F11	Show or hide the Navigation Pane
0	Ctrl + F	Go to the Navigation PaneSearch box (if the focus is already on the Navigation Pane)
0	F6	Switch to the next or previous pane in the workspace
0	or ↑ Shift + F6
Note: You might need to press F6 more than once; if pressing F6 doesn't display the task pane you want, press Alt to move the focus on the ribbon and then press Ctrl+Tab to move to the task pane.
0	Ctrl + F6	Switch to the next or previous database window
0	or Ctrl + ↑ Shift + F6
0	⤶ Enter	Restore the selected minimized window when all windows are minimized
0	Ctrl + F8	Turn on Resize mode for the active window when it is not maximized (press the arrow keys to resize the window, and then, to apply the new size, press Enter)
0	Ctrl + W	Close the active database window
0	or Ctrl + F4
0	Alt + F11	Switch between the Visual Basic Editor and the previous active window
0	Ctrl + F10	Maximize or restore a selected window
Working with menus, dialog boxes, wizards, and property sheets
0	Alt	or F10 Show KeyTips
0	Alt + Space	Show the program icon menu (on the program title bar), also known as the control menu
0	↑ ↓	With the menu or submenu visible, select the previous or next command
0	← →	Select the menu to the left or right; or, when a submenu is visible, switch between the main menu and the submenu
0	Home	Select the first or last command on the menu or submenu
0	or End
0	Space	Open the selected menu, or perform the action assigned to the selected button
0	or ⤶ Enter
0	↑ Shift + F10	Open a shortcut menu or open a drop-down menu for the selected gallery item
0	Page Up	Scroll up or down in the selected gallery list
0	or Page Down
0	Ctrl + Home	Move to the top or bottom of the selected gallery list
0	or Ctrl + End
0	Alt	Close the visible menu and submenu at the same time
0	Esc	Close the visible menu; or, with a submenu visible, close only the submenu

0	Ctrl + Tab	Switch to the next or previous tab in a dialog box
0	or Ctrl + ↑ Shift + Tab
0	Tab	Move to the next or previous option or option group
0	or ↑ Shift + Tab
0	← ↑ → ← ↓ →	Move between options in the selected drop-down list box, or move between options in a group of options
0	Space	Perform the action assigned to the selected button; select or clear the check box
First letter of an option in a drop-down list: Open the list if it is closed and move to an option in the list
0	Alt + A - Z	Select the option, or select or clear the check box by the letter underlined in the option name
0	Alt + ↓	Open the selected drop-down list box
0	Esc	Close the selected drop-down list box
0	⤶ Enter	Perform the action assigned to the default button in the dialog box
0	Esc	Cancel the command and close the dialog box

0	Tab	Toggle the focus forward between controls in the wizard
0	F6	Toggle the focus between sections (header, body, footer) of the wizard
0	Alt + N	Move to the next page of the wizard
0	Alt + B	Move to the previous page of the wizard
0	Alt + F	Complete the wizard

0	F4	Show or hide the property sheet
0	Alt + ⤶ Enter	Display a property sheet in Design view
0	↑ ↓	Move among choices in the control selection drop-down list one item at a time
0	Page Down	Move among choices in the control selection drop-down list one page at a time
0	or Page Up
0	Tab	Move to the property sheet tabs from the control selection drop-down list
0	← →	Move among the property sheet tabs with a tab selected, but no property selected
0	Tab	With a property already selected, move down one property on a tab
0	↑ Shift + Tab	With a property selected, move up one property on a tab; or if already at the top, move to the tab
0	Ctrl + Tab	Toggle forward between tabs when a property is selected
0	Ctrl + ↑ Shift + Tab	Toggle backward between tabs when a property is selected

0	Home	Move to the beginning of the entry
0	End	Move to the end of the entry
0	← →	Move one character to the left or right
0	Ctrl + ←	Move one word to the left or right

Please temporarily enable JavaScript in your browser to post text. This is to avoid comment bots. We're sorry for inconvenience. #commentForm { display: none; }