|
or F10 Select the active tab of the ribbon and activate KeyTips |
||
|
Open the Home tab |
||
|
Move the focus to a different pane of the window |
||
|
Open an existing database |
||
or
|
|||
|
Show or hide the Navigation Pane |
||
|
Show or hide a property sheet |
||
|
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 |
||
|
Move to the next or previous field in a Datasheet view |
||
or
|
|||
|
Go to a specific record in a Datasheet view |
||
|
Open the Print dialog box from Print (for datasheets, forms, and reports) |
||
|
Open the Page Setup dialog box (for forms and reports) |
||
|
Zoom in or out on a part of the page |
||
|
Open the Find tab in the Find and Replace dialog box in the Datasheet view or Form view |
||
|
Open the Replace tab in the Find and Replace dialog box in the Datasheet view or Form view |
||
|
Add a new record in Datasheet view or Form view |
||
|
Open the Help window |
||
|
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:
|
|||
|
Open the File page |
||
|
Open the Home tab |
||
|
Open the Create tab |
||
|
Open the External Data tab |
||
|
Open the Database Tools tab |
||
|
B Open the Fields tab |
||
|
T Open the Table tab |
||
|
2 Open the Add-ins tab, if present |
||
|
and then enter the search term to open the Tell me box on the ribbon |
||
|
Move between groups on a ribbon |
||
|
Move between commands within a group |
||
or
|
|||
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:
|
|||
|
Select the active tab of the ribbon and activate KeyTips |
||
or
|
|||
|
Move to a different tab |
||
|
Move the focus to commands on the ribbon |
||
or
|
|||
|
Move among the items on the ribbon |
||
|
Expand or collapse the ribbon |
||
|
Display the shortcut menu for the selected item |
||
|
Move the focus to a different pane of the window |
||
|
Move to the next or previous command on the ribbon |
||
or
|
|||
|
Activate the selected command or control on the ribbon |
||
or
|
|||
|
Open the selected menu or gallery on the ribbon |
||
or
|
|||
|
Open the selected list on the ribbon, such as the Font list |
||
|
Move between items in an open menu or gallery |
||
|
Finish modifying a value in a control on the ribbon, and move the focus back to the document |
|
Open a new database |
||
|
Open an existing database |
||
or
|
|||
|
Open the selected folder or file |
||
|
Open the folder one level above the selected folder |
||
|
Delete the selected folder or file |
||
|
Display a shortcut menu for a selected item such as a folder or file |
||
|
Move forward through options |
||
|
Move backward through options |
||
|
Open the Look in list |
||
or
|
|||
|
Save a database object |
||
or
|
|||
|
Open the Save As dialog box |
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.
|
|||
|
Show or hide the Navigation Pane |
||
|
Go to the Navigation PaneSearch box (if the focus is already on the Navigation Pane) |
||
|
Switch to the next or previous pane in the workspace |
||
or
|
|||
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.
|
|||
|
Switch to the next or previous database window |
||
or
|
|||
|
Restore the selected minimized window when all windows are minimized |
||
|
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) |
||
|
Close the active database window |
||
or
|
|||
|
Switch between the Visual Basic Editor and the previous active window |
||
|
Maximize or restore a selected window |
||
Working with menus, dialog boxes, wizards, and property sheets
|
|||
|
or F10 Show KeyTips |
||
|
Show the program icon menu (on the program title bar), also known as the control menu |
||
|
With the menu or submenu visible, select the previous or next command |
||
|
Select the menu to the left or right; or, when a submenu is visible, switch between the main menu and the submenu |
||
|
Select the first or last command on the menu or submenu |
||
or
|
|||
|
Open the selected menu, or perform the action assigned to the selected button |
||
or
|
|||
|
Open a shortcut menu or open a drop-down menu for the selected gallery item |
||
|
Scroll up or down in the selected gallery list |
||
or
|
|||
|
Move to the top or bottom of the selected gallery list |
||
or
|
|||
|
Close the visible menu and submenu at the same time |
||
|
Close the visible menu; or, with a submenu visible, close only the submenu |
|
Switch to the next or previous tab in a dialog box |
||
or
|
|||
|
Move to the next or previous option or option group |
||
or
|
|||
|
Move between options in the selected drop-down list box, or move between options in a group of options |
||
|
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
|
|||
|
Select the option, or select or clear the check box by the letter underlined in the option name |
||
|
Open the selected drop-down list box |
||
|
Close the selected drop-down list box |
||
|
Perform the action assigned to the default button in the dialog box |
||
|
Cancel the command and close the dialog box |
|
Show or hide the property sheet |
||
|
Display a property sheet in Design view |
||
|
Move among choices in the control selection drop-down list one item at a time |
||
|
Move among choices in the control selection drop-down list one page at a time |
||
or
|
|||
|
Move to the property sheet tabs from the control selection drop-down list |
||
|
Move among the property sheet tabs with a tab selected, but no property selected |
||
|
With a property already selected, move down one property on a tab |
||
|
With a property selected, move up one property on a tab; or if already at the top, move to the tab |
||
|
Toggle forward between tabs when a property is selected |
||
|
Toggle backward between tabs when a property is selected |
|
Move to the beginning of the entry |
||
|
Move to the end of the entry |
||
|
Move one character to the left or right |
||
|
Move one word to the left or right |
||
or
|
|||
|
Select from the insertion point to the beginning of the text entry |
||
|
Select from the insertion point to the end of the text entry |
||
|
Change the selection by one character to the left |
||
|
Change the selection by one character to the right |
||
|
Change the selection by one word to the left |
||
|
Change the selection by one word to the right |
|
Open a combo box |
||
or
|
|||
|
Refresh the contents of a Lookup field list box or combo box |
||
|
Move down one line |
||
|
Move down one page |
||
|
Move up one line |
||
|
Exit the combo box or list box |
||
|
Open the Edit List Items dialog box |
||
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.
|
|
Open the selected table or query in Datasheet view |
||
|
Open the selected form or report |
||
|
Run the selected macro |
||
|
Open the selected table, query, form, report, macro, or module in Design view |
||
|
Display the Immediate window in the Visual Basic Editor |
|
Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet |
||
|
Exit Navigation mode and return to Edit mode in a form or report |
||
|
Switch to the property sheet (Design view and Layout view in forms and reports) |
||
or
|
|||
|
Switch to Form view from form Design view |
||
|
Switch between the upper and lower portions of a window (Design view of queries, macros, and the Advanced Filter/Sort window) |
||
|
Cycle through the field grid, property sheet, field properties, the Navigation Pane, Quick Access Toolbar, and KeyTips on the ribbon (Design view of tables) |
||
|
Open the Choose Builder dialog box from a selected control on a form or report (Design view only) |
||
|
Open the Visual Basic Editor from a selected property in the property sheet for a form or report |
||
|
Switch from the Visual Basic Editor back to form or report Design view |
||
|
Toggle forward between views when in a table, query, form, or report |
||
or
|
|||
Note: If additional views are available, successive keystrokes move the focus to the next available view.
|
|||
|
Toggle backward between views when in a table, query, form, or report |
||
or
|
|||
Note: Ctrl+Period (.) does not work under all conditions with all objects.
|
|
Move to the next field |
||
or
|
|||
|
Move to the last field in the current record |
||
|
Move to the previous field |
||
or
|
|||
|
Move to the first field in the current record |
||
|
Move to the current field in the next record |
||
|
Move to the current field in the last record |
||
|
Move to the last field in the last record |
||
|
Move to the current field in the previous record |
||
|
Move to the current field in the first record |
||
|
Move to the first field in the first record |
||
|
(then, in the record number box, type the record number and press Enter) Go to a specific record |
|
Move up one screen |
||
|
Move down one screen |
||
|
Move right one screen |
||
|
Move left one screen |
|
Select the current column or cancel the column selection, in Navigation mode only |
||
|
Extend the selection one column to the right, if the current column is selected |
||
|
Extend the selection one column to the left, if the current column is selected |
||
|
ht Turn on Move mode |
|
Enter the subdatasheet from the last field of the previous record in the datasheet |
||
|
Enter the subdatasheet from the first field of the following record in the datasheet |
||
|
Exit the subdatasheet and move to the first field of the next record in the datasheet |
||
|
Exit the subdatasheet and move to the last field of the previous record in the datasheet |
||
|
From the last field in the subdatasheet enter the next field in the datasheet |
||
|
From the datasheet, bypass the subdatasheet and move to the next record in the datasheet |
||
|
From the datasheet, bypass the subdatasheet and move to the previous record in the datasheet |
||
|
Go to a specific record in a subdatasheet |
||
Note: This moves the focus from the subdatasheet to the record number box.
|
|||
|
Move from the datasheet to the record's subdatasheet |
||
|
Collapse the subdatasheet |
||
Note: To navigate between fields and records in a subdatasheet, use the same keyboard shortcuts you use in Datasheet view.
|
|
Switch between Edit mode (with insertion point displayed) and Navigation mode |
||
|
Open or close the property sheet |
||
or
|
|||
|
Switch to Form view from form Design view |
||
|
Switch between the upper and lower portions of a window (Design view of queries, macros, and the Advanced Filter/Sort window) |
||
Note: Use F6 when the Tab key does not take you to the section of the screen you want.
|
|||
|
Toggle forward between the design pane, properties, Navigation Pane, ribbon, and Zoom controls (Design view of tables, forms, and reports) |
||
|
Open the Visual Basic Editor from a selected property in the property sheet for a form or report |
||
|
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) |
||
|
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 |
||
|
Copy the selected control to the Clipboard |
||
|
Cut the selected control and copy it to the Clipboard |
||
|
Paste the contents of the Clipboard in the upper-left corner of the selected section |
||
|
Move the selected control to the right by a pixel along the page's grid |
||
|
Move the selected control to the left by a pixel along the page's grid |
||
|
Move the selected control up by a pixel along 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.
|
|||
|
Move the selected control down by a pixel along 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.
|
|||
|
Move the selected control to the right by a pixel (irrespective of the page's grid) |
||
|
Move the selected control to the left by a pixel (irrespective of the page's grid) |
||
|
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.
|
|||
|
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.
|
|||
|
Increase the width of the selected control (to the right) by a pixel |
||
Note: For controls in a stacked layout, this increases the width of the whole layout.
|
|||
|
Decrease the width of the selected control (to the left) by a pixel |
||
Note: For controls in a stacked layout, this decreases the width of the whole layout.
|
|||
|
Decrease the height of the selected control (from the bottom) by a pixel |
||
|
Increase the height of the selected control (from the bottom) by a pixel |
|
Copy the selected control to the Clipboard |
||
|
Cut the selected control and copy it to the Clipboard |
||
|
Paste the contents of the Clipboard in the upper-left corner of the selected section |
||
|
Move the selected control to the right (except a control that is part of a layout) |
||
|
(Move in smaller increments) Move the selected control to the right (except a control that is part of a layout) |
||
|
Move the selected control to the left (except a control that is part of a layout) |
||
|
(Move in smaller increments) Move the selected control to the left (except a control that is part of a layout) |
||
|
Move the selected control up (except a control that is part of a layout) |
||
|
(Move in smaller increments) Move the selected control up (except a control that is part of a layout) |
||
|
Move the selected control down (except a control that is part of a layout) |
||
|
(Move in smaller increments) Move the selected control down (except a control that is part of a layout) |
||
|
Increase the height of the selected control |
||
Note: If used with a control that is in a layout, the entire row of the layout is resized.
|
|||
|
Increase the width of the selected control |
||
Note: If used with a control that is in a layout, the entire column of the layout is resized.
|
|||
|
Reduce the height of the selected control |
||
Note: If used with a control that is in a layout, the entire row of the layout is resized.
|
|||
|
Reduce the width of the selected control |
||
Note: If used with a control that is in a layout, the entire column of the layout is resized.
|
|
Move to the next field |
||
|
Move to the previous field |
||
|
Move to the last control on the form and remain in the current record |
||
|
Move to the last control on the form and set focus in the last record |
||
|
Move to the first control on the form and remain in the current record |
||
|
Move to the first control on the form and set focus in the first record |
||
|
Move to the current field in the next record |
||
|
Move to the current field in the previous record |
||
|
Go to a specific record |
|
Enter the subform from the preceding field in the main form |
||
|
Enter the subform from the following field in the main form |
||
|
Exit the subform and move to the next field in the master form or next record |
||
|
Exit the subform and move to the previous field in the main form or previous record |
|
Open the Print dialog box from Print (for datasheets, forms, and reports) |
||
|
Open the Page Setup dialog box (for forms and reports) |
||
|
Zoom in or out on a part of the page |
||
|
Cancel Print Preview or Layout Preview |
||
or
|
|||
|
Scroll down in small increments |
||
|
Scroll down one full screen |
||
|
Move to the bottom of the page |
||
|
Scroll up in small increments |
||
|
Scroll up one full screen |
||
|
Move to the top of the page |
||
|
Scroll to the right in small increments |
||
|
Move to the right edge of the page |
||
|
Move to the lower-right corner of the page |
||
|
Scroll to the left in small increments |
||
|
Move to the left edge of the page |
||
|
Move to the upper-left corner of the page |
||
|
Move to the page number box |
|
Move among tables, views, and functions (and join lines, if available) |
||
or
|
|||
|
Move between columns in a table, view, or function |
||
|
Choose the selected data column for output |
||
or
|
|||
|
Remove the selected data column from the query output |
||
or
|
|||
|
Remove the selected table, view, or function, or join line from the query |
||
Note: If multiple items are selected, pressing Spacebar affects all selected items. Select multiple items by holding down Shift while selecting them. Toggle the selected state of a single item by holding down Ctrl while selecting it.
|
|
Move among cells |
||
or
|
|||
or
|
|||
|
Move to the last row in the current column |
||
|
Move to the first row in the current column |
||
|
Move to the upper-left cell in the visible portion of grid |
||
|
Move to the bottom right cell |
||
|
Move in a drop-down list |
||
or
|
|||
|
Select an entire grid column |
||
|
Toggle between Edit mode and cell selection mode |
||
|
Copy selected text in cell to the Clipboard (in Edit mode) |
||
|
Cut selected text in cell and place it on the Clipboard (in Edit mode) |
||
|
Paste text from the Clipboard (in Edit mode) |