Microsoft Access Keyboard Shortcuts

General

CTRL + NOpen a new database
CTRL + OOpen an existing database
Ctrl + Enter or Alt + DTo open the selected table, query, form, report, macro, or module in Design view
CTRL + CCopy
CTRL + VPaste
CTRL + PPrint
CTRL + SSave
CTRL + ZUndo
Alt + F4To quit Microsoft Access, close a dialogue box, or close a property sheet

Navigation

F11Display the database window
ALT + F11Switch between the Visual Basic Editor and the previously active window
F5To switch to Form view from form design or a form module
F2To display the Object Browser or display the complete hyperlink address for a selected hyperlink
Alt + EnterDisplay Object Properties
Ctrl + ITo display quick information
Ctrl + JTo list properties and methods
Ctrl + LTo display the Calls dialogue box
Ctrl + RTo select a form or report
Ctrl + Shift + ITo display parameter information
Ctrl + Shift + JTo list constants
CTRL + FFind item
F3To find the next occurrence of the text specified in the Find or Replace dialogue box when the dialogue box is closed
Shift + F3To find the previous occurrence of the text specified in the Find or Replace dialogue box when the dialogue box is closed
Ctrl + Down ArrowTo move to the current field in the last record, in Navigation mode
SHIFT + Scroll wheelTo move to the last field in the last record, in Navigation mode
CTRL + Scroll wheelTo move to the first field in the first record, in Navigation mode
Ctrl + Page DownTo move to the current field in the next record
Ctrl + Page DownTo go right one screen
Ctrl + Page UpTo move to the current field in the previous record
Ctrl + Page UpTo go left one screen
Ctrl + Shift + TabTo exit the subform and move to the previous field in the main form or previous record
Ctrl + TabTo cycle through the tab of each object's type
Ctrl + TabTo exit the subform and move to the next field in the master form or next record
F5 then type the record number and press EnterTo move to the record number box
CTRL + HFind and replace item
ESCUndo the changes you have made to the current field
ESC ESC (press ESC twice)Undo the changes you have made to the current record
CTRL + ENTERInsert a carriage return in a memo or text field
Ctrl + GTo display the Debug window
Ctrl + BreakTo halt the execution of code or a macro
Alt + F5To toggle between breaking and not breaking on unhandled errors and then step to the next statement
Alt + F8To toggle between breaking and not breaking in-class modules and then continue execution
Ctrl + F8To run code to the current insertion point and halt execution
Ctrl + Shift + F2To return to the last line position in the previously viewed procedure
F8To step into a procedure (single step)
Ctrl + Shift + F8To step out of a procedure
F9To toggle a breakpoint at the selected line
Ctrl + Shift + F9To clear all breakpoints
Ctrl + F9To set the next statement
Shift + F2To view a procedure definition, variable, or keyword
Shift + F5To reset execution of code or macro
Shift + F6To cycle back through sections
Shift + F8To step over a procedure
Shift + F9To create an instant watch for a selected expression
F5To continue execution of code or macro
F6To switch between the upper and lower panes

0 Comments

Please do not spam

Subscribe

Fill in all informations