|
Extend the selection to the previous record, if the current record is selected |
||
|
Move the insertion point to the end of the field, in multi-line fields |
||
|
Move to the last control on the form and set focus in the last record |
||
|
Move to the lower-right corner of the page |
||
|
Move to the bottom right cell |
||
|
Move to the end of a text box |
||
|
Increase the height of the selected control |
||
|
Increase the height of the selected control (from the bottom) by a pixel |
||
|
Move to the last field in the last record |
||
|
Move to the top or bottom of the selected gallery list |
||
|
Toggle between insert and overtype mode while editing in a cell |
||
|
Exit Access |
||
or
|
|||
|
Close the active database window |
||
|
With the menu or submenu visible, select the previous or next command |
||
|
Move among choices in the control selection drop-down list one item at a time |
||
|
In a Table of Contents in tree view, select the previous or next item, respectively |
||
|
Scroll small amounts up or down within the currently displayed Help topic |
||
|
Move up or down the Field List pane |
||
|
Extend a selection to adjacent rows in Datasheet view |
||
|
Extend a selection to adjacent fields in the same row in Datasheet view |
||
|
Move among the property sheet tabs with a tab selected, but no property selected |
||
|
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 |
||
|
Open a combo box |
||
|
Open the selected drop-down list box |
||
|
Switch to the next or previous tab in a dialog box |
||
|
Toggle backward between tabs when a property is selected |
||
|
Exit the subdatasheet and move to the last field of the previous record in the datasheet |
||
|
Exit the subform and move to the previous field in the main form or previous record |
||
|
Delete all characters to the right of the insertion point |
||
|
Open the Create tab |
||
|
Toggle forward between views when in a table, query, form, or report |
||
|
Move right one screen |
||
|
Move to the current field in the next record |
||
|
Move to the current field in the previous record |
||
|
Move left one screen |
||
|
Toggle backward between views when in a table, query, form, or report |
||
|
Change the selection by one word to the right |
||
|
Display the shortcut menu for the selected item |
||
|
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 |
||
|
Change the size of the selection by one word to the right |
||
|
Change the size of the selection by one word to the left |
||
|
Complete the wizard |
||
|
Open the File page |
||
|
Change the selection by one word to the left |
||
|
Switch between selecting the current record and the first field of the current record, in Navigation mode |
||
|
Open the Zoom box to conveniently enter expressions and other text in small input areas |
||
|
Switch to the next or previous database window |
||
|
Switch to the next or previous pane in the workspace |
||
|
Collapse the subdatasheet |
||
|
Open the External Data tab |
||
|
Move to the next page of the wizard |
||
|
Move from the datasheet to the record's subdatasheet |
||
|
Invoke a Builder |
||
|
Open the Look in list |
||
|
Repeat the last Find action |
||
|
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) |
||
Advertisement |
|||
|
Expand or collapse the ribbon |
||
|
Select from the insertion point to the end of the text entry |
||
|
Select from the insertion point to the beginning of the text entry |
||
|
Open the Home tab |
||
or
|
|||
|
When you have a code module open, switch from the Visual Basic Editor to form or report Design view |
||
|
Switch from a control's property sheet in form or report Design view to the design surface without changing the control focus |
||
|
and then enter the search term to open the Tell me box on the ribbon |
||
|
Undo the previous extension |
||
|
Requery the underlying tables; in a subform, this requeries the underlying table only for the subform |
||
|
Save a database object |
||
|
Move to the previous page of the wizard |
||
|
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) |
||
|
Open an existing database |
||
or
|
|||
|
Go back to Access Help Home |
||
|
Maximize or restore a selected window |
||
|
Invoke the Field List pane in a form, or report (if the Field List pane is already open, the focus moves to the Field List pane) |
||
|
Show or hide the Field List pane |
||
|
Undo typing |
||
|
Move between groups on a ribbon |
||
|
Show the program icon menu (on the program title bar), also known as the control menu |
||
|
Go to a specific record in a subdatasheet |
||
|
Move to the page number box |
||
|
Copy a screenshot of the entire screen to the Clipboard |
||
|
Insert the current date |
||
|
Open the Database Tools tab |
||
|
Insert the value from the same field in the previous record |
||
|
Switch between the Visual Basic Editor and the previous active window |
||
|
Switch from the Visual Basic Editor back to form or report Design view |
||
|
Switch to the next or previous database window |
||
|
Insert the default value for a field |
||
|
Move between fields vertically |
||
|
Copy a screenshot of the current window to the Clipboard |
||
|
Select the option, or select or clear the check box by the letter underlined in the option name |
||
|
Insert the current time |
||
|
er Open the list of choices and change the connection state |
||
|
B Open the Fields tab |
||
|
T Open the Table tab |
||
|
2 Open the Add-ins tab, if present |
||
|
ht Turn on Move mode |
Advertisement
Note: This moves the focus from the subdatasheet to the record number box.
|
|||
Note: To navigate between fields and records in a subdatasheet, use the same keyboard shortcuts you use in Datasheet view.
|
Note: Use F6 when the Tab key does not take you to the section of the screen you want.
|
|||
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.
|
|||
|
|||
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.
|
|||
|
|||
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.
|
|||
Note: For controls in a stacked layout, this increases the width of the whole layout.
|
|||
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.
|
|||
|
Note: For controls in a stacked layout, this decreases the width of the whole layout.
|
|||
Note: If used with a control that is in a layout, the entire row of the layout is resized.
|
|||
Note: If used with a control that is in a layout, the entire row of the layout is resized.
|
|||
Note: If used with a control that is in a layout, the entire column of the layout is resized.
|
|||
Note: If used with a control that is in a layout, the entire column of the layout is resized.
|
Note: Ctrl+Period (.) does not work under all conditions with all objects.
|
Note: If additional views are available, successive keystrokes move the focus to the next available view.
|
Note: F2 works only when the object is closed.
|
|||
Note: In order to use the Ctrl+E keyboard shortcut for opening the Edit List Items dialog box, you must have an Office 365 subscription. Currently this shortcut is only available to Insiders at this time.
|
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:
|
|||
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
|
Working with menus, dialog boxes, wizards, and property sheets
|
|||
|
Open the Save As dialog box |
What is your favorite Microsoft Access 2019 hotkey? Do you have any useful tips for it? Let other users know below.
1106799
498270
411259
366077
306918
277367
9 hours ago
16 hours ago
17 hours ago
20 hours ago
21 hours ago Updated!
1 days ago Updated!
Latest articles