Access 2010 (Windows)

The Rest - Wizards

Move to the next page of the wizard

Alt + N

All hotkeys for Access 2010 (Windows)

Manage Access Features - Find and Replace
Find and replace dialog box

Ctrl + F

Manage Access Features - Find and Replace
(Find and) Replace dialog box

Ctrl + H

Manage Access Features - Find and Replace
Find next

Shift + F4

Manage Access Features - Find and Replace
Go to the Navigation Pane search box from anywhere in the database

Alt + Ctrl + F

Manage Access Features - Form Controls
Cut / Copy / Paste

Ctrl + X / Ctrl + C / Ctrl + V

Manage Access Features - Form Controls
Move selected control up/down/left/right (Optionally, add Ctrl to key combination)

Arrow Keys

Manage Access Features - Form Controls
Increase / decrease height of the selected control

Shift + Arrow Down / Shift + Arrow Up

Manage Access Features - Form Controls
Increase / decrease width of the selected control

Shift + Arrow Right / Shift + Arrow Left

Manage Access Features - Wizards
Toggle the focus forward between controls in the wizard

Tab

Manage Access Features - Wizards
Move to the next page of the wizard

Alt + N

Manage Access Features - Wizards
Move to the previous page of the wizard

Alt + B

Manage Access Features - Wizards
Complete the wizard

Alt + F

Manage Access Features - Menus
Show the shortcut menu

Shift + F10

Manage Access Features - Menus
Show the access keys (of F10)

Alt

Manage Access Features - Menus
Show the program icon menu

Alt + Space

Manage Access Features - Menus
Select the next / select previous command in menu

Arrow Down / Arrow Up

Manage Access Features - Menus
Select the menu to the left / menu to the right

Arrow Left / Arrow Right

Manage Access Features - Menus
Select first / select last command in menu

Home / End

Manage Access Features - Menus
Close the visible menu and submenu at the same time

Alt

Manage Access Features - Menus
Close the visible menu; or, with a submenu visible, to close the submenu

Esc

Manage Access Features - Dialog Boxes
Switch to next tab / switch to previous tab in a dialog box

Ctrl + Tab / Ctrl + Shift + Tab

Manage Access Features - Dialog Boxes
Move to the next / switch to previous option or option group

Tab / Shift + Tab

Manage Access Features - Dialog Boxes
Move between options

Arrow Keys

Manage Access Features - Dialog Boxes
Select current button

Space

Manage Access Features - Dialog Boxes
Open the selected drop-down list box

Alt + Arrow Down

Manage Access Features - Dialog Boxes
Close the selected drop-down list box

Esc

Manage Access Features - Dialog Boxes
Perform the action assigned to the default button in the dialog box

Enter

Manage Access Features - Dialog Boxes
Cancel the command and close the dialog box

Esc

Manage Access Features - Dialog Boxes
Close a dialog box

Alt + F4

Manage Access Features - Text Boxes
Move beginning / move to end of an entry

Home / End

Manage Access Features - Text Boxes
Move one word to the left or right

Ctrl + Arrow Left / Ctrl + Arrow Right

Manage Access Features - Text Boxes
Select from cursor to end / to beginning

Shift + Home / Shift + End

Manage Access Features - Text Boxes
Extend selection one character to the left / to the right

Shift + Arrow Left / Shift + Arrow Right

Manage Access Features - Field List Pane
Toggle the Field List pane

Alt + F8

Manage Access Features - Field List Pane
Add the selected field to the form or report detail section

Enter

Manage Access Features - Field List Pane
Move up / move down the Field List pane

Arrow Up / Arrow Down

Manage Access Features - Field List Pane
Move to the upper Field List pane from the lower pane

Shift + Tab

Manage Access Features - Field List Pane
Move to the lower Field List pane from the upper pane

Tab

Manage Access Features - Select and move Fields or Columns
Select next field / select previous field

Tab / Shift + Tab

Manage Access Features - Select and move Fields or Columns

F2

Manage Access Features - Select and move Fields or Columns
Switch between selecting the current record and the first field of the current record,

Shift + Space

Manage Access Features - Select and move Fields or Columns
Extend selection to previous record/ to next record

Shift + Arrow Up / Shift + Arrow Down

Manage Access Features - Select and move Fields or Columns
Select all records (or Ctrl+Shift+Space)

Ctrl + A

Manage Access Features - Select and move Fields or Columns
Turn on Extend mode

F8

Manage Access Features - Select and move Fields or Columns
Extend a selection to adjacent fields in the same row in Datasheet view

Arrow Left / Arrow Right

Manage Access Features - Select and move Fields or Columns
Extend a selection to adjacent rows in Datasheet view

Arrow Up / Arrow Down

Manage Access Features - Select and move Fields or Columns
Undo the previous extension

Shift + F8

Manage Access Features - Select and move Fields or Columns
Cancel Extend mode

Esc

Manage Access Features - Select and move Fields or Columns
Select the current column

Ctrl + Space

Manage Access Features - Select and move Fields or Columns
Select the column to the right / to the left, if the current column is selected

Shift + Arrow Right / Shift + Arrow Left

Manage Access Features - Select and move Fields or Columns
Turn on Move mode

Ctrl + Shift + F8

Manage Access Features - Edit Text and Data
Move cursor one character to the right / to the left

Arrow Right / Arrow Left

Manage Access Features - Edit Text and Data
Move cursor one word to the right / to the left

Ctrl + Arrow Right / Ctrl + Arrow Left

Manage Access Features - Edit Text and Data
Move cursor to the beginning / to the end of the field

Home / End

Manage Access Features - Edit Text and Data
Move cursor to the beginning / to the end of the line in multi-line fields

Ctrl + Home / Ctrl + End

Manage Access Features - Edit Text and Data
Delete all characters to the right of the insertion point

Ctrl + Delete

Manage Access Features - Edit Text and Data
Undo Changes

Ctrl + Z

Manage Access Features - Edit Text and Data
Redo Changes

Ctrl + Y

Manage Access Features - Edit Text and Data
Cancel / undo changes in the current field or current record

Esc

Manage Access Features - Insert Data
Insert the current date

Ctrl + ;

Manage Access Features - Insert Data
Insert the current time

Ctrl + :

Manage Access Features - Insert Data
Insert the default value for a field

Ctrl + Alt + Space

Manage Access Features - Insert Data
Insert the value from the same field in the previous record

Ctrl + '

Manage Access Features - Insert Data
Add a new record

Ctrl + [ + ]

Manage Access Features - Insert Data
In a datasheet, delete the current record

Ctrl + -

Manage Access Features - Insert Data
Save changes to the current record

Shift + Enter

Manage Access Features - Insert Data
Switch between the values in a check box or option button

Space

Manage Access Features - Insert Data
Insert a new line

Ctrl + Enter

Manage Access Features - Refresh Fields
Recalculate the fields in the window or the contents of a Lookup field

F9

Manage Access Features - Refresh Fields
Requery the underlying tables

Shift + F9

Manage Access Features - Design View
Switch between Edit and Navigation mode

F2

Manage Access Features - Design View
Toggle the property sheet

F4

Manage Access Features - Design View
Switch to Form view from form Design view

F5

Manage Access Features - Design View
Switch between the windows, or between design panes / properties / etc

F6

Manage Access Features - Design View
Open the Visual Basic Editor from a selected property in the property sheet for a form or report

F7

Manage Access Features - Design View
Invokes 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.

Alt + F8

Manage Access Features - Design View
Switch to Form or Report Design View (from Visual Basic Editor with code module open)

Shift + F7

Manage Access Features - Design View
Display a property sheet

Alt + Enter

Manage Access Features - Design View
Cut / Copy / Paste

Ctrl + X / Ctrl + C / Ctrl + V

Manage Access Features - Design View
Move selected control up/down/left/right along the grid

Arrow Keys

Manage Access Features - Design View
Move selected control up/down/left/right by one pixel

Ctrl + Arrow Keys

Manage Access Features - Design View
Increase / decrease height of the selected control

Shift + Arrow Down / Shift + Arrow Up

Manage Access Features - Design View
Increase / decrease width of the selected control

Shift + Arrow Right / Shift + Arrow Left

Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View
Move to the record number box, type in number and press enter

F5

Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View
Move to next / move to previous field in current record

Tab / Shift + Tab

Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View
Move to first / move to last field in current record

Home / End

Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View
Move to next / move to previous record

Arrow Down / Arrow Up

Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View
Move to last record / move to first record (or current field in next record / in previous record when in subdatasheet)

Ctrl + Arrow Down / Ctrl + Arrow Up

Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View
Move to first field in first record / last field in last record

Ctrl + Home / Ctrl + End

Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View
Move down one screen / move up one screen

Page Down / Page Up

Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View
Move right one screen / left one screen

Ctrl + Page Down / Ctrl + Page Up

Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View
In subdatasheet: Exit to next / to previous record

Ctrl + Tab / Ctrl + Shift + Tab

Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View
Expand subdatasheet

Ctrl + Shift + Arrow Down

Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View
Collapse subdatasheet

Ctrl + Shift + Arrow Up

Manage Access Features - Navigate in Datasheet, Subdatasheet, and Form View
Move from subdatasheet to record number box, enter record number and press enter

Alt + F5

Manage Access Features - Database Diagram
Move from a table cell to the table's title bar

Esc

Manage Access Features - Database Diagram
Move from a table's title bar to the last cell you edited

Enter

Manage Access Features - Database Diagram
Move from table title bar to table title bar, or from cell to cell inside a table

Tab

Manage Access Features - Database Diagram
Expand a list inside a table

Alt + Arrow Down

Manage Access Features - Database Diagram
Move up / down in a list

Arrow Down / Arrow Up

Manage Access Features - Database Diagram
Change the setting in a check box

Space

Manage Access Features - Database Diagram
Go to the first cell / go to last cell in row

Home / End

Manage Access Features - Database Diagram
Go to next / go to previous page of the diagram

Page Down / Page Up

Manage Access Features - Query Designer
Move forward / backwards among the Query Designer panes

F6 / Shift + F6

Manage Access Features - Query Designer
Move forward / backwards among tables, views, functions, or join line.

Tab / Shift + Tab

Manage Access Features - Query Designer
Move between columns in a table, view, or function

Arrow Keys

Manage Access Features - Query Designer
Choose the selected data column for output (or use +/-)

Space

Manage Access Features - Query Designer
Remove the selected table, view, function, or join line

Delete

Manage Access Features - Query Designer
In Grid Pane: toggle between edit mode and cell selection mode

F2

Manage Access Features - Query Designer
Insert row between existing columns

Insert

Manage Access Features - Pivot Table
Move to the right / to the left

Tab / Shift + Tab

Manage Access Features - Pivot Table
Move down / move up

Enter / Shift + Enter

Manage Access Features - Pivot Table
Select cell above current cell

Shift + Enter

Manage Access Features - Pivot Table
Select detail cell for next item / previous item in row

Ctrl + Enter / Ctrl + Shift + Enter

Manage Access Features - Pivot Table
Expand selection

Shift + Arrow Keys

Manage Access Features - Pivot Table
Select entire PivotTable View

Ctrl + A

Manage Access Features - Pivot Table
Display context menu

Shift + F10

Manage Access Features - Pivot Table
Display property dialog box

Alt + Enter

Manage Access Features - Pivot Table
Close property dialog box

Alt + F4

Manage Access Features - Pivot Table
Cancel refresh operation in progress

Esc

Manage Access Features - Pivot Table
Export contents to Excel

Ctrl + E

Manage Access Features - Pivot Table
Toggle expand indicators (plus and minus signs)

Ctrl + 8

Manage Access Features - Pivot Table
Expand selected item

Ctrl + [ + on numeric keyboard

Manage Access Features - Pivot Table
Collapse current item

Ctrl + - on numeric keyboard

Manage Access Features - Pivot Table
Open list for currently selected item

Alt + Arrow Down

Manage Access Features - Pivot Table
Toggle AutoFilter

Ctrl + T

Manage Access Features - Pivot Table
Sort data ascending (A-Z)

Ctrl + Shift + A

Manage Access Features - Pivot Table
Sort data descending (Z-A)

Ctrl + Shift + Z

Manage Access Features - Pivot Table
Move selected member up / down

Alt + Shift + Arrow Up / Alt + Shift + Arrow Up

Manage Access Features - Pivot Table
Move selected member right / left

Alt + Shift + Arrow Right / Alt + Shift + Arrow Left

Manage Access Features - Pivot Table
Display Field List pane

Ctrl + L

Manage Access Features - Pivot Table
Add new total field using sum summary

Ctrl + Shift + S

Manage Access Features - Pivot Table
Add new total field using count summary

Ctrl + Shift + C

Manage Access Features - Pivot Table
Add new total field using min summary

Ctrl + Shift + M

Manage Access Features - Pivot Table
Add new total field using max summary

Ctrl + Shift + X

Manage Access Features - Pivot Table
Add new total field using average summary

Ctrl + Shift + E

Manage Access Features - Pivot Table
Add new total field using standard deviation summary

Ctrl + Shift + D

Manage Access Features - Pivot Table
Add new total field using standard deviation population summary

Ctrl + Shift + T

Manage Access Features - Pivot Table
Turn subtotals and grand totals on or off for selected field

Ctrl + Shift + B

Manage Access Features - Pivot Table
Add a calculated detail field

Ctrl + F

Manage Access Features - Pivot Table
Move selected field to row area

Ctrl + 1

Manage Access Features - Pivot Table
Move selected field to column area

Ctrl + 2

Manage Access Features - Pivot Table
Move selected field to filter area

Ctrl + 3

Manage Access Features - Pivot Table
Move selected field to detail area

Ctrl + 4

Manage Access Features - Pivot Table
Move selection up one level / down one level

Ctrl + Arrow Left / Ctrl + Arrow Right

Manage Access Features - Pivot Table
Apply the general number format to values

Ctrl + Shift + ~

Manage Access Features - Pivot Table
Apply the currency format to values

Ctrl + Shift + $

Manage Access Features - Pivot Table
Apply the percentage format to values

Ctrl + Shift + %

Manage Access Features - Pivot Table
Apply the exponential number format to values

Ctrl + Shift + ^

Manage Access Features - Pivot Table
Apply the date format to values

Ctrl + Shift + #

Manage Access Features - Pivot Table
Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field

Ctrl + Shift + @

Manage Access Features - Pivot Table
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

Ctrl + Shift + !

Manage Access Features - Pivot Table
Make text bold in the selected field of the PivotTable view

Ctrl + B

Manage Access Features - Pivot Table
Make text underlined in the selected field of the PivotTable view

Ctrl + U

Manage Access Features - Pivot Table
Make text italic in the selected field of the PivotTable view

Ctrl + I

Manage Access Features - Manage Windows
Toggle the Navigation Pane

F11

Manage Access Features - Manage Windows
Cycle between open windows

Ctrl + F6

Manage Access Features - Manage Windows
Restore the selected minimized window when all windows are minimized

Enter

Manage Access Features - Manage Windows
Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window

Ctrl + F8

Manage Access Features - Manage Windows
Display the control menu

Alt + Space

Manage Access Features - Manage Windows
Display the shortcut menu

Shift + F10

Manage Access Features - Manage Windows
Close the active window

Ctrl + W / Ctrl + F4

Manage Access Features - Manage Windows
Switch between the Visual Basic Editor and the previous active window

Alt + F11

Manage Access Features - Print Preview
Open the Print dialog box (or p)

Ctrl + P

Manage Access Features - Print Preview
Open the page setup dialog box

S

Manage Access Features - Print Preview
Cancel print/ layout preview (or escape)

C

Manage Access Features - Help Window
Go to next / go to previous text or hyperlink

Tab / Shift + Tab

Manage Access Features - Help Window
Perform action for currently selected item

Enter

Manage Access Features - Help Window
Move back / move forward

Alt + Arrow Left / Alt + Arrow Right

Manage Access Features - Help Window
Open the Print dialog box

Ctrl + P

Manage Access Features - Help Window
Move up / move down in small increments

Arrow Up / Arrow Down

Manage Access Features - Help Window
Move up / move down one one page

Page Up / Page Down

Manage Access Features - Help Window
Show context menu

Shift + F10

Manage Access Features - Other Shortcuts
Display hyperlink

F2

Manage Access Features - Other Shortcuts
Check spelling

F7

Manage Access Features - Other Shortcuts
Open the Zoom box

Shift + F2

Manage Access Features - Other Shortcuts
Display a property sheet in Design view

Alt + Enter

Manage Access Features - Other Shortcuts
Invoke a Builder

Ctrl + F2

Manage Access Features - Other Shortcuts
Toggle forward / toggle backwards between views when in a table, or other elements

Ctrl + Arrow Right / Ctrl + Arrow Left

Working with Text and Data - Find and Replace
Find and replace dialog box

Ctrl + F

Working with Text and Data - Find and Replace
(Find and) Replace dialog box

Ctrl + H

Working with Text and Data - Find and Replace
Find next

Shift + F4

Working with Text and Data - Find and Replace
Go to the Navigation Pane search box from anywhere in the database

Alt + Ctrl + F

Working with Text and Data - Form Controls
Cut / Copy / Paste

Ctrl + X / Ctrl + C / Ctrl + V

Working with Text and Data - Form Controls
Move selected control up/down/left/right (Optionally, add Ctrl to key combination)

Arrow Keys

Working with Text and Data - Form Controls
Increase / decrease height of the selected control

Shift + Arrow Down / Shift + Arrow Up

Working with Text and Data - Form Controls
Increase / decrease width of the selected control

Shift + Arrow Right / Shift + Arrow Left

Working with Text and Data - Wizards
Toggle the focus forward between controls in the wizard

Tab

Working with Text and Data - Wizards
Move to the next page of the wizard

Alt + N

Working with Text and Data - Wizards
Move to the previous page of the wizard

Alt + B

Working with Text and Data - Wizards
Complete the wizard

Alt + F

Working with Text and Data - Menus
Show the shortcut menu

Shift + F10

Working with Text and Data - Menus
Show the access keys (of F10)

Alt

Working with Text and Data - Menus
Show the program icon menu

Alt + Space

Working with Text and Data - Menus
Select the next / select previous command in menu

Arrow Down / Arrow Up

Working with Text and Data - Menus
Select the menu to the left / menu to the right

Arrow Left / Arrow Right

Working with Text and Data - Menus
Select first / select last command in menu

Home / End

Working with Text and Data - Menus
Close the visible menu and submenu at the same time

Alt

Working with Text and Data - Menus
Close the visible menu; or, with a submenu visible, to close the submenu

Esc

Working with Text and Data - Dialog Boxes
Switch to next tab / switch to previous tab in a dialog box

Ctrl + Tab / Ctrl + Shift + Tab

Working with Text and Data - Dialog Boxes
Move to the next / switch to previous option or option group

Tab / Shift + Tab

Working with Text and Data - Dialog Boxes
Move between options

Arrow Keys

Working with Text and Data - Dialog Boxes
Select current button

Space

Working with Text and Data - Dialog Boxes
Open the selected drop-down list box

Alt + Arrow Down

Working with Text and Data - Dialog Boxes
Close the selected drop-down list box

Esc

Working with Text and Data - Dialog Boxes
Perform the action assigned to the default button in the dialog box

Enter

Working with Text and Data - Dialog Boxes
Cancel the command and close the dialog box

Esc

Working with Text and Data - Dialog Boxes
Close a dialog box

Alt + F4

Working with Text and Data - Text Boxes
Move beginning / move to end of an entry

Home / End

Working with Text and Data - Text Boxes
Move one word to the left or right

Ctrl + Arrow Left / Ctrl + Arrow Right

Working with Text and Data - Text Boxes
Select from cursor to end / to beginning

Shift + Home / Shift + End

Working with Text and Data - Text Boxes
Extend selection one character to the left / to the right

Shift + Arrow Left / Shift + Arrow Right

Working with Text and Data - Field List Pane
Toggle the Field List pane

Alt + F8

Working with Text and Data - Field List Pane
Add the selected field to the form or report detail section

Enter

Working with Text and Data - Field List Pane
Move up / move down the Field List pane

Arrow Up / Arrow Down

Working with Text and Data - Field List Pane
Move to the upper Field List pane from the lower pane

Shift + Tab

Working with Text and Data - Field List Pane
Move to the lower Field List pane from the upper pane

Tab

Working with Text and Data - Select and move Fields or Columns
Select next field / select previous field

Tab / Shift + Tab

Working with Text and Data - Select and move Fields or Columns

F2

Working with Text and Data - Select and move Fields or Columns
Switch between selecting the current record and the first field of the current record,

Shift + Space

Working with Text and Data - Select and move Fields or Columns
Extend selection to previous record/ to next record

Shift + Arrow Up / Shift + Arrow Down

Working with Text and Data - Select and move Fields or Columns
Select all records (or Ctrl+Shift+Space)

Ctrl + A

Working with Text and Data - Select and move Fields or Columns
Turn on Extend mode

F8

Working with Text and Data - Select and move Fields or Columns
Extend a selection to adjacent fields in the same row in Datasheet view

Arrow Left / Arrow Right

Working with Text and Data - Select and move Fields or Columns
Extend a selection to adjacent rows in Datasheet view

Arrow Up / Arrow Down

Working with Text and Data - Select and move Fields or Columns
Undo the previous extension

Shift + F8

Working with Text and Data - Select and move Fields or Columns
Cancel Extend mode

Esc

Working with Text and Data - Select and move Fields or Columns
Select the current column

Ctrl + Space

Working with Text and Data - Select and move Fields or Columns
Select the column to the right / to the left, if the current column is selected

Shift + Arrow Right / Shift + Arrow Left

Working with Text and Data - Select and move Fields or Columns
Turn on Move mode

Ctrl + Shift + F8

Working with Text and Data - Edit Text and Data
Move cursor one character to the right / to the left

Arrow Right / Arrow Left

Working with Text and Data - Edit Text and Data
Move cursor one word to the right / to the left

Ctrl + Arrow Right / Ctrl + Arrow Left

Working with Text and Data - Edit Text and Data
Move cursor to the beginning / to the end of the field

Home / End

Working with Text and Data - Edit Text and Data
Move cursor to the beginning / to the end of the line in multi-line fields

Ctrl + Home / Ctrl + End

Working with Text and Data - Edit Text and Data
Delete all characters to the right of the insertion point

Ctrl + Delete

Working with Text and Data - Edit Text and Data
Undo Changes

Ctrl + Z

Working with Text and Data - Edit Text and Data
Redo Changes

Ctrl + Y

Working with Text and Data - Edit Text and Data
Cancel / undo changes in the current field or current record

Esc

Working with Text and Data - Insert Data
Insert the current date

Ctrl + ;

Working with Text and Data - Insert Data
Insert the current time

Ctrl + :

Working with Text and Data - Insert Data
Insert the default value for a field

Ctrl + Alt + Space

Working with Text and Data - Insert Data
Insert the value from the same field in the previous record

Ctrl + '

Working with Text and Data - Insert Data
Add a new record

Ctrl + [ + ]

Working with Text and Data - Insert Data
In a datasheet, delete the current record

Ctrl + -

Working with Text and Data - Insert Data
Save changes to the current record

Shift + Enter

Working with Text and Data - Insert Data
Switch between the values in a check box or option button

Space

Working with Text and Data - Insert Data
Insert a new line

Ctrl + Enter

Working with Text and Data - Refresh Fields
Recalculate the fields in the window or the contents of a Lookup field

F9

Working with Text and Data - Refresh Fields
Requery the underlying tables

Shift + F9

Working with Text and Data - Design View
Switch between Edit and Navigation mode

F2

Working with Text and Data - Design View
Toggle the property sheet

F4

Working with Text and Data - Design View
Switch to Form view from form Design view

F5

Working with Text and Data - Design View
Switch between the windows, or between design panes / properties / etc

F6

Working with Text and Data - Design View
Open the Visual Basic Editor from a selected property in the property sheet for a form or report

F7

Working with Text and Data - Design View
Invokes 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.

Alt + F8

Working with Text and Data - Design View
Switch to Form or Report Design View (from Visual Basic Editor with code module open)

Shift + F7

Working with Text and Data - Design View
Display a property sheet

Alt + Enter

Working with Text and Data - Design View
Cut / Copy / Paste

Ctrl + X / Ctrl + C / Ctrl + V

Working with Text and Data - Design View
Move selected control up/down/left/right along the grid

Arrow Keys

Working with Text and Data - Design View
Move selected control up/down/left/right by one pixel

Ctrl + Arrow Keys

Working with Text and Data - Design View
Increase / decrease height of the selected control

Shift + Arrow Down / Shift + Arrow Up

Working with Text and Data - Design View
Increase / decrease width of the selected control

Shift + Arrow Right / Shift + Arrow Left

Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View
Move to the record number box, type in number and press enter

F5

Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View
Move to next / move to previous field in current record

Tab / Shift + Tab

Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View
Move to first / move to last field in current record

Home / End

Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View
Move to next / move to previous record

Arrow Down / Arrow Up

Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View
Move to last record / move to first record (or current field in next record / in previous record when in subdatasheet)

Ctrl + Arrow Down / Ctrl + Arrow Up

Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View
Move to first field in first record / last field in last record

Ctrl + Home / Ctrl + End

Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View
Move down one screen / move up one screen

Page Down / Page Up

Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View
Move right one screen / left one screen

Ctrl + Page Down / Ctrl + Page Up

Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View
In subdatasheet: Exit to next / to previous record

Ctrl + Tab / Ctrl + Shift + Tab

Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View
Expand subdatasheet

Ctrl + Shift + Arrow Down

Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View
Collapse subdatasheet

Ctrl + Shift + Arrow Up

Working with Text and Data - Navigate in Datasheet, Subdatasheet, and Form View
Move from subdatasheet to record number box, enter record number and press enter

Alt + F5

Working with Text and Data - Database Diagram
Move from a table cell to the table's title bar

Esc

Working with Text and Data - Database Diagram
Move from a table's title bar to the last cell you edited

Enter

Working with Text and Data - Database Diagram
Move from table title bar to table title bar, or from cell to cell inside a table

Tab

Working with Text and Data - Database Diagram
Expand a list inside a table

Alt + Arrow Down

Working with Text and Data - Database Diagram
Move up / down in a list

Arrow Down / Arrow Up

Working with Text and Data - Database Diagram
Change the setting in a check box

Space

Working with Text and Data - Database Diagram
Go to the first cell / go to last cell in row

Home / End

Working with Text and Data - Database Diagram
Go to next / go to previous page of the diagram

Page Down / Page Up

Working with Text and Data - Query Designer
Move forward / backwards among the Query Designer panes

F6 / Shift + F6

Working with Text and Data - Query Designer
Move forward / backwards among tables, views, functions, or join line.

Tab / Shift + Tab

Working with Text and Data - Query Designer
Move between columns in a table, view, or function

Arrow Keys

Working with Text and Data - Query Designer
Choose the selected data column for output (or use +/-)

Space

Working with Text and Data - Query Designer
Remove the selected table, view, function, or join line

Delete

Working with Text and Data - Query Designer
In Grid Pane: toggle between edit mode and cell selection mode

F2

Working with Text and Data - Query Designer
Insert row between existing columns

Insert

Working with Text and Data - Pivot Table
Move to the right / to the left

Tab / Shift + Tab

Working with Text and Data - Pivot Table
Move down / move up

Enter / Shift + Enter

Working with Text and Data - Pivot Table
Select cell above current cell

Shift + Enter

Working with Text and Data - Pivot Table
Select detail cell for next item / previous item in row

Ctrl + Enter / Ctrl + Shift + Enter

Working with Text and Data - Pivot Table
Expand selection

Shift + Arrow Keys

Working with Text and Data - Pivot Table
Select entire PivotTable View

Ctrl + A

Working with Text and Data - Pivot Table
Display context menu

Shift + F10

Working with Text and Data - Pivot Table
Display property dialog box

Alt + Enter

Working with Text and Data - Pivot Table
Close property dialog box

Alt + F4

Working with Text and Data - Pivot Table
Cancel refresh operation in progress

Esc

Working with Text and Data - Pivot Table
Export contents to Excel

Ctrl + E

Working with Text and Data - Pivot Table
Toggle expand indicators (plus and minus signs)

Ctrl + 8

Working with Text and Data - Pivot Table
Expand selected item

Ctrl + [ + on numeric keyboard

Working with Text and Data - Pivot Table
Collapse current item

Ctrl + - on numeric keyboard

Working with Text and Data - Pivot Table
Open list for currently selected item

Alt + Arrow Down

Working with Text and Data - Pivot Table
Toggle AutoFilter

Ctrl + T

Working with Text and Data - Pivot Table
Sort data ascending (A-Z)

Ctrl + Shift + A

Working with Text and Data - Pivot Table
Sort data descending (Z-A)

Ctrl + Shift + Z

Working with Text and Data - Pivot Table
Move selected member up / down

Alt + Shift + Arrow Up / Alt + Shift + Arrow Up

Working with Text and Data - Pivot Table
Move selected member right / left

Alt + Shift + Arrow Right / Alt + Shift + Arrow Left

Working with Text and Data - Pivot Table
Display Field List pane

Ctrl + L

Working with Text and Data - Pivot Table
Add new total field using sum summary

Ctrl + Shift + S

Working with Text and Data - Pivot Table
Add new total field using count summary

Ctrl + Shift + C

Working with Text and Data - Pivot Table
Add new total field using min summary

Ctrl + Shift + M

Working with Text and Data - Pivot Table
Add new total field using max summary

Ctrl + Shift + X

Working with Text and Data - Pivot Table
Add new total field using average summary

Ctrl + Shift + E

Working with Text and Data - Pivot Table
Add new total field using standard deviation summary

Ctrl + Shift + D

Working with Text and Data - Pivot Table
Add new total field using standard deviation population summary

Ctrl + Shift + T

Working with Text and Data - Pivot Table
Turn subtotals and grand totals on or off for selected field

Ctrl + Shift + B

Working with Text and Data - Pivot Table
Add a calculated detail field

Ctrl + F

Working with Text and Data - Pivot Table
Move selected field to row area

Ctrl + 1

Working with Text and Data - Pivot Table
Move selected field to column area

Ctrl + 2

Working with Text and Data - Pivot Table
Move selected field to filter area

Ctrl + 3

Working with Text and Data - Pivot Table
Move selected field to detail area

Ctrl + 4

Working with Text and Data - Pivot Table
Move selection up one level / down one level

Ctrl + Arrow Left / Ctrl + Arrow Right

Working with Text and Data - Pivot Table
Apply the general number format to values

Ctrl + Shift + ~

Working with Text and Data - Pivot Table
Apply the currency format to values

Ctrl + Shift + $

Working with Text and Data - Pivot Table
Apply the percentage format to values

Ctrl + Shift + %

Working with Text and Data - Pivot Table
Apply the exponential number format to values

Ctrl + Shift + ^

Working with Text and Data - Pivot Table
Apply the date format to values

Ctrl + Shift + #

Working with Text and Data - Pivot Table
Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field

Ctrl + Shift + @

Working with Text and Data - Pivot Table
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

Ctrl + Shift + !

Working with Text and Data - Pivot Table
Make text bold in the selected field of the PivotTable view

Ctrl + B

Working with Text and Data - Pivot Table
Make text underlined in the selected field of the PivotTable view

Ctrl + U

Working with Text and Data - Pivot Table
Make text italic in the selected field of the PivotTable view

Ctrl + I

Working with Text and Data - Manage Windows
Toggle the Navigation Pane

F11

Working with Text and Data - Manage Windows
Cycle between open windows

Ctrl + F6

Working with Text and Data - Manage Windows
Restore the selected minimized window when all windows are minimized

Enter

Working with Text and Data - Manage Windows
Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window

Ctrl + F8

Working with Text and Data - Manage Windows
Display the control menu

Alt + Space

Working with Text and Data - Manage Windows
Display the shortcut menu

Shift + F10

Working with Text and Data - Manage Windows
Close the active window

Ctrl + W / Ctrl + F4

Working with Text and Data - Manage Windows
Switch between the Visual Basic Editor and the previous active window

Alt + F11

Working with Text and Data - Print Preview
Open the Print dialog box (or p)

Ctrl + P

Working with Text and Data - Print Preview
Open the page setup dialog box

S

Working with Text and Data - Print Preview
Cancel print/ layout preview (or escape)

C

Working with Text and Data - Help Window
Go to next / go to previous text or hyperlink

Tab / Shift + Tab

Working with Text and Data - Help Window
Perform action for currently selected item

Enter

Working with Text and Data - Help Window
Move back / move forward

Alt + Arrow Left / Alt + Arrow Right

Working with Text and Data - Help Window
Open the Print dialog box

Ctrl + P

Working with Text and Data - Help Window
Move up / move down in small increments

Arrow Up / Arrow Down

Working with Text and Data - Help Window
Move up / move down one one page

Page Up / Page Down

Working with Text and Data - Help Window
Show context menu

Shift + F10

Working with Text and Data - Other Shortcuts
Display hyperlink

F2

Working with Text and Data - Other Shortcuts
Check spelling

F7

Working with Text and Data - Other Shortcuts
Open the Zoom box

Shift + F2

Working with Text and Data - Other Shortcuts
Display a property sheet in Design view

Alt + Enter

Working with Text and Data - Other Shortcuts
Invoke a Builder

Ctrl + F2

Working with Text and Data - Other Shortcuts
Toggle forward / toggle backwards between views when in a table, or other elements

Ctrl + Arrow Right / Ctrl + Arrow Left

Working with Access Views - Find and Replace
Find and replace dialog box

Ctrl + F

Working with Access Views - Find and Replace
(Find and) Replace dialog box

Ctrl + H

Working with Access Views - Find and Replace
Find next

Shift + F4

Working with Access Views - Find and Replace
Go to the Navigation Pane search box from anywhere in the database

Alt + Ctrl + F

Working with Access Views - Form Controls
Cut / Copy / Paste

Ctrl + X / Ctrl + C / Ctrl + V

Working with Access Views - Form Controls
Move selected control up/down/left/right (Optionally, add Ctrl to key combination)

Arrow Keys

Working with Access Views - Form Controls
Increase / decrease height of the selected control

Shift + Arrow Down / Shift + Arrow Up

Working with Access Views - Form Controls
Increase / decrease width of the selected control

Shift + Arrow Right / Shift + Arrow Left

Working with Access Views - Wizards
Toggle the focus forward between controls in the wizard

Tab

Working with Access Views - Wizards
Move to the next page of the wizard

Alt + N

Working with Access Views - Wizards
Move to the previous page of the wizard

Alt + B

Working with Access Views - Wizards
Complete the wizard

Alt + F

Working with Access Views - Menus
Show the shortcut menu

Shift + F10

Working with Access Views - Menus
Show the access keys (of F10)

Alt

Working with Access Views - Menus
Show the program icon menu

Alt + Space

Working with Access Views - Menus
Select the next / select previous command in menu

Arrow Down / Arrow Up

Working with Access Views - Menus
Select the menu to the left / menu to the right

Arrow Left / Arrow Right

Working with Access Views - Menus
Select first / select last command in menu

Home / End

Working with Access Views - Menus
Close the visible menu and submenu at the same time

Alt

Working with Access Views - Menus
Close the visible menu; or, with a submenu visible, to close the submenu

Esc

Working with Access Views - Dialog Boxes
Switch to next tab / switch to previous tab in a dialog box

Ctrl + Tab / Ctrl + Shift + Tab

Working with Access Views - Dialog Boxes
Move to the next / switch to previous option or option group

Tab / Shift + Tab

Working with Access Views - Dialog Boxes
Move between options

Arrow Keys

Working with Access Views - Dialog Boxes
Select current button

Space

Working with Access Views - Dialog Boxes
Open the selected drop-down list box

Alt + Arrow Down

Working with Access Views - Dialog Boxes
Close the selected drop-down list box

Esc

Working with Access Views - Dialog Boxes
Perform the action assigned to the default button in the dialog box

Enter

Working with Access Views - Dialog Boxes
Cancel the command and close the dialog box

Esc

Working with Access Views - Dialog Boxes
Close a dialog box

Alt + F4

Working with Access Views - Text Boxes
Move beginning / move to end of an entry

Home / End

Working with Access Views - Text Boxes
Move one word to the left or right

Ctrl + Arrow Left / Ctrl + Arrow Right

Working with Access Views - Text Boxes
Select from cursor to end / to beginning

Shift + Home / Shift + End

Working with Access Views - Text Boxes
Extend selection one character to the left / to the right

Shift + Arrow Left / Shift + Arrow Right

Working with Access Views - Field List Pane
Toggle the Field List pane

Alt + F8

Working with Access Views - Field List Pane
Add the selected field to the form or report detail section

Enter

Working with Access Views - Field List Pane
Move up / move down the Field List pane

Arrow Up / Arrow Down

Working with Access Views - Field List Pane
Move to the upper Field List pane from the lower pane

Shift + Tab

Working with Access Views - Field List Pane
Move to the lower Field List pane from the upper pane

Tab

Working with Access Views - Select and move Fields or Columns
Select next field / select previous field

Tab / Shift + Tab

Working with Access Views - Select and move Fields or Columns

F2

Working with Access Views - Select and move Fields or Columns
Switch between selecting the current record and the first field of the current record,

Shift + Space

Working with Access Views - Select and move Fields or Columns
Extend selection to previous record/ to next record

Shift + Arrow Up / Shift + Arrow Down

Working with Access Views - Select and move Fields or Columns
Select all records (or Ctrl+Shift+Space)

Ctrl + A

Working with Access Views - Select and move Fields or Columns
Turn on Extend mode

F8

Working with Access Views - Select and move Fields or Columns
Extend a selection to adjacent fields in the same row in Datasheet view

Arrow Left / Arrow Right

Working with Access Views - Select and move Fields or Columns
Extend a selection to adjacent rows in Datasheet view

Arrow Up / Arrow Down

Working with Access Views - Select and move Fields or Columns
Undo the previous extension

Shift + F8

Working with Access Views - Select and move Fields or Columns
Cancel Extend mode

Esc

Working with Access Views - Select and move Fields or Columns
Select the current column

Ctrl + Space

Working with Access Views - Select and move Fields or Columns
Select the column to the right / to the left, if the current column is selected

Shift + Arrow Right / Shift + Arrow Left

Working with Access Views - Select and move Fields or Columns
Turn on Move mode

Ctrl + Shift + F8

Working with Access Views - Edit Text and Data
Move cursor one character to the right / to the left

Arrow Right / Arrow Left

Working with Access Views - Edit Text and Data
Move cursor one word to the right / to the left

Ctrl + Arrow Right / Ctrl + Arrow Left

Working with Access Views - Edit Text and Data
Move cursor to the beginning / to the end of the field

Home / End

Working with Access Views - Edit Text and Data
Move cursor to the beginning / to the end of the line in multi-line fields

Ctrl + Home / Ctrl + End

Working with Access Views - Edit Text and Data
Delete all characters to the right of the insertion point

Ctrl + Delete

Working with Access Views - Edit Text and Data
Undo Changes

Ctrl + Z

Working with Access Views - Edit Text and Data
Redo Changes

Ctrl + Y

Working with Access Views - Edit Text and Data
Cancel / undo changes in the current field or current record

Esc

Working with Access Views - Insert Data
Insert the current date

Ctrl + ;

Working with Access Views - Insert Data
Insert the current time

Ctrl + :

Working with Access Views - Insert Data
Insert the default value for a field

Ctrl + Alt + Space

Working with Access Views - Insert Data
Insert the value from the same field in the previous record

Ctrl + '

Working with Access Views - Insert Data
Add a new record

Ctrl + [ + ]

Working with Access Views - Insert Data
In a datasheet, delete the current record

Ctrl + -

Working with Access Views - Insert Data
Save changes to the current record

Shift + Enter

Working with Access Views - Insert Data
Switch between the values in a check box or option button

Space

Working with Access Views - Insert Data
Insert a new line

Ctrl + Enter

Working with Access Views - Refresh Fields
Recalculate the fields in the window or the contents of a Lookup field

F9

Working with Access Views - Refresh Fields
Requery the underlying tables

Shift + F9

Working with Access Views - Design View
Switch between Edit and Navigation mode

F2

Working with Access Views - Design View
Toggle the property sheet

F4

Working with Access Views - Design View
Switch to Form view from form Design view

F5

Working with Access Views - Design View
Switch between the windows, or between design panes / properties / etc

F6

Working with Access Views - Design View
Open the Visual Basic Editor from a selected property in the property sheet for a form or report

F7

Working with Access Views - Design View
Invokes 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.

Alt + F8

Working with Access Views - Design View
Switch to Form or Report Design View (from Visual Basic Editor with code module open)

Shift + F7

Working with Access Views - Design View
Display a property sheet

Alt + Enter

Working with Access Views - Design View
Cut / Copy / Paste

Ctrl + X / Ctrl + C / Ctrl + V

Working with Access Views - Design View
Move selected control up/down/left/right along the grid

Arrow Keys

Working with Access Views - Design View
Move selected control up/down/left/right by one pixel

Ctrl + Arrow Keys

Working with Access Views - Design View
Increase / decrease height of the selected control

Shift + Arrow Down / Shift + Arrow Up

Working with Access Views - Design View
Increase / decrease width of the selected control

Shift + Arrow Right / Shift + Arrow Left

Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View
Move to the record number box, type in number and press enter

F5

Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View
Move to next / move to previous field in current record

Tab / Shift + Tab

Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View
Move to first / move to last field in current record

Home / End

Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View
Move to next / move to previous record

Arrow Down / Arrow Up

Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View
Move to last record / move to first record (or current field in next record / in previous record when in subdatasheet)

Ctrl + Arrow Down / Ctrl + Arrow Up

Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View
Move to first field in first record / last field in last record

Ctrl + Home / Ctrl + End

Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View
Move down one screen / move up one screen

Page Down / Page Up

Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View
Move right one screen / left one screen

Ctrl + Page Down / Ctrl + Page Up

Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View
In subdatasheet: Exit to next / to previous record

Ctrl + Tab / Ctrl + Shift + Tab

Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View
Expand subdatasheet

Ctrl + Shift + Arrow Down

Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View
Collapse subdatasheet

Ctrl + Shift + Arrow Up

Working with Access Views - Navigate in Datasheet, Subdatasheet, and Form View
Move from subdatasheet to record number box, enter record number and press enter

Alt + F5

Working with Access Views - Database Diagram
Move from a table cell to the table's title bar

Esc

Working with Access Views - Database Diagram
Move from a table's title bar to the last cell you edited

Enter

Working with Access Views - Database Diagram
Move from table title bar to table title bar, or from cell to cell inside a table

Tab

Working with Access Views - Database Diagram
Expand a list inside a table

Alt + Arrow Down

Working with Access Views - Database Diagram
Move up / down in a list

Arrow Down / Arrow Up

Working with Access Views - Database Diagram
Change the setting in a check box

Space

Working with Access Views - Database Diagram
Go to the first cell / go to last cell in row

Home / End

Working with Access Views - Database Diagram
Go to next / go to previous page of the diagram

Page Down / Page Up

Working with Access Views - Query Designer
Move forward / backwards among the Query Designer panes

F6 / Shift + F6

Working with Access Views - Query Designer
Move forward / backwards among tables, views, functions, or join line.

Tab / Shift + Tab

Working with Access Views - Query Designer
Move between columns in a table, view, or function

Arrow Keys

Working with Access Views - Query Designer
Choose the selected data column for output (or use +/-)

Space

Working with Access Views - Query Designer
Remove the selected table, view, function, or join line

Delete

Working with Access Views - Query Designer
In Grid Pane: toggle between edit mode and cell selection mode

F2

Working with Access Views - Query Designer
Insert row between existing columns

Insert

Working with Access Views - Pivot Table
Move to the right / to the left

Tab / Shift + Tab

Working with Access Views - Pivot Table
Move down / move up

Enter / Shift + Enter

Working with Access Views - Pivot Table
Select cell above current cell

Shift + Enter

Working with Access Views - Pivot Table
Select detail cell for next item / previous item in row

Ctrl + Enter / Ctrl + Shift + Enter

Working with Access Views - Pivot Table
Expand selection

Shift + Arrow Keys

Working with Access Views - Pivot Table
Select entire PivotTable View

Ctrl + A

Working with Access Views - Pivot Table
Display context menu

Shift + F10

Working with Access Views - Pivot Table
Display property dialog box

Alt + Enter

Working with Access Views - Pivot Table
Close property dialog box

Alt + F4

Working with Access Views - Pivot Table
Cancel refresh operation in progress

Esc

Working with Access Views - Pivot Table
Export contents to Excel

Ctrl + E

Working with Access Views - Pivot Table
Toggle expand indicators (plus and minus signs)

Ctrl + 8

Working with Access Views - Pivot Table
Expand selected item

Ctrl + [ + on numeric keyboard

Working with Access Views - Pivot Table
Collapse current item

Ctrl + - on numeric keyboard

Working with Access Views - Pivot Table
Open list for currently selected item

Alt + Arrow Down

Working with Access Views - Pivot Table
Toggle AutoFilter

Ctrl + T

Working with Access Views - Pivot Table
Sort data ascending (A-Z)

Ctrl + Shift + A

Working with Access Views - Pivot Table
Sort data descending (Z-A)

Ctrl + Shift + Z

Working with Access Views - Pivot Table
Move selected member up / down

Alt + Shift + Arrow Up / Alt + Shift + Arrow Up

Working with Access Views - Pivot Table
Move selected member right / left

Alt + Shift + Arrow Right / Alt + Shift + Arrow Left

Working with Access Views - Pivot Table
Display Field List pane

Ctrl + L

Working with Access Views - Pivot Table
Add new total field using sum summary

Ctrl + Shift + S

Working with Access Views - Pivot Table
Add new total field using count summary

Ctrl + Shift + C

Working with Access Views - Pivot Table
Add new total field using min summary

Ctrl + Shift + M

Working with Access Views - Pivot Table
Add new total field using max summary

Ctrl + Shift + X

Working with Access Views - Pivot Table
Add new total field using average summary

Ctrl + Shift + E

Working with Access Views - Pivot Table
Add new total field using standard deviation summary

Ctrl + Shift + D

Working with Access Views - Pivot Table
Add new total field using standard deviation population summary

Ctrl + Shift + T

Working with Access Views - Pivot Table
Turn subtotals and grand totals on or off for selected field

Ctrl + Shift + B

Working with Access Views - Pivot Table
Add a calculated detail field

Ctrl + F

Working with Access Views - Pivot Table
Move selected field to row area

Ctrl + 1

Working with Access Views - Pivot Table
Move selected field to column area

Ctrl + 2

Working with Access Views - Pivot Table
Move selected field to filter area

Ctrl + 3

Working with Access Views - Pivot Table
Move selected field to detail area

Ctrl + 4

Working with Access Views - Pivot Table
Move selection up one level / down one level

Ctrl + Arrow Left / Ctrl + Arrow Right

Working with Access Views - Pivot Table
Apply the general number format to values

Ctrl + Shift + ~

Working with Access Views - Pivot Table
Apply the currency format to values

Ctrl + Shift + $

Working with Access Views - Pivot Table
Apply the percentage format to values

Ctrl + Shift + %

Working with Access Views - Pivot Table
Apply the exponential number format to values

Ctrl + Shift + ^

Working with Access Views - Pivot Table
Apply the date format to values

Ctrl + Shift + #

Working with Access Views - Pivot Table
Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field

Ctrl + Shift + @

Working with Access Views - Pivot Table
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

Ctrl + Shift + !

Working with Access Views - Pivot Table
Make text bold in the selected field of the PivotTable view

Ctrl + B

Working with Access Views - Pivot Table
Make text underlined in the selected field of the PivotTable view

Ctrl + U

Working with Access Views - Pivot Table
Make text italic in the selected field of the PivotTable view

Ctrl + I

Working with Access Views - Manage Windows
Toggle the Navigation Pane

F11

Working with Access Views - Manage Windows
Cycle between open windows

Ctrl + F6

Working with Access Views - Manage Windows
Restore the selected minimized window when all windows are minimized

Enter

Working with Access Views - Manage Windows
Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window

Ctrl + F8

Working with Access Views - Manage Windows
Display the control menu

Alt + Space

Working with Access Views - Manage Windows
Display the shortcut menu

Shift + F10

Working with Access Views - Manage Windows
Close the active window

Ctrl + W / Ctrl + F4

Working with Access Views - Manage Windows
Switch between the Visual Basic Editor and the previous active window

Alt + F11

Working with Access Views - Print Preview
Open the Print dialog box (or p)

Ctrl + P

Working with Access Views - Print Preview
Open the page setup dialog box

S

Working with Access Views - Print Preview
Cancel print/ layout preview (or escape)

C

Working with Access Views - Help Window
Go to next / go to previous text or hyperlink

Tab / Shift + Tab

Working with Access Views - Help Window
Perform action for currently selected item

Enter

Working with Access Views - Help Window
Move back / move forward

Alt + Arrow Left / Alt + Arrow Right

Working with Access Views - Help Window
Open the Print dialog box

Ctrl + P

Working with Access Views - Help Window
Move up / move down in small increments

Arrow Up / Arrow Down

Working with Access Views - Help Window
Move up / move down one one page

Page Up / Page Down

Working with Access Views - Help Window
Show context menu

Shift + F10

Working with Access Views - Other Shortcuts
Display hyperlink

F2

Working with Access Views - Other Shortcuts
Check spelling

F7

Working with Access Views - Other Shortcuts
Open the Zoom box

Shift + F2

Working with Access Views - Other Shortcuts
Display a property sheet in Design view

Alt + Enter

Working with Access Views - Other Shortcuts
Invoke a Builder

Ctrl + F2

Working with Access Views - Other Shortcuts
Toggle forward / toggle backwards between views when in a table, or other elements

Ctrl + Arrow Right / Ctrl + Arrow Left

The Rest - Find and Replace
Find and replace dialog box

Ctrl + F

The Rest - Find and Replace
(Find and) Replace dialog box

Ctrl + H

The Rest - Find and Replace
Find next

Shift + F4

The Rest - Find and Replace
Go to the Navigation Pane search box from anywhere in the database

Alt + Ctrl + F

The Rest - Form Controls
Cut / Copy / Paste

Ctrl + X / Ctrl + C / Ctrl + V

The Rest - Form Controls
Move selected control up/down/left/right (Optionally, add Ctrl to key combination)

Arrow Keys

The Rest - Form Controls
Increase / decrease height of the selected control

Shift + Arrow Down / Shift + Arrow Up

The Rest - Form Controls
Increase / decrease width of the selected control

Shift + Arrow Right / Shift + Arrow Left

The Rest - Wizards
Toggle the focus forward between controls in the wizard

Tab

The Rest - Wizards
Move to the next page of the wizard

Alt + N

The Rest - Wizards
Move to the previous page of the wizard

Alt + B

The Rest - Wizards
Complete the wizard

Alt + F

The Rest - Menus
Show the shortcut menu

Shift + F10

The Rest - Menus
Show the access keys (of F10)

Alt

The Rest - Menus
Show the program icon menu

Alt + Space

The Rest - Menus
Select the next / select previous command in menu

Arrow Down / Arrow Up

The Rest - Menus
Select the menu to the left / menu to the right

Arrow Left / Arrow Right

The Rest - Menus
Select first / select last command in menu

Home / End

The Rest - Menus
Close the visible menu and submenu at the same time

Alt

The Rest - Menus
Close the visible menu; or, with a submenu visible, to close the submenu

Esc

The Rest - Dialog Boxes
Switch to next tab / switch to previous tab in a dialog box

Ctrl + Tab / Ctrl + Shift + Tab

The Rest - Dialog Boxes
Move to the next / switch to previous option or option group

Tab / Shift + Tab

The Rest - Dialog Boxes
Move between options

Arrow Keys

The Rest - Dialog Boxes
Select current button

Space

The Rest - Dialog Boxes
Open the selected drop-down list box

Alt + Arrow Down

The Rest - Dialog Boxes
Close the selected drop-down list box

Esc

The Rest - Dialog Boxes
Perform the action assigned to the default button in the dialog box

Enter

The Rest - Dialog Boxes
Cancel the command and close the dialog box

Esc

The Rest - Dialog Boxes
Close a dialog box

Alt + F4

The Rest - Text Boxes
Move beginning / move to end of an entry

Home / End

The Rest - Text Boxes
Move one word to the left or right

Ctrl + Arrow Left / Ctrl + Arrow Right

The Rest - Text Boxes
Select from cursor to end / to beginning

Shift + Home / Shift + End

The Rest - Text Boxes
Extend selection one character to the left / to the right

Shift + Arrow Left / Shift + Arrow Right

The Rest - Field List Pane
Toggle the Field List pane

Alt + F8

The Rest - Field List Pane
Add the selected field to the form or report detail section

Enter

The Rest - Field List Pane
Move up / move down the Field List pane

Arrow Up / Arrow Down

The Rest - Field List Pane
Move to the upper Field List pane from the lower pane

Shift + Tab

The Rest - Field List Pane
Move to the lower Field List pane from the upper pane

Tab

The Rest - Select and move Fields or Columns
Select next field / select previous field

Tab / Shift + Tab

The Rest - Select and move Fields or Columns

F2

The Rest - Select and move Fields or Columns
Switch between selecting the current record and the first field of the current record,

Shift + Space

The Rest - Select and move Fields or Columns
Extend selection to previous record/ to next record

Shift + Arrow Up / Shift + Arrow Down

The Rest - Select and move Fields or Columns
Select all records (or Ctrl+Shift+Space)

Ctrl + A

The Rest - Select and move Fields or Columns
Turn on Extend mode

F8

The Rest - Select and move Fields or Columns
Extend a selection to adjacent fields in the same row in Datasheet view

Arrow Left / Arrow Right

The Rest - Select and move Fields or Columns
Extend a selection to adjacent rows in Datasheet view

Arrow Up / Arrow Down

The Rest - Select and move Fields or Columns
Undo the previous extension

Shift + F8

The Rest - Select and move Fields or Columns
Cancel Extend mode

Esc

The Rest - Select and move Fields or Columns
Select the current column

Ctrl + Space

The Rest - Select and move Fields or Columns
Select the column to the right / to the left, if the current column is selected

Shift + Arrow Right / Shift + Arrow Left

The Rest - Select and move Fields or Columns
Turn on Move mode

Ctrl + Shift + F8

The Rest - Edit Text and Data
Move cursor one character to the right / to the left

Arrow Right / Arrow Left

The Rest - Edit Text and Data
Move cursor one word to the right / to the left

Ctrl + Arrow Right / Ctrl + Arrow Left

The Rest - Edit Text and Data
Move cursor to the beginning / to the end of the field

Home / End

The Rest - Edit Text and Data
Move cursor to the beginning / to the end of the line in multi-line fields

Ctrl + Home / Ctrl + End

The Rest - Edit Text and Data
Delete all characters to the right of the insertion point

Ctrl + Delete

The Rest - Edit Text and Data
Undo Changes

Ctrl + Z

The Rest - Edit Text and Data
Redo Changes

Ctrl + Y

The Rest - Edit Text and Data
Cancel / undo changes in the current field or current record

Esc

The Rest - Insert Data
Insert the current date

Ctrl + ;

The Rest - Insert Data
Insert the current time

Ctrl + :

The Rest - Insert Data
Insert the default value for a field

Ctrl + Alt + Space

The Rest - Insert Data
Insert the value from the same field in the previous record

Ctrl + '

The Rest - Insert Data
Add a new record

Ctrl + [ + ]

The Rest - Insert Data
In a datasheet, delete the current record

Ctrl + -

The Rest - Insert Data
Save changes to the current record

Shift + Enter

The Rest - Insert Data
Switch between the values in a check box or option button

Space

The Rest - Insert Data
Insert a new line

Ctrl + Enter

The Rest - Refresh Fields
Recalculate the fields in the window or the contents of a Lookup field

F9

The Rest - Refresh Fields
Requery the underlying tables

Shift + F9

The Rest - Design View
Switch between Edit and Navigation mode

F2

The Rest - Design View
Toggle the property sheet

F4

The Rest - Design View
Switch to Form view from form Design view

F5

The Rest - Design View
Switch between the windows, or between design panes / properties / etc

F6

The Rest - Design View
Open the Visual Basic Editor from a selected property in the property sheet for a form or report

F7

The Rest - Design View
Invokes 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.

Alt + F8

The Rest - Design View
Switch to Form or Report Design View (from Visual Basic Editor with code module open)

Shift + F7

The Rest - Design View
Display a property sheet

Alt + Enter

The Rest - Design View
Cut / Copy / Paste

Ctrl + X / Ctrl + C / Ctrl + V

The Rest - Design View
Move selected control up/down/left/right along the grid

Arrow Keys

The Rest - Design View
Move selected control up/down/left/right by one pixel

Ctrl + Arrow Keys

The Rest - Design View
Increase / decrease height of the selected control

Shift + Arrow Down / Shift + Arrow Up

The Rest - Design View
Increase / decrease width of the selected control

Shift + Arrow Right / Shift + Arrow Left

The Rest - Navigate in Datasheet, Subdatasheet, and Form View
Move to the record number box, type in number and press enter

F5

The Rest - Navigate in Datasheet, Subdatasheet, and Form View
Move to next / move to previous field in current record

Tab / Shift + Tab

The Rest - Navigate in Datasheet, Subdatasheet, and Form View
Move to first / move to last field in current record

Home / End

The Rest - Navigate in Datasheet, Subdatasheet, and Form View
Move to next / move to previous record

Arrow Down / Arrow Up

The Rest - Navigate in Datasheet, Subdatasheet, and Form View
Move to last record / move to first record (or current field in next record / in previous record when in subdatasheet)

Ctrl + Arrow Down / Ctrl + Arrow Up

The Rest - Navigate in Datasheet, Subdatasheet, and Form View
Move to first field in first record / last field in last record

Ctrl + Home / Ctrl + End

The Rest - Navigate in Datasheet, Subdatasheet, and Form View
Move down one screen / move up one screen

Page Down / Page Up

The Rest - Navigate in Datasheet, Subdatasheet, and Form View
Move right one screen / left one screen

Ctrl + Page Down / Ctrl + Page Up

The Rest - Navigate in Datasheet, Subdatasheet, and Form View
In subdatasheet: Exit to next / to previous record

Ctrl + Tab / Ctrl + Shift + Tab

The Rest - Navigate in Datasheet, Subdatasheet, and Form View
Expand subdatasheet

Ctrl + Shift + Arrow Down

The Rest - Navigate in Datasheet, Subdatasheet, and Form View
Collapse subdatasheet

Ctrl + Shift + Arrow Up

The Rest - Navigate in Datasheet, Subdatasheet, and Form View
Move from subdatasheet to record number box, enter record number and press enter

Alt + F5

The Rest - Database Diagram
Move from a table cell to the table's title bar

Esc

The Rest - Database Diagram
Move from a table's title bar to the last cell you edited

Enter

The Rest - Database Diagram
Move from table title bar to table title bar, or from cell to cell inside a table

Tab

The Rest - Database Diagram
Expand a list inside a table

Alt + Arrow Down

The Rest - Database Diagram
Move up / down in a list

Arrow Down / Arrow Up

The Rest - Database Diagram
Change the setting in a check box

Space

The Rest - Database Diagram
Go to the first cell / go to last cell in row

Home / End

The Rest - Database Diagram
Go to next / go to previous page of the diagram

Page Down / Page Up

The Rest - Query Designer
Move forward / backwards among the Query Designer panes

F6 / Shift + F6

The Rest - Query Designer
Move forward / backwards among tables, views, functions, or join line.

Tab / Shift + Tab

The Rest - Query Designer
Move between columns in a table, view, or function

Arrow Keys

The Rest - Query Designer
Choose the selected data column for output (or use +/-)

Space

The Rest - Query Designer
Remove the selected table, view, function, or join line

Delete

The Rest - Query Designer
In Grid Pane: toggle between edit mode and cell selection mode

F2

The Rest - Query Designer
Insert row between existing columns

Insert

The Rest - Pivot Table
Move to the right / to the left

Tab / Shift + Tab

The Rest - Pivot Table
Move down / move up

Enter / Shift + Enter

The Rest - Pivot Table
Select cell above current cell

Shift + Enter

The Rest - Pivot Table
Select detail cell for next item / previous item in row

Ctrl + Enter / Ctrl + Shift + Enter

The Rest - Pivot Table
Expand selection

Shift + Arrow Keys

The Rest - Pivot Table
Select entire PivotTable View

Ctrl + A

The Rest - Pivot Table
Display context menu

Shift + F10

The Rest - Pivot Table
Display property dialog box

Alt + Enter

The Rest - Pivot Table
Close property dialog box

Alt + F4

The Rest - Pivot Table
Cancel refresh operation in progress

Esc

The Rest - Pivot Table
Export contents to Excel

Ctrl + E

The Rest - Pivot Table
Toggle expand indicators (plus and minus signs)

Ctrl + 8

The Rest - Pivot Table
Expand selected item

Ctrl + [ + on numeric keyboard

The Rest - Pivot Table
Collapse current item

Ctrl + - on numeric keyboard

The Rest - Pivot Table
Open list for currently selected item

Alt + Arrow Down

The Rest - Pivot Table
Toggle AutoFilter

Ctrl + T

The Rest - Pivot Table
Sort data ascending (A-Z)

Ctrl + Shift + A

The Rest - Pivot Table
Sort data descending (Z-A)

Ctrl + Shift + Z

The Rest - Pivot Table
Move selected member up / down

Alt + Shift + Arrow Up / Alt + Shift + Arrow Up

The Rest - Pivot Table
Move selected member right / left

Alt + Shift + Arrow Right / Alt + Shift + Arrow Left

The Rest - Pivot Table
Display Field List pane

Ctrl + L

The Rest - Pivot Table
Add new total field using sum summary

Ctrl + Shift + S

The Rest - Pivot Table
Add new total field using count summary

Ctrl + Shift + C

The Rest - Pivot Table
Add new total field using min summary

Ctrl + Shift + M

The Rest - Pivot Table
Add new total field using max summary

Ctrl + Shift + X

The Rest - Pivot Table
Add new total field using average summary

Ctrl + Shift + E

The Rest - Pivot Table
Add new total field using standard deviation summary

Ctrl + Shift + D

The Rest - Pivot Table
Add new total field using standard deviation population summary

Ctrl + Shift + T

The Rest - Pivot Table
Turn subtotals and grand totals on or off for selected field

Ctrl + Shift + B

The Rest - Pivot Table
Add a calculated detail field

Ctrl + F

The Rest - Pivot Table
Move selected field to row area

Ctrl + 1

The Rest - Pivot Table
Move selected field to column area

Ctrl + 2

The Rest - Pivot Table
Move selected field to filter area

Ctrl + 3

The Rest - Pivot Table
Move selected field to detail area

Ctrl + 4

The Rest - Pivot Table
Move selection up one level / down one level

Ctrl + Arrow Left / Ctrl + Arrow Right

The Rest - Pivot Table
Apply the general number format to values

Ctrl + Shift + ~

The Rest - Pivot Table
Apply the currency format to values

Ctrl + Shift + $

The Rest - Pivot Table
Apply the percentage format to values

Ctrl + Shift + %

The Rest - Pivot Table
Apply the exponential number format to values

Ctrl + Shift + ^

The Rest - Pivot Table
Apply the date format to values

Ctrl + Shift + #

The Rest - Pivot Table
Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field

Ctrl + Shift + @

The Rest - Pivot Table
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

Ctrl + Shift + !

The Rest - Pivot Table
Make text bold in the selected field of the PivotTable view

Ctrl + B

The Rest - Pivot Table
Make text underlined in the selected field of the PivotTable view

Ctrl + U

The Rest - Pivot Table
Make text italic in the selected field of the PivotTable view

Ctrl + I

The Rest - Manage Windows
Toggle the Navigation Pane

F11

The Rest - Manage Windows
Cycle between open windows

Ctrl + F6

The Rest - Manage Windows
Restore the selected minimized window when all windows are minimized

Enter

The Rest - Manage Windows
Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window

Ctrl + F8

The Rest - Manage Windows
Display the control menu

Alt + Space

The Rest - Manage Windows
Display the shortcut menu

Shift + F10

The Rest - Manage Windows
Close the active window

Ctrl + W / Ctrl + F4

The Rest - Manage Windows
Switch between the Visual Basic Editor and the previous active window

Alt + F11

The Rest - Print Preview
Open the Print dialog box (or p)

Ctrl + P

The Rest - Print Preview
Open the page setup dialog box

S

The Rest - Print Preview
Cancel print/ layout preview (or escape)

C

The Rest - Help Window
Go to next / go to previous text or hyperlink

Tab / Shift + Tab

The Rest - Help Window
Perform action for currently selected item

Enter

The Rest - Help Window
Move back / move forward

Alt + Arrow Left / Alt + Arrow Right

The Rest - Help Window
Open the Print dialog box

Ctrl + P

The Rest - Help Window
Move up / move down in small increments

Arrow Up / Arrow Down

The Rest - Help Window
Move up / move down one one page

Page Up / Page Down

The Rest - Help Window
Show context menu

Shift + F10

The Rest - Other Shortcuts
Display hyperlink

F2

The Rest - Other Shortcuts
Check spelling

F7

The Rest - Other Shortcuts
Open the Zoom box

Shift + F2

The Rest - Other Shortcuts
Display a property sheet in Design view

Alt + Enter

The Rest - Other Shortcuts
Invoke a Builder

Ctrl + F2

The Rest - Other Shortcuts
Toggle forward / toggle backwards between views when in a table, or other elements

Ctrl + Arrow Right / Ctrl + Arrow Left

Manage Databases
Open/create new database

Ctrl + N

Manage Databases
Open existing database

Ctrl + O

Manage Databases
Quit/ exit Access

Alt + F4

Manage Databases
Print the current or selected object

Ctrl + P

Manage Databases
Save a database object (or Shift+f12)

Ctrl + S

Manage Databases
Open the Save As dialog box

F12

Similar combinations for other applications


Tally 9.0 (Windows)
To view the report in automatic columns (Multiple Columns at all reports, Trial Balance, Cash/bank books, Group Summary & Journal Reg
General Shortcuts

Alt + N


Microsoft Windows 7 (Windows)
Display the Connection Settings menu
Windows Help

Alt + N


iTunes (Windows)
In the Get Info window, see the info for the next or previous song in the list
File and Window

Alt + N / Alt + P


Notepad2 (Windows)
Launch - New window
File Menu

Alt + N


Directory Opus (Windows)
Rename menu
Operations Toolbar

Alt + N


WinRAR (Windows)
Options menu
Menu Bar

Alt + N


Beyond Compare (Windows)
Next conflict section
Search Menu - Text Merge

Alt + N


Pro Tools (Windows)
MIDI editors - Bring to front
Window Menu

Alt + N


FL Studio (Windows)
Switch waveform helper view (when available)
Piano Roll Action

Alt + N


Sonar 2015 (Windows)
Show/hide Navigator pane
Track View

Alt + N


Access 2016 (Windows)
Move to next page of wizard
Windows/Content Switching/Navigation

Alt + N


Clink (Windows)
non-incremental-forward-search-history
BASH (GNU Readline) Line Editing

Alt + N


Microsoft PowerPoint 2016 (Windows)
Insert tab
Tab Selection

Alt + N


Microsoft Word 2016 (Windows)
Insert Tab
Access Shortcut

Alt + N


Atlassian Bamboo 6.0 (Windows)
Next Build
9 Shortcuts for Atlassian Bamboo 6.0 (Windows)

Alt + N


Clarizen (Web Application)
Opens the Navigation Panel
Genaral Shortcuts

Alt + N


SharePoint 2016 (Windows)
Create a document
List/Library Page

Alt + N


SharePoint 2016 (Windows)
Activate the Respond to this Survey button
Survey Page

Alt + N


SharePoint 2016 (Windows)
Activate the Next Page button
Survey Page

Alt + N


Microsoft Teams (Windows)
Start a New Chat
General Shortcuts

Alt + N


eSignal (Windows)
Regression Trend
49 Shortcuts for eSignal (Windows)

Alt + N


Quickbooks Desktop (Windows)
Go to previous / go to next invoice
Managing Invoices

Alt + p / Alt + n


Creo Parametric (Windows)
Manikin
26 Shortcuts for Creo Parametric (Windows)

Alt + N


TalkDesk Callbar
Toggle call notes
General

Alt + N


Mastercam (Windows)
Edit named views
53 Shortcuts for Mastercam (Windows)

Alt + N


Sitecore CMS
Navigate
Activating Content Editor Tabs

Alt + N


Wordfast Pro (Windows)
New / Select Terms
100 Shortcuts for Wordfast Pro (Windows)

Alt + N


Gmsh 4.1.4
Hide/show all post-processing view annotations
General

Alt + N


WinRAR
Options menu
Menu bar

Alt + N


SuperMemo (Windows)
Add New Note
129 Shortcuts for SuperMemo (Windows)

Alt + N


Google Chrome
Move focus to a notification
Webpage shortcuts

Alt + N


QuickBooks Desktop
Save transaction and go to the next transaction
Maneuvering

Alt + N


Novelty Visual Novel Maker
Toggle navigator windows
General

Alt + N


Gravit Designer
New design
File

Alt + N


DataQuest
Move to next step
Windows / Linux

Alt + N


SharePoint
Activate the Next Page button
Survey page

Alt + N


Bluebeam Revu
Links tab
Show tabs

Alt + N


Microsoft Word 2016
To insert tables, pictures and shapes, headers, or text boxes, open Insert tab
Ribbon: Access keys

Alt + N


Nuke
Create StickyNote
Node graph

Alt + N


Microsoft PowerPoint (Creating presentations)
Open the Insert tab
Frequently used shortcuts

Alt + N


Google Sheets
(in Google Chrome) Add-ons menu
Open a menu

Alt + N


Microsoft Excel 2016
Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes
Ribbon: Access keys for tabs

Alt + N


Outlook 2016 and Outlook 2013
then <keybs>A</keybs>, <keybs>F</keybs> Insert file
Frequently used shortcuts

Alt + N


Microsoft Access 2016
Move to the next page of the wizard
Using wizards

Alt + N


REAPER
Activate next visible MIDI item
Section: MIDI Editor

Alt + N


Microsoft Internet Explorer 11
Move focus to the Notification bar
Notification bar

Alt + N


PuTTY
Search the history forwards non-incremental
Alt key bound

Alt + N


iTunes 11 for Windows
In the Get Info window, see the info for the next or previous song in the list
File and window

Alt + N


Microsoft OneNote
Open the Insert tab
Navigation

Alt + N


Notepad2
Open document in new window
Tools

Alt + N


Nano
No conversion from DOS/Mac format enable/disable
Enable / Disable settings

Alt + N