Keyboard shortcuts for Access desktop databases on Windows: Access for Microsoft 365 and Access 2016 to 2024. The first table is Microsoft's shortlist of frequently used keys; its rows are not repeated below, and ribbon KeyTips are listed for the tabs only. What a key does depends on where you are, so each section names its context: Tab does one thing in a datasheet and another in a dialog box. F2 switches a field between Navigation mode and Edit mode.
254 shortcuts in 23 sections.Checked row by row against Microsoft Support on .Edited by Jay.
Frequently used shortcuts 18
Action
Windows
Open existing databaseOpens a database that already exists; Ctrl + N starts a new one instead.
Ctrl+O
Show or hide Navigation PaneHides or brings back the Navigation Pane, the list of the database's tables, queries, forms and other objects.
F11
Move to next paneMoves the focus to another pane of the window; keep pressing until the pane you want has it.
F6
Switch Edit and Navigation modeToggles a field between Navigation mode and Edit mode, which shows the insertion point, in Datasheet View or Design View.
F2
Next fieldMoves to the next field in Datasheet View or Form View.
Tab
Previous fieldMoves back to the previous field in Datasheet View or Form View.
Shift+Tab
Go to record numberMoves the focus to the record number box of a datasheet, subdatasheet or form; type a number and press Enter.
Alt+F5
Open Find and ReplaceIn Datasheet View or Form View, brings up Find and Replace with the Find tab in front.
Ctrl+F
Show or hide property sheetToggles the property sheet in Design View and, for forms and reports, in Layout View.
F4
Switch to Form ViewTakes a form that is open in Design View into Form View.
F5
Open Print dialog boxBrings up the Print dialog box for the current or selected datasheet, form or report.
Ctrl+P
Open Page SetupFrom Print Preview, opens the Page Setup dialog box for a form or report.
S
Show KeyTipsSelects the active ribbon tab and shows the KeyTip letters; a KeyTip or an arrow key then reaches another tab.
AltorF10
Go to Home tabJumps to the Home tab of the ribbon from wherever you are in Access.
Alt+H
Go to Tell me boxPuts the cursor in the ribbon's Tell me box; then type what you are looking for.
Alt+Q
Open shortcut menuOpens the right-click menu of whatever is selected, such as a file, folder or gallery item; Menu is the Windows Menu key.
Shift+F10orMenu
Open HelpShows the Access Help window, where articles can be searched by keyword.
F1
Exit AccessQuits Access; Ctrl + W closes only the active database window.
Alt+F4
Open and save databases 8
Action
Windows
New databaseStarts a new database; it does not add a record or a new object.
Ctrl+N
Save database objectSaves the table, query, form or other object you are working on.
Ctrl+S
Open Save AsOpens the Save As dialog box; the second form goes through the File menu, Alt + F and then S.
F12orAlt+FthenS
Leave the File menuCloses the File menu and takes you back to the open database.
Esc
Open selected folder or fileWhile browsing for a database, opens the folder or file that is selected.
Enter
Go up one folderWhile browsing for a database, goes up to the parent of the selected folder.
Backspace
Delete selected folder or fileWhile browsing for a database, deletes the folder or file that is selected.
Delete
Open Look in listDrops down the Look in list of the dialog box used to open or save a database.
F4orAlt+I
Move in the Access workspace 9
Action
Windows
Next database windowSwitches to the next open database window.
Ctrl+F6
Previous database windowSwitches back to the previous open database window.
Ctrl+Shift+F6
Close database windowShuts only the object window in front, such as a table or form, and leaves the database open.
Ctrl+W
Restore minimized windowApplies when every window in the workspace is reduced to an icon and one of the icons is selected.
Enter
Move to previous paneMoves the focus through the panes of the workspace in the opposite direction to F6.
Shift+F6
Reach a task paneFallback when F6 misses a task pane: Alt puts the focus on the ribbon, then Ctrl + Tab reaches the pane.
AltthenCtrl+Tab
Search the Navigation PaneWith the focus already on the Navigation Pane, jumps to its Search box.
Ctrl+F
Switch to Visual Basic EditorWorks both ways: opens the Visual Basic Editor, then, pressed there, returns to the window you left.
Alt+F11
Show Immediate windowOpens the Visual Basic Editor's Immediate window.
Ctrl+G
Navigate and open objects 8
Action
Windows
Open selected objectWhat happens depends on the object: a table or query opens in Datasheet View, a form or report opens, a macro runs.
Enter
Open object in Design ViewInstead of opening or running the object, shows its design; it works for tables, queries, forms, reports, macros and modules.
Ctrl+Enter
Rename selected objectRenames the selected object, which is possible only while that object is closed.
F2
Down one objectMoves down one line in the list of objects.
Down
Up one objectMoves up one line in the list of objects.
Up
Page down object listScrolls the list of objects down by one window.
Page Down
Page up object listScrolls the list of objects up by one window.
Page Up
Last object in listReaches the end of the Objects list in one press, however many objects lie in between.
End
Common shortcuts for the Design, Layout, and Datasheet views 10
Action
Windows
Switch to next viewMoves an open table, query, form or report forward to its next available view; press again for the one after.
Ctrl+Right
Switch to previous viewMoves an open table, query, form or report back to its previous view; Microsoft notes it does not work with every object.
Ctrl+Left
Leave Navigation modeIn a form or report, drops out of Navigation mode so that the field can be edited again.
Esc
Switch between window halvesIn the Design View of a query or macro, or in the Advanced Filter/Sort window, moves between the upper and lower parts.
F6
Show or hide Field ListToggles the Field List pane for a form or report in Design View or Layout View.
Alt+F8
Add field to form or reportAdds the field selected in the Field List pane to the detail section of the form or report.
Enter
Move through Field ListMoves the selection up or down inside the Field List pane.
UporDown
Switch Field List panesJumps from the upper pane of the Field List to the lower one and back.
Tab
Return from code to designRequires an open code module; focus leaves the Visual Basic Editor and lands on its form or report in Design View.
Shift+F7
Return to design surfaceFrom a control's property sheet, returns to the design surface of the form or report without changing which control has focus.
Shift+F7
Work in the Datasheet View 17
These keys move between fields and records only in Navigation mode. When the insertion point is showing, the field is in Edit mode: press F2 to switch.
Action
Windows
Field to the rightIn Navigation mode, moves to the next field, the same as Tab.
Right
Field to the leftIn Navigation mode, moves to the previous field, the same as Shift + Tab.
Left
Last field in recordWorks in Navigation mode; in Edit mode the same key sends the insertion point to the end of the field or line.
End
First field in recordApplies in Navigation mode; with the insertion point showing, the key goes to the start of the field or line.
Home
Same field, next recordGoes one row down in the datasheet while staying in the same column.
Down
Same field, previous recordStays in the same column and moves one record up; it applies in Navigation mode.
Up
Same field, last recordStays in the same field and jumps to the last record.
Ctrl+Down
Same field, first recordStays in the same field and jumps to the first record.
Ctrl+Up
Last field of last recordJumps to the very end of the datasheet: the last field of the last record.
Ctrl+End
First field of first recordJumps to the very start of the datasheet: the first field of the first record.
Ctrl+Home
Down one screenScrolls the datasheet down by one screen.
Page Down
Up one screenScrolls the datasheet up by one screen.
Page Up
Right one screenScrolls the datasheet one screen to the right.
Ctrl+Page Down
Left one screenScrolls the datasheet one screen to the left.
Ctrl+Page Up
Select current columnIn Navigation mode, selects the current column; pressed again, it cancels the column selection.
Ctrl+Space
Extend column selection rightNeeds the current column to be selected first; each press then takes in one more column on that side.
Shift+Right
Extend column selection leftWorks once a whole column is selected, as Select current column does; adds the adjacent column on the left.
Shift+Left
Work with subdatasheets 9
Inside a subdatasheet, fields and records are navigated with the same keys as in Datasheet View.
Action
Windows
Open record's subdatasheetMoves from the datasheet into the subdatasheet of the current record.
Ctrl+Shift+Down
Collapse subdatasheetHides the related records nested under the current row and leaves the row itself in view.
Ctrl+Shift+Up
Enter subdatasheet going forwardMoves into the subdatasheet when pressed in the last field of the record just before it.
Tab
Enter subdatasheet going backMoves into the subdatasheet when pressed in the first field of the record just after it.
Shift+Tab
Exit from last subdatasheet fieldPressed in the final field of a subdatasheet, moves on into the main datasheet and its following field.
Tab
Leave subdatasheet forwardLeaves the subdatasheet for the first field of the following record in the main datasheet.
Ctrl+Tab
Leave subdatasheet backwardLeaves the subdatasheet for the last field of the preceding record in the main datasheet.
Ctrl+Shift+Tab
Skip subdatasheet, next recordFrom the datasheet, passes over the subdatasheet and goes to the next record.
Down
Skip subdatasheet, previous recordFrom the datasheet, passes over the subdatasheet and goes to the previous record.
Up
Navigate in the Form View 12
Action
Windows
Last control, same recordGoes to the form's last control and stays in the current record.
End
First control, same recordGoes to the form's first control and stays in the current record.
Home
Last control of last recordGoes to the last record and puts the focus on the form's last control.
Ctrl+End
First control of first recordGoes to the first record and puts the focus on the form's first control.
Ctrl+Home
Next record in formMoves to the next record and stays in the same field.
Ctrl+Page Down
Previous record in formMoves to the previous record and stays in the same field.
Ctrl+Page Up
Next page of formOn a multipage form, goes down one page; past the record's last page, to the matching page of the next record.
Page Down
Previous page of formOn a multipage form, goes up one page, or to the matching page of the previous record.
Page Up
Enter subform going forwardMoves into the subform from the field that comes before it on the main form.
Tab
Enter subform going backMoves into the subform from the field that follows it on the main form.
Shift+Tab
Leave subform forwardExits the subform for the next field on the main form, or for the next record.
Ctrl+Tab
Leave subform backwardExits the subform for the previous field on the main form, or for the previous record.
Ctrl+Shift+Tab
Enter data in the Datasheet View or Form View 12
Action
Windows
Insert current dateTypes today's date into the field.
Ctrl+;
Insert current timeTypes the current time into the field.
Ctrl+Shift+:
Repeat value from previous recordCopies in the value that the same field holds in the previous record.
Ctrl+'
Insert default valueFills the field with its default value.
Ctrl+Alt+Space
Add new recordMoves the cursor to the blank row at the end of the datasheet, or to an empty form, ready for entry.
Ctrl++
Delete current recordIn Datasheet view, removes the entire row that holds the cursor, not just the contents of one field.
Ctrl+-
Save current recordWrites the edits in the current record to the database straight away.
Shift+Enter
Toggle checkbox or option buttonTicks or clears a checkbox, or changes which option button is chosen.
Space
New line in text fieldBreaks the line inside a Long Text or Short Text field; Enter alone moves on to the next field by default.
Ctrl+Enter
Undo typingTakes back what you have just typed.
Ctrl+ZorAlt+Backspace
Undo field or record changesUndoes the changes to the current field; if the record has changed too, a second press undoes the record.
Esc
Requery underlying tablesFetches current data from the underlying tables; in a subform, only the subform's table is requeried.
Shift+F9orF5
Select text or data 15
Action
Windows
Toggle record selectionIn Navigation mode, switches between selecting the whole current record and only its first field.
Shift+Space
Add previous record to selectionWith the current record selected, extends the selection to the record above; the opposite arrow key takes it back.
Shift+Up
Select all recordsCovers every record in the datasheet or form that is open, not only the ones visible on screen.
Ctrl+A
Turn on Extend modeStarts Extend mode; pressing it again grows the selection in steps: word, field, record, all records.
F8
Extend to adjacent fieldsIn Extend mode in Datasheet View, stretches the selection to neighbouring fields in the same row.
LeftorRight
Extend to adjacent rowsIn Extend mode in Datasheet View, stretches the selection to the rows above or below.
UporDown
Undo last extensionSteps the extended selection back by one stage.
Shift+F8
Cancel Extend modeEnds the mode started with Turn on Extend mode, so the arrow keys stop growing the selection.
Esc
Extend text selection rightTakes in the next character on the right, or gives one back if the selection was made leftward.
Shift+Right
Extend text selection leftTakes in the next character on the left, or gives one back if the selection was made rightward.
Shift+Left
Extend selection one word rightWorks a whole word at a time: the selection gains or loses the word on its right.
Ctrl+Shift+Right
Extend selection one word leftSame step size, other direction: the selection gains or loses the word on its left.
Ctrl+Shift+Left
Select to start of entryIn a text box, selects from the insertion point back to the beginning of the entry.
Shift+Home
Select to end of entryIn a text box, selects from the insertion point forward to the end of the entry.
Shift+End
Find next matchRepeats the last search without reopening Find and Replace; it works in Form View and Datasheet View only.
Shift+F4
Move the insertion point in a field 8
Action
Windows
One character rightSteps the insertion point forward by a single character.
Right
One character leftSteps the insertion point back by a single character.
Left
One word rightJumps the insertion point forward by one word.
Ctrl+Right
One word leftJumps the insertion point back by one word.
Ctrl+Left
End of field or lineGoes to the end of a single-line field, or to the end of the current line in a multiline field.
End
Start of field or lineGoes to the beginning of a single-line field, or to the start of the current line in a multiline field.
Home
End of multiline fieldIn a field with several lines, goes to the very end of the field.
Ctrl+End
Start of multiline fieldIn a field with several lines, goes to the very beginning of the field.
Ctrl+Home
Copy, move, or delete text 6
Action
Windows
Copy selectionPuts a copy of the selected text on the clipboard.
Ctrl+C
Cut selectionRemoves the selected text and keeps it on the clipboard.
Ctrl+X
Paste clipboardInserts the clipboard's contents where the insertion point is, replacing any text that is selected.
Ctrl+V
Delete to the leftDeletes the selection, or the character before the insertion point.
Backspace
Delete to the rightDeletes the selection, or the character after the insertion point.
Delete
Delete rest of textClears every character that follows the insertion point.
Ctrl+Delete
Edit using controls in the form and report in the Design View 15
Action
Windows
Copy selected controlPuts a copy of the selected control on the clipboard.
Ctrl+C
Cut selected controlRemoves the selected control and keeps it on the clipboard.
Ctrl+X
Paste into selected sectionDrops the clipboard contents into the selected section, at its top-left corner.
Ctrl+V
Move control rightShifts the selected control one pixel to the right along the page's grid; not for a control inside a layout.
Right
Move control leftShifts the selected control one pixel to the left along the page's grid; not for a control inside a layout.
Left
Move control upShifts the selected control up one pixel on the grid; in a stacked layout it swaps places with the control above.
Up
Move control downShifts the selected control down one pixel on the grid; in a stacked layout it swaps places with the control below.
Down
Nudge control right off-gridMoves the selected control one pixel to the right, ignoring the page's grid.
Ctrl+Right
Nudge control left off-gridMoves the selected control one pixel to the left, ignoring the page's grid.
Ctrl+Left
Nudge control up off-gridMoves the selected control up one pixel, ignoring the grid; in a stacked layout it swaps with the control above.
Ctrl+Up
Nudge control down off-gridMoves the selected control down one pixel, ignoring the grid; in a stacked layout it swaps with the control below.
Ctrl+Down
Widen controlMakes the selected control one pixel wider on the right; in a stacked layout the whole layout widens.
Shift+Right
Narrow controlMakes the selected control one pixel narrower; in a stacked layout the whole layout narrows.
Shift+Left
Increase control heightMakes the selected control taller from the bottom edge; for a control in a layout, the whole row is resized.
Shift+Down
Reduce control heightMakes the selected control shorter from the bottom edge; for a control in a layout, the whole row is resized.
Shift+Up
Use property sheets 9
Action
Windows
Open or close property sheetDoes the same as F4: shows or hides the property sheet in Design View or Layout View.
Alt+Enter
Step through control listMoves one item at a time through the property sheet's dropdown list of controls.
DownorUp
Page through control listMoves a page at a time through the property sheet's dropdown list of controls.
Page DownorPage Up
Go to property sheet tabsFrom the dropdown list of controls, moves the focus on to the property sheet tabs.
Tab
Move between property tabsWith a tab selected and no property selected, moves across the property sheet tabs.
LeftorRight
Next propertyWith a property selected, moves down to the next property on the tab.
Tab
Previous propertyMoves up one property; from the top property it moves to the tab itself.
Shift+Tab
Next property sheet tabWith a property selected, switches forward to the next tab of the property sheet.
Ctrl+Tab
Previous property sheet tabWith a property selected, switches back to the previous tab of the property sheet.
Ctrl+Shift+Tab
Use the diagram, grid, and SQL panes 17
The SQL pane takes the standard Windows editing keys, such as Ctrl with an arrow key to move by word, and it only inserts text: there is no overtype mode.
Action
Windows
Move between diagram objectsIn the diagram pane, moves among the tables, views and functions, and the join lines where there are any.
TaborShift+Tab
Move between columnsIn the diagram pane, moves from column to column inside a table, view or function.
Arrow keys
Add column to outputIn the diagram pane, chooses the selected data column for the query output.
Spaceor+
Remove column from outputIn the diagram pane, takes the selected data column out of the query output.
Spaceor-
Remove table or join lineIn the diagram pane, takes the selected table, view, function or join line out of the query.
Delete
Move between grid cellsWorks in the grid pane, stepping across its rows and columns one box at a time.
Arrow keysorTaborShift+Tab
Last row of grid columnIn the grid pane, jumps to the last row of the current column.
Ctrl+Down
First row of grid columnIn the grid pane, jumps to the first row of the current column.
Ctrl+Up
Top-left grid cellIn the grid pane, jumps to the upper-left cell of the part of the grid that is visible.
Ctrl+Home
Bottom-right grid cellIn the grid pane, jumps to the lower-right cell.
Ctrl+End
Move in grid dropdown listMoves through the entries of a dropdown list in the grid pane.
UporDown
Select grid columnSelects an entire column of the grid pane.
Ctrl+Space
Switch Edit and cell selectionIn the grid pane, goes from selecting whole cells to editing inside one, and back.
F2
Toggle insert and overtypeWhile editing in a grid cell, switches between insert mode and overtype mode.
Insert
Toggle Output checkboxIn the grid pane, ticks or clears the Output box; when several items are selected, the change applies to all of them.
Space
Clear cell or grid columnEmpties the selected part of a cell; with a whole grid column selected, clears all of its values.
Delete
Select all SQL textIn SQL view, selects all the text; where a version does not support it, Microsoft says to press F2 instead.
Ctrl+A
Navigate in the Print Preview and Layout Preview 15
Action
Windows
Print from the previewIn Print Preview, the letter alone opens the Print dialog box, as Ctrl + P also does.
P
Close the previewCancels the preview, whether Print Preview or Layout Preview.
Esc
Scroll down slightlyScrolls the previewed page down in small steps.
Down
Scroll up slightlyScrolls the previewed page up in small steps.
Up
Scroll right slightlyScrolls the previewed page to the right in small steps.
Right
Scroll left slightlyScrolls the previewed page to the left in small steps.
Left
Scroll down one screenScrolls the preview down by a full screen.
Page Down
Scroll up one screenScrolls the preview up by a full screen.
Page Up
Bottom of pageJumps to the bottom of the previewed page.
Ctrl+Down
Top of pageJumps to the top of the previewed page.
Ctrl+Up
Right edge of pageBrings the page's right-hand side into view; the Ctrl variant goes to the lower-right corner instead.
End
Left edge of pageBrings the page's left-hand side into view; the Ctrl variant goes to the upper-left corner instead.
Home
Lower-right corner of pageJumps to the bottom-right corner of the previewed page.
Ctrl+End
Upper-left corner of pageJumps to the top-left corner of the previewed page.
Ctrl+Home
Go to page numberMoves the focus to the page number box; type a page number and press Enter.
Alt+F5
Navigate the ribbon with only the keyboard 12
A plus sign means the keys are held together and a comma that they are pressed one after another: for Alt + Y, 1, press Alt + Y, let go, then press 1.
Action
Windows
Go to File menuOpens the File menu, where Options and the Save As command are found.
Alt+F
Go to Create tabOpens the Create tab of the ribbon.
Alt+C
Go to External Data tabOpens the External Data tab of the ribbon.
Alt+X
Go to Database Tools tabOpens the Database Tools tab: press Alt + Y together, then 1.
Alt+Ythen1
Go to Table tabOpens the Table tab: press Alt + J together, then T.
Alt+JthenT
Go to Add-ins tabOpens the Add-ins tab, if one is present: press Alt + X together, then 2.
Alt+Xthen2
Move between ribbon tabsOnce Alt has put the focus on the ribbon, moves from one tab to the next.
LeftorRight
Move into ribbon groupTakes the focus into the ribbon group that is currently selected.
Down
Move between ribbon groupsJumps from one group of commands on the ribbon to the next or the previous one.
Ctrl+RightorCtrl+Left
Move between group commandsSteps forward or back through the commands inside a ribbon group.
TaborShift+Tab
Open split button menuOpens the menu of a split button on the ribbon; Tab then moves through its options.
Alt+Down
Open ribbon listOpens a list control such as the Font list; Up and Down then move between its items.
Down
Use menus 11
Action
Windows
Open control menuOpens the control menu, the one behind the program icon on the title bar.
Alt+Space
Move between menu commandsWith a menu or submenu open, selects the next or the previous command.
DownorUp
Move between menusGoes to the neighbouring menu on either side, or hops between a menu and its open submenu.
LeftorRight
First menu commandJumps to the top command of the open menu or submenu.
Home
Last menu commandJumps to the bottom command of the open menu or submenu.
End
Open menu or press buttonOpens the selected menu, or carries out the action of the selected button.
SpaceorEnter
Scroll gallery listWorks once a gallery control is selected, bringing items further up or down the gallery into view.
Page UporPage Down
Top of gallery listGoes straight to the first entry of the gallery list that is selected, instead of scrolling there.
Ctrl+Home
Bottom of gallery listLands on the last entry of the gallery list you have selected, without scrolling through it.
Ctrl+End
Close menu and submenuCloses the open menu and its submenu in one go.
Alt
Close menu or submenuCloses the open menu; when a submenu is showing, closes only the submenu.
Esc
Use dialog boxes and wizards 14
Action
Windows
Next option or groupMoves forward through the options and option groups of a dialog box, or the controls of a wizard.
Tab
Previous option or groupMoves back through the options and option groups of a dialog box.
Shift+Tab
Next dialog box tabBrings the following tab of a dialog box to the front.
Ctrl+Tab
Previous dialog box tabBrings the preceding tab of a dialog box to the front.
Ctrl+Shift+Tab
Move between optionsSteps through the choices of a dropdown list box that is selected, or through the options of an option group.
Arrow keys
Press button or toggle checkboxCarries out the selected button's action, or ticks or clears the selected checkbox.
Space
Select option by its letterPicks the option, or ticks or clears the checkbox, whose name has that letter underlined.
Alt+underlined letter
Jump to list optionIn a dropdown list, jumps to the option that starts with the letter typed, opening the list first if needed.
First letter of an option
Open dropdown listIn a dialog box, unfolds the selected list box so all of its options show, ready for the arrow keys.
Alt+Down
Close dropdown listCloses the dropdown list box that is open.
Esc
Run default buttonCarries out the action of the dialog box's default button.
Enter
Cancel dialog boxAbandons the command and dismisses the dialog box.
Esc
Switch wizard sectionsIn a wizard, moves the focus between its header, body and footer sections.
F6
Finish the wizardPresses the wizard's Finish button from the keyboard, ending the wizard with the choices made so far.
Alt+F
Use a combo or list box 7
Action
Windows
Open combo boxDrops down the list of a combo box.
F4orAlt+Down
Refresh list contentsReloads what a combo box or a Lookup field's list box shows.
F9
Down one lineMoves down one line in the list.
Down
Up one lineMoves up one line in the list.
Up
Down one pageMoves down the list by a page.
Page Down
Up one pageMoves up the list by a page.
Page Up
Leave combo or list boxCarries the focus on to the next control, which takes you out of the combo or list box.
Tab
Work and move around in tables 11
Action
Windows
Next table cellMoves one cell forward; in the last cell of the table the same key adds a new row instead.
Tab
Preceding table cellMoves back to the preceding cell of the table.
Shift+Tab
Next table rowTakes the cursor to the row below; where a cell holds several lines, the same key steps down one line.
Down
Preceding table rowReturns to the row above; in a cell holding several lines of text the key moves up a line at a time.
Up
Add row at table endPressed in the final cell of the table, creates an extra row below instead of moving on.
Tab
Insert tab in cellTypes a tab character inside a cell, where Tab alone would move to the next cell.
Ctrl+Tab
Start new paragraphBegins a new paragraph while typing in a table.
Enter
Up one line of textMoves up one line within a table or cell.
Up
Down one line of textMoves down one line within a table or cell.
Down
Up one paragraphMoves up one paragraph within a table or cell.
Ctrl+Up
Down one paragraphMoves down one paragraph within a table or cell.
Ctrl+Down
Get help with Access 6
Action
Windows
Next item in HelpSelects the next item, hidden text or hyperlink in the Help window.
Tab
Previous item in HelpSelects the previous item, hidden text or hyperlink in the Help window.
Shift+Tab
Activate selected Help itemIn the Help window, triggers whichever element is selected, whether an item, a hyperlink or hidden text.
Enter
Back to previous Help topicReturns to the Help topic you were reading before, like the Back button.
Alt+LeftorBackspace
Scroll Help topic slightlyScrolls the open Help topic up or down by small amounts.
UporDown
Scroll Help topic furtherScrolls the open Help topic up or down by larger amounts.
Page UporPage Down
Miscellaneous keyboard shortcuts 5
Action
Windows
Open Zoom boxOpens the Zoom box, a larger window for entering expressions and other text that does not fit a small input area.
Shift+F2
Show full hyperlink addressDisplays the complete address (URL) of the selected hyperlink.
F2
Show full task pane menuExpands the task pane menu so that every command is listed.
Ctrl+Down
Copy screen to clipboardPuts a screenshot of the whole screen on the clipboard.
Print Screen
Copy window to clipboardCaptures only the active window as an image, where Print Screen alone takes the whole screen.
Alt+Print Screen
No row on this page matches that filter.
Notes
Records
Ctrl + + adds a new record and Ctrl + - deletes the current one, after confirmation. Ctrl + ' copies the value from the same field in the previous record, which is the fastest way to enter a run of identical values. Ctrl + ; and Ctrl + Shift + : insert the current date and time. Ctrl + F finds, the Replace tab of the same dialog replaces within the current field or the whole datasheet, and F4 / Alt + Down opens a combo box's dropdown so a lookup value can be picked with the arrow keys.
Editing and views
F2 toggles between navigating fields and editing inside one — the same convention as Excel — and Shift + F2 opens the Zoom box, a larger editor for memo fields and long expressions in the query designer. F5 takes a form from Design View to Form View, and Ctrl + Right and Ctrl + Left step an open table, query, form or report through its views; Ctrl + F6 cycles open windows and F11 shows or hides the Navigation Pane. Ctrl + S saves the object's design; data is saved as you leave each record.
Habits
Ctrl + N creates a new database rather than a new record, which surprises Excel users. In a form, Tab moves between fields and Ctrl + Page Down moves to the next record; on a subform, Ctrl + Tab leaves it. Access saves data automatically, so undo is short-lived: Ctrl + Z / Alt + Backspace takes back typing, and Esc reverts the current field, then the whole record on a second press.
Every row on this page was matched to a line in the documentation above on . A binding that could not be found there is not listed.
68 rows from the earlier version of this page were removed in that check: duplicates, and bindings the documentation does not list or lists differently.
Found a wrong or missing key? Tell us and it gets checked against the source. How we verify describes the process and its limits.