Access 2010 (Windows)

The Rest - Pivot Table

Apply the currency format to values

Ctrl + Shift + $

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