Ms-Access Shortcuts Keys

GENERAL SHORTCUTS
Ctrl +N	Open/create new database
Ctrl +O	Open existing database
Ctrl +P	Print the current or selected object
Ctrl +S	Save a database object
F12	Open the Save As dialog box
Alt+F4	Quit/ exit Access
Ctrl +F	Find and replace dialog box
Ctrl +H	Replace dialog box
Shift+F4	Find next
Ctrl +X	Cut
Ctrl +C	Copy
Ctrl +V	Paste
Arrow Keys	Move selected control up/down/left/right
Ctrl + P + S	Open the page setup dialog box
Ctrl + P + C	Cancel print/ layout preview (or escape)
F2	Display hyperlink
F7	Check spelling
Shift+F2	Open the Zoom box
Shift+F10	Show context menu
Alt +Enter	Display a property sheet in Design view
Menus
Shift+F10	Show the shortcut menu
Alt	Show the access keys (of F10)
Alt +Space	Show the program icon menu
Arrow Down	Select the next command in menu
Arrow Up	Select previous command in menu
Arrow Left/Arrow Right	Select the menu to the left / menu to the right
Home/End	Select first command in menu
End	Select last command in menu
Alt	Close the visible menu and submenu at the same time
Esc	Close the visible menu
Dialog Boxes
Ctrl +Tab	Switch to next tab in a dialog box
Ctrl +Shift +Tab	Switch to previous tab in a dialog box
Tab	Move to the next option or option group
Shift +Tab	Switch to previous option or option group
Arrow Keys	Move between options
Space	Select current button
Alt +Arrow Down	Open the selected drop-down list box
Esc	Close the selected drop-down list box
Enter	Perform the action assigned to the default button in the dialog box
Esc	Cancel the command and close the dialog box
Alt+F4	Close a dialog box
Text Boxes
Home	Move beginning of an entry
End	Move to end of an entry
Ctrl +Arrow Left	Move one word to the left
Ctrl +Arrow Right	Move one word to the right
Shift +Home	Select from cursor to end
Shift +End	Select from cursor to beginning
Shift +Arrow Left	Extend selection one character to the left
Shift +Arrow Right	Extend selection one character to the right
Field List Pane
Alt+F8	Toggle the Field List pane
Arrow Up	Move up the Field List pane
Arrow Down	Move down the Field List pane
Shift +Tab	Move to the upper Field List pane from the lower pane
Tab	Move to the lower Field List pane from the upper pane
Text and Data
Arrow Right	Move cursor one character to the right
Arrow Left	Move cursor one character to the left
Ctrl +Arrow Right	Move cursor one word to the right
Ctrl +Arrow Left	Move cursor one word to the left
Home	Move cursor to the beginning
End	Move cursor to the end of the field
Ctrl +Home	Move cursor to the beginning
Ctrl +End	Move cursor to the end of the line in multi-line fields
Ctrl +Delete	Delete all characters to the right of the insertion point
Ctrl +Z	Undo Changes
Ctrl +Y	Redo Changes
Esc	Cancel / undo changes in the current field or current record
Ctrl +;	Insert the current date
Ctrl +:	Insert the current time
Ctrl +Alt +Space	Insert the default value for a field
Ctrl+ '	Insert the value from the same field in the previous record
Ctrl+ [ + ]	Add a new record
Ctrl+ -	In a datasheet, delete the current record
Shift + Enter	Save changes to the current record
Space	Switch between the values in a check box or option button
Ctrl + Enter	Insert a new line
Design View
F2	Switch between Edit and Navigation mode
F4	Toggle the property sheet
F5	Switch to Form view from form Design view
F6	Switch between the windows, or between design panes / properties / etc
F7	Open the Visual Basic Editor from a selected property in the property sheet for a form or report
Alt+F8	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.
Shift+F7	Switch to Form or Report Design View (from Visual Basic Editor with code module open)
Alt +Enter	Display a property sheet
Arrow Keys	Move selected control up/down/left/right along the grid
Ctrl +Arrow Keys	Move selected control up/down/left/right by one pixel
Shift +Arrow Down	Increase height of the selected control
Shift +Arrow Up	Decrease height of the selected control
Shift +Arrow Right	Increase width of the selected control
Shift +Arrow Left	Decrease width of the selected control
Datasheet, Sub datasheet, and Form View
F5	Move to the record number box, type in number and press enter
Tab	Move to next field in current record
Shift +Tab	Move to previous field in current record
Home	Move to first field in current record
End	Move to last field in current record
Arrow Down	Move to next record
Arrow Up	Move to previous record
Ctrl +Arrow Down	Move to last record
Ctrl +Arrow Up	Move to first record
Ctrl +Home	Move to first field in first record
Ctrl +End	Move to last field in last record
Page Down	Move down one screen
Page Up	Move up one screen
Ctrl +Page Down	Move right one
Ctrl +Page Up	Move left one screen
Ctrl +Tab	Exit to next record
Ctrl +Shift +Tab	Exit to previous record
Ctrl +Shift +Arrow Down	Expand sub datasheet
Ctrl +Shift +Arrow Up	Collapse sub datasheet
Database Diagram
Esc	Move from a table cell to the table's title bar
Enter	Move from a table's title bar to the last cell you edited
Tab	Move from table title bar to table title bar, or from cell to cell inside a table
Alt +Arrow Down	Expand a list inside a table
Arrow Down	Move up in a list
Arrow Up	Move down in a list
Space	Change the setting in a check box
Home	Go to the first cell in row
End	Go to last cell in row
Page Down	Go to next page of the diagram
Page Up	Go to previous page of the diagram
Query Designer
F6	Move forward among the Query Designer panes
Shift+F6	Move backwards among the Query Designer panes
Tab	Move forward among tables, views, functions, or join line.
Shift +Tab	Move backwards among tables, views, functions, or join line.
Arrow Keys	Move between columns in a table, view, or function
Space	Choose the selected data column for output
Delete	Remove the selected table, view, function, or join line
F2	In Grid Pane: toggle between edit mode and cell selection mode
Insert	Insert row between existing columns
Pivot Table
Tab	Move to the right
Shift +Tab	Move to the left
Enter	Move down
Shift +Enter	Move up
Ctrl +Enter	Select detail cell for next item in row
Ctrl +Shift +Enter	Select detail cell for previous item in row
Shift +Arrow Keys	Expand selection
Ctrl +A	Select entire PivotTable View
Shift +F10	Display context menu
Alt +Enter	Display property dialog box
Alt+F4	Close property dialog box
Esc	Cancel refresh operation in progress
Ctrl +E	Export contents to Excel
Ctrl +8	Toggle expand indicators
Alt +Arrow Down	Open list for currently selected item
Ctrl +T	Toggle AutoFilter
Ctrl +Shift +A	Sort data ascending (A-Z)
Ctrl +Shift +Z	Sort data descending (Z-A)
Alt + Shift +Arrow Up	Move selected member up
Alt +Shift +Arrow Up	Move selected member down
Ctrl +L	Display Field List pane
Ctrl +Shift +S	Add new total field using sum summary
Ctrl +Shift +C	Add new total field using count summary
Ctrl +Shift +M	Add new total field using min summary
Ctrl +Shift +X	Add new total field using max summary
Ctrl +Shift +E	Add new total field using average summary
Ctrl +Shift +D	Add new total field using standard deviation summary
Ctrl +Shift +T	Add new total field using standard deviation population summary
Ctrl +Shift +B	Turn subtotals and grand totals on or off for selected field
Ctrl +F	Add a calculated detail field
Ctrl +1	Move selected field to row area
Ctrl +2	Move selected field to column area
Ctrl +3	Move selected field to filter area
Ctrl +4	Move selected field to detail area
Ctrl +Arrow Left	Move selection up one level
Ctrl +Arrow Right	Move selection down one level
Ctrl +Shift+ ~	Apply the general number format to values
Ctrl +Shift+ $	Apply the currency format to values
Ctrl +Shift+ %	Apply the percentage format to values
Ctrl +Shift+ ^	Apply the exponential number format to values
Ctrl +Shift+ #	Apply the date format to values
Ctrl +Shift+ @	Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field
Ctrl +B	Make text bold in the selected field of the PivotTable view
Ctrl +U	Make text underlined in the selected field of the PivotTable view
Ctrl +I	Make text italic in the selected field of the PivotTable view
THE END