|
Zoom in or out on a part of the page |
||
|
Save changes to the current record |
||
|
Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet or design view |
||
|
Switch to Form view from form Design view |
||
|
Go to a specific record in a Datasheet view |
||
|
Move the focus to a different pane of the window |
||
|
Move to the top or bottom of the selected gallery list |
||
|
Switch to Form view from form Design view |
||
|
Open an existing database |
||
|
Move to the previous page of the wizard |
||
|
Show the program icon menu (on the program title bar), also known as the control menu |
||
|
Insert a new line in a Short Text or Long Text field |
||
|
Show or hide the property sheet |
||
|
Open the folder one level above the selected folder |
||
|
Open a new database |
||
|
Open the Zoom box to conveniently enter expressions and other text in small input areas |
||
|
Move to the next or previous option or option group |
||
|
Switch to the next or previous pane in the workspace |
||
|
and then enter the search term to open the Tell me box on the ribbon |
||
|
Open the Create tab |
||
|
Restore the selected minimized window when all windows are minimized |
||
|
Select the option, or select or clear the check box by the letter underlined in the option name |
||
|
Move between fields vertically |
||
|
Zoom in or out on a part of the page |
||
|
Open the Home tab |
||
|
Switch to Form view from form Design view |
||
|
Show or hide the Navigation Pane |
||
|
Move the focus to a different pane of the window |
||
|
Open an existing database |
||
or
|
|||
|
Show or hide a property sheet |
||
|
Show or hide the Navigation Pane |
||
|
From Print Preview, open the Print dialog box |
||
|
Move to the top or bottom of the selected gallery list |
||
|
Close the active database window |
||
or
|
|||
|
Toggle forward between tabs when a property is selected |
||
|
Switch to the next or previous tab in a dialog box |
||
|
Display a property sheet in Design view |
||
|
Switch to the next or previous tab in a dialog box |
||
|
Toggle backward between tabs when a property is selected |
||
|
Open the Replace tab in the Find and Replace dialog box in the Datasheet view or Form view |
||
|
Activate the selected command or control on the ribbon |
||
|
Open the selected menu or gallery on the ribbon |
||
|
Open the selected menu, or perform the action assigned to the selected button |
||
|
Perform the action assigned to the selected button; select or clear the check box |
||
|
Open the selected list on the ribbon, such as the Font list |
||
|
Move one word to the left or right |
||
or
|
|||
|
Move to the next or previous command on the ribbon |
||
|
Move between items in an open menu or gallery |
||
|
Move forward through options |
||
|
Move to the next or previous field in a Datasheet view |
||
|
Move to the property sheet tabs from the control selection drop-down list |
||
|
With a property already selected, move down one property on a tab |
||
|
Move between commands within a group |
||
|
Move the focus to commands on the ribbon |
||
|
Open an existing database |
||
|
Close the visible menu; or, with a submenu visible, close only the submenu |
||
Advertisement |
|||
|
From the Backstage, return to your database |
||
|
Move to the end of the entry |
||
|
Select the first or last command on the menu or submenu |
||
or
|
|||
|
Move to the beginning of the entry |
||
|
Switch to the next or previous pane in the workspace |
||
|
Open the Print dialog box from Print (for datasheets, forms, and reports) |
||
|
From Print Preview, open the Print dialog box |
||
|
Print the current or selected object |
||
|
Save a database object |
||
|
Add a new record in Datasheet view or Form view |
||
|
Delete the selected folder or file |
||
|
Open the Find tab in the Find and Replace dialog box in the Datasheet view or Form view |
||
|
Open the Look in list |
Advertisement
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.
|
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:
|
|||
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:
|
|||
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.
|
|||
Working with menus, dialog boxes, wizards, and property sheets
|
|||
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
|
|
or F10 Select the active tab of the ribbon and activate KeyTips |
||
|
or F10 Show KeyTips |
||
|
Close the visible menu and submenu at the same time |
||
|
Select the active tab of the ribbon and activate KeyTips |
||
|
Switch to the next or previous database window |
||
|
Select the menu to the left or right; or, when a submenu is visible, switch between the main menu and the submenu |
||
|
Move one character to the left or right |
||
|
Move among the property sheet tabs with a tab selected, but no property selected |
||
|
Move among choices in the control selection drop-down list one item at a time |
||
|
With the menu or submenu visible, select the previous or next command |
||
|
Expand or collapse the ribbon |
||
|
Move between groups on a ribbon |
||
|
Switch between the Visual Basic Editor and the previous active window |
||
|
Open the Database Tools tab |
||
|
B Open the Fields tab |
||
|
T Open the Table tab |
||
|
2 Open the Add-ins tab, if present |
||
|
Open the Save As dialog box |
||
|
Open the Page Setup dialog box (for forms and reports) |
||
|
From Print Preview, open the Page Setup dialog box |
||
|
Move among choices in the control selection drop-down list one page at a time |
||
|
Scroll up or down in the selected gallery list |
||
or
|
|||
|
Move among choices in the control selection drop-down list one page at a time |
||
|
Open the Home tab |
||
|
Change the selection by one character to the left |
||
|
Select from the insertion point to the beginning of the text entry |
||
|
Select from the insertion point to the end of the text entry |
||
|
Open the External Data tab |
||
|
Open the Look in list |
||
|
Open the File page |
||
|
Display a shortcut menu for a selected item such as a folder or file |
||
|
Open a shortcut menu or open a drop-down menu for the selected gallery item |
||
|
Display the shortcut menu for the selected item |
||
|
Move to a different tab |
||
|
Move among the items on the ribbon |
||
|
Move between options in the selected drop-down list box, or move between options in a group of options |
||
|
Save a database object |
||
|
Finish modifying a value in a control on the ribbon, and move the focus back to the document |
||
|
Open the selected menu or gallery on the ribbon |
||
|
Activate the selected command or control on the ribbon |
||
|
Open the selected folder or file |
||
|
Open the selected menu, or perform the action assigned to the selected button |
||
|
Open the Help window |
||
|
Exit Access |
||
|
Move between commands within a group |
||
|
Move the focus to commands on the ribbon |
||
|
Move to the next or previous option or option group |
||
|
With a property selected, move up one property on a tab; or if already at the top, move to the tab |
||
|
Move backward through options |
||
|
Move to the next or previous field in a Datasheet view |
||
|
Move to the next or previous command on the ribbon |
||
|
or Esc Cancel Print Preview or Layout Preview |
||
|
Select the active tab of the ribbon and activate KeyTips |
||
|
Switch to the next or previous database window |
||
|
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) |
||
|
Maximize or restore a selected window |
What is your favorite Microsoft Access 2019 hotkey? Do you have any useful tips for it? Let other users know below.
1105852
497916
411098
365367
306523
276986
60 minutes ago
12 hours ago Updated!
14 hours ago
Yesterday
3 days ago
3 days ago Updated!
Latest articles