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
|