Manage Databases

Sr.NoShortcut KeyDescription
01Ctrl+NOpen/create new database
02Ctrl+OOpen existing database
03Alt+F4Quit/ exit Access
04Ctrl+PPrint the current or selected object
05Ctrl+SSave a database object (or Shift+f12)
06F12Open the Save As dialog box

 Find and Replace

Sr.NoShortcut KeyDescription
01Ctrl+FFind and replace dialog box
02Ctrl+H(Find and) Replace dialog box
03Shift+F4Find next
04Alt+Ctrl+FGo to the Navigation Pane search box from anywhere in the database

 Form Controls

Sr.NoShortcut KeyDescription
01Ctrl+X/Ctrl+C/Ctrl+VCut / Copy / Paste
02Arrow KeysMove selected control up/down/left/right (Optionally, add Ctrl to key combination)
03Shift+ArrowIncrease / decrease height of the selected control
04Down/Shift+Arrow UpIncrease / decrease width of the selected control

 Wizards

Sr.NoShortcut KeyDescription
01TabToggle the focus forward between controls in the wizard
02Alt+NMove to the next page of the wizard
03Alt+BMove to the previous page of the wizard
04Alt+FComplete the wizard

 Menus

Sr.NoShortcut KeyDescription
01Shift+F10Show the shortcut menu
02AltShow the access keys (of F10)
03Alt+SpaceShow the program icon menu
04Arrow Down/Arrow UpSelect the next / select previous command in menu
05Arrow Left/Arrow RightSelect the menu to the left / menu to the right
06Home/EndSelect first / select last command in menu
07EscClose the visible menu; or, with a submenu visible, to close the submenu

 Dialog Boxes

Sr.NoShortcut KeyDescription
01Ctrl+Tab/Ctrl+Shift+TabSwitch to next tab / switch to previous tab in a dialog
02Tab/Shift+TabMove to the next / switch to previous option or option group
03Arrow KeysMove between options
04SpaceSelect current button
05Alt+Arrow DownOpen the selected drop-down list box
06EscClose the selected drop-down list box
07EnterPerform the action assigned to the default button in the dialog box
08Alt+F4Close a dialog box

 Text Boxes

Sr.NoShortcut KeyDescription
01Home/EndMove beginning / move to end of an entry
02Ctrl+Arrow Left/Ctrl+Arrow RightMove one word to the left or right
03Shift+Home/Shift+EndSelect from cursor to end / to beginning
04Shift+Arrow Left/Shift+Arrow RightExtend selection one character to the left / to the right

 Field List Pane

Sr.NoShortcut KeyDescription
01Alt+F8Toggle the Field List pane
02EnterAdd the selected field to the form or report detail section
03Arrow Up/Arrow DownMove up / move down the Field List pane
04Shift+TabMove to the upper Field List pane from the lower pane
05TabMove to the lower Field List pane from the upper pane

 Select and move Fields or Columns

Sr.NoShortcut KeyDescription
01Tab/Shift+TabSelect next field / select previous field
02F2Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet or design view
03Shift+SpaceSwitch between selecting the current record and the first field of the current record,
04Shift+Arrow Up/Shift+Arrow DownExtend selection to previous record/ to next record
05Ctrl+ASelect all records (or Ctrl+Shift+Space)
06F8Turn on Extend mode
07Arrow Left/Arrow RightExtend a selection to adjacent fields in the same row in Datasheet view
08Arrow Up/Arrow DownExtend a selection to adjacent rows in Datasheet view
09Shift+F8Undo the previous extension
10EscCancel Extend mode
11Ctrl+SpaceSelect the current column
12Shift+Arrow Right/Shift+Arrow LeftSelect the column to the right / to the left, if the current column is selected
13Ctrl+Shift+F8Turn on Move mode

 Edit Text and Data

Sr.NoShortcut KeyDescription
01Arrow Right/Arrow LeftMove cursor one character to the right / to the left
02Ctrl+Arrow Right/Ctrl+Arrow LeftMove cursor one word to the right / to the left
03Home/EndMove cursor to the beginning / to the end of the field
04Ctrl+Home/Ctrl+EndMove cursor to the beginning / to the end of the line in multi-line fields
05Ctrl+DeleteDelete all characters to the right of the insertion point
06Ctrl+ZUndo Changes
07Ctrl+YRedo Changes
08EscCancel / undo changes in the current field or current record

 Insert Data

Sr.NoShortcut KeyDescription
01Ctrl+;Insert the current date
02Ctrl+:Insert the current time
03Ctrl+Alt+SpaceInsert the default value for a field
04Ctrl+’Insert the value from the same field in the previous record
05Ctrl+[+]Add a new record
06Ctrl+-In a datasheet, delete the current record
07Shift+EnterSave changes to the current record
08SpaceSwitch between the values in a check box or option button
09Ctrl+EnterInsert a new line

 Refresh Fields

Sr.NoShortcut KeyDescription
01F9Recalculate the fields in the window or the contents of a Lookup field
02Shift+F9Requery the underlying tables

 Design View

Sr.NoShortcut KeyDescription
01F2Switch between Edit and Navigation mode
02F4Toggle the property sheet
03F5Switch to Form view from form Design view
04F6Switch between the windows, or between design panes / properties / etc
05F7Open the Visual Basic Editor from a selected property in the property sheet for a form or report
06Alt+F8Invokes the Field List pane in a form, report, or data access page. If the Field List pane is already open, focus moves to the Field List pane.
07Shift+F7Switch to Form or Report Design View (from Visual Basic Editor with code module open)
08Alt+EnterDisplay a property sheet
09Ctrl+X/Ctrl+C/Ctrl+VCut / Copy / Paste
10Arrow KeysMove selected control up/down/left/right along the grid
11Ctrl+Arrow KeysMove selected control up/down/left/right by one pixel
12Shift+Arrow Down/Shift+Arrow UpIncrease / decrease height of the selected control
13Shift+Arrow Right/Shift+Arrow LeftIncrease / decrease width of the selected control

 Navigate in Datasheet, Subdatasheet, and Form View

Sr.NoShortcut KeyDescription
01F5Move to the record number box, type in number and press enter
02Tab/Shift+TabMove to next / move to previous field in current record
03Home/EndMove to first / move to last field in current record
04Arrow Down/Arrow UpMove to next / move to previous record
05Ctrl+Arrow Down/Ctrl+Arrow UpMove to last record / move to first record (or current field in next record / in previous record when in subdatasheet)
06Ctrl+Home/Ctrl+EndMove to first field in first record / last field in last record
07Page Down/Page UpMove down one screen / move up one screen
08Ctrl+Page Down/Ctrl+Page UpMove right one screen / left one screen
09Ctrl+Tab/Ctrl+Shift+TabIn subdatasheet: Exit to next / to previous record
10Ctrl+Shift+Arrow DownExpand subdatasheet
11Ctrl+Shift+Arrow UpCollapse subdatasheet
12Alt+F5Move from subdatasheet to record number box, enter record number and press enter

 Database Diagram

Sr.NoShortcut KeyDescription
01EscMove from a table cell to the table’s title bar
02EnterMove from a table’s title bar to the last cell you edited
03TabMove from table title bar to table title bar, or from cell to cell inside a table
04Alt+Arrow DownExpand a list inside a table
05Arrow Down/Arrow UpMove up / down in a list
06SpaceChange the setting in a check box
07Home/EndGo to the first cell / go to last cell in row
08Page Down/Page UpGo to next / go to previous page of the diagram

 Query Designer

Sr.NoShortcut KeyDescription
01F6/Shift+F6Move forward / backwards among the Query Designer panes
02Tab/Shift+TabMove forward / backwards among tables, views, functions, or join line.
03Arrow KeysMove between columns in a table, view, or function
04SpaceChoose the selected data column for output (or use +/-)
05DeleteRemove the selected table, view, function, or join line
06F2In Grid Pane: toggle between edit mode and cell selection mode
07InsertInsert row between existing columns

 Pivot Table

Sr.NoShortcut KeyDescription
01Tab/Shift+TabMove to the right / to the left
02Enter/Shift+EnterMove down / move up
03Shift+EnterSelect cell above current cell
04Ctrl+Enter/Ctrl+Shift+EnterSelect detail cell for next item / previous item in row
05Shift+Arrow KeysExpand selection
06Ctrl+ASelect entire PivotTable View
07Shift+F10Display context menu
08Alt+EnterDisplay property dialog box
09Alt+F4Close property dialog box
10EscCancel refresh operation in progress
11Ctrl+EExport contents to Excel
12Ctrl+8Toggle expand indicators (plus and minus signs)
13Ctrl+[+ on numeric keyboardExpand selected item
14Ctrl+- on numeric keyboardCollapse current item
15Alt+Arrow DownOpen list for currently selected item
16Ctrl+TToggle AutoFilter
17Ctrl+Shift+ASort data ascending (A-Z)
18Ctrl+Shift+ZSort data descending (Z-A)
19Alt+Shift+Arrow Up/Alt+Shift+Arrow UpMove selected member up / down
20Alt+Shift+Arrow Right/Alt+Shift+Arrow LeftMove selected member right / left
21Ctrl+LDisplay Field List pane
22Ctrl+Shift+SAdd new total field using sum summary
23Ctrl+Shift+CAdd new total field using count summary
24Ctrl+Shift+MAdd new total field using min summary
25Ctrl+Shift+XAdd new total field using max summary
26Ctrl+Shift+EAdd new total field using average summary
27Ctrl+Shift+DAdd new total field using standard deviation summary
28Ctrl+Shift+TAdd new total field using standard deviation population summary
29Ctrl+Shift+BTurn subtotals and grand totals on or off for selected field
30Ctrl+FAdd a calculated detail field
31Ctrl+1Move selected field to row area
32Ctrl+2Move selected field to column area
33Ctrl+3Move selected field to filter area
34Ctrl+4Move selected field to detail area
35Ctrl+Arrow Left/Ctrl+Arrow RightMove selection up one level / down one level
36Ctrl+Shift+~Apply the general number format to values
37Ctrl+Shift+$Apply the currency format to values
38Ctrl+Shift+%Apply the percentage format to values
39Ctrl+Shift+^Apply the exponential number format to values
40Ctrl+Shift+#Apply the date format to values
41Ctrl+Shift+@Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field
42Ctrl+Shift+!Apply the numeric format, with two decimal places, thousands separator, and a minus sign for negative values, to values in the selected total or detail field
43Ctrl+BMake text bold in the selected field of the PivotTable view
44Ctrl+UMake text underlined in the selected field of the PivotTable view
45Ctrl+IMake text italic in the selected field of the PivotTable view

 Manage Windows

Sr.NoShortcut KeyDescription
01F11Toggle the Navigation Pane
02Ctrl+F6Cycle between open windows
03EnterRestore the selected minimized window when all windows are minimized
04Ctrl+F8Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window
05Alt+SpaceDisplay the control menu
06Shift+F10Display the shortcut menu
07Ctrl+W/Ctrl+F4Close the active window
08Alt+F11Switch between the Visual Basic Editor and the previous active window

 Help Window

Sr.NoShortcut KeyDescription
01Tab/Shift+TabGo to next / go to previous text or hyperlink
02EnterPerform action for currently selected item
03Alt+Arrow Left/Alt+Arrow RightMove back / move forward
04Ctrl+POpen the Print dialog box
05Arrow Up/Arrow DownMove up / move down in small increments
06Page Up/Page DownMove up / move down one one page
07Shift+F10Show context menu

 Other Shortcuts

Sr.NoShortcut KeyDescription
01F2Display hyperlink
02F7Check spelling
03Shift+F2Open the Zoom box
04Alt+EnterDisplay a property sheet in Design view
05Ctrl+F2Invoke a Builder
06Ctrl+Arrow Right/Ctrl+Arrow LeftToggle forward / toggle backwards between views when in a table, or other elements