Microsoft Access keyboard shortcuts

Microsoft Access keyboard shortcuts




Description
Shortcut Key  
To display a property sheet
Alt + Enter


To quit Microsoft Access, close a dialog box, or
Alt + F4
close a property sheet

To toggle between breaking and not breaking on
Alt + F5
unhandled errors and then step to the next

statement



To toggle between breaking and not breaking in
Alt + F8
class modules and then continue execution

To select all visible code in the Module window
Ctrl + A
To halt the execution of code or a macro
Ctrl + Break
To move to the current field in the last record, in
Ctrl + Down Arrow


Navigation mode

To display the next procedure
Ctrl + Down Arrow
To move to the last field in the last record, in
Ctrl + End
Navigation mode



To open the selected table, query, form, report,
Ctrl + Enter or Alt + D
macro, or module in Design view

To toggle between a custom menu bar and a built-in  Ctrl + F11

menu bar

To invoke a Builder
Ctrl + F2


To put focus on the Procedure Box
Ctrl + 2 (then press Tab)
To find the next occurrence of selected text
Ctrl + F3
To run code to the current insertion point and halt
Ctrl + F8
execution

To turn on Move mode (MOV appears in the lower
Ctrl + F8


right corner of the window)

To set the next statement
Ctrl + F9
To display the Debug window
Ctrl + G
To move to the first field in the first record, in
Ctrl + Home


Navigation mode

To display quick information
Ctrl + I
To list properties and methods
Ctrl + J
To display the Calls dialog box
Ctrl + L


To move to the current field in the next record
Ctrl + Page Down
To go right one screen
Ctrl + Page Down
To move to the current field in the previous record
Ctrl + Page Up
To go left one screen
Ctrl + Page Up


To select a form or report
Ctrl + R
To return to the last line position in the previously
Ctrl + Shift + F2
viewed procedure

To step out of a procedure
Ctrl + Shift + F8


To clear all breakpoints
Ctrl + Shift +F9
To display parameter information
Ctrl + Shift + I
To list constants
Ctrl + Shift + J
To exit the subform and move to the previous field
Ctrl + Shift + Tab
in the main form or previous record



To complete the Visual Basic keyword
Ctrl + Spacebar
To cycle through the tab of each object's type
Ctrl + Tab
To exit the subform and move to the next field in the  Ctrl + Tab

master form or next record



To move to the current field in the first record, in
Ctrl + Up Arrow
Navigation mode

To display the previous procedure
Ctrl + Up Arrow
To cut the current line and copy it to the Clipboard
Ctrl + Y
To enter the selected item in a list
Ctrl + Enter or Tab


To move down one line
Down Arrow
To move to the current field in the next record
Down Arrow
To move to the last object
End
To move to the last field in the current record, in
End
Navigation mode



To move to the last field in the current record, in
End
Navigation mode

To open the selected report in Print Preview
Enter
To open the selected table or query in Datasheet
Enter


view, or form in Form view

To run the selected macro
Enter
To enter the selected item and move the cursor to
Enter
the next line

To make the list disappear
Esc


To turn off Move mode
Esc
To display context-sensitive Help about the keyword  F1

containing the insertion point

To bring the Database window to the front
F11 or Alt + F1


To rename a selected object
F2
Switch between edit mode (with insertion point
F2
displayed) and navigation mode

To display the complete hyperlink address for a
F2
selected hyperlink











To display the Object Browser
F2
To find the next occurrence of the text specified in
F3
the Find or Replace dialog box when the dialog box



is closed

To switch to Form view from form design or a form
F5
module

To move to the record number box;
F5 then type the record

number and press Enter


To move to the record number box;
F5 then type the record

number and press Enter
To continue execution of code or macro
F5
To run a parameterless subprocedure containing
F5
the insertion point, from the Module window



To switch between the upper and lower portions of
F6
a window (Design view of tables, macros, and

queries and the Advanced Filter/Sort window only)

To switch between the upper and lower panes
F6


To cycle forward through sections
F6
To check spelling
F7
To step into a procedure (single step)
F8
To toggle a breakpoint at the selected line
F9


To move to the first object
Home
To move to the first field in the current record, in
Home
Navigation mode

To move to the first field in the current record, in
Home
Navigation mode



To move the selected column to the left one column  Left Arrow

in Move mode

To move down one window
Page Down
To go down one page; at the end of the record,
Page Down
moves to the equivalent page on the next record



To go down one screen
Page Down
To move up one window
Page Up
To go up one page; at the end of the record, moves  Page Up

to the equivalent page on the previous record

To go up one screen
Page Up


Press Navigating and opening objects Press
Right Arrow
Navigate between fields and records Press To

move columns

To move the selected column to the right one
Shift + Ctrl + Tab


column in Move mode

To cycle through the tab of each object's type right
Shift + Enter
to left

To view a procedure definition, variable, or keyword  Shift + F2

To find the previous occurrence of the text specified  Shift + F3

in the Find or Replace dialog box when the dialog

box is closed



To reset execution of code or macro
Shift + F5
To cycle back through sections
Shift + F6
To step over a procedure
Shift + F8
To create an instant watch for a selected
Shift + F9
expression



To move to the previous field
Shift + Tab
To enter the subform from the following field in the
Shift + Tab
main form

To remove indentation from selected lines
Shift + Tab or Ctrl + Shift



+ M
To move to the previous field
Shift + Tab, or Left Arrow
To move to the next field
Tab
To enter the subform from the preceding field in the  Tab

main form

To indent selected lines
Tab or Ctrl + M
To move to the next field
Tab, Enter, or Right

Arrow
To move up one line
Up Arrow
To move to the current field in the previous record
Up Arrow

No comments

Powered by Blogger.