General shortcut keys
F1
To display the Office Assistant and
Microsoft Access Help; context-sensitive Help about the selected property,
control, macro action, or Visual Basic keyword; or alerts with a Help
button
SHIFT+F1
To display ScreenTips in a dialog
box, after selecting the option by using the keyboard
Opening Database
CTRL+N
To open a new database
CTRL+O
To open an existing database
ALT+F4
To quit Microsoft Access
Printing and Saving
CTRL+P
To print the current or selected
object
P or CTRL+P
To open the Print dialog box
S
To open the Page Setup
dialog box
C or ESC
To cancel Print Preview or Layout
Preview
CTRL+S or SHIFT+F12 or ALT+SHIFT+F2
To save a database object
F12 or ALT+F2
To open the Save As dialog
box
Using combobox or listbox
F4 or ALT+DOWN ARROW
To open a combo box
F9
To refresh the contents of a list box
or combo box
DOWN ARROW
To move down one line
PAGE DOWN
To move down one page
UP ARROW
To move up one line
PAGE UP
To move up one page
TAB
To exit the combo box or list box
Finding or replacing text or data
CTRL+F
To open the Find tab in the Find
and Replace dialog box (Datasheet view and Form view only)
CTRL+H
To open the Replace tab in
the Find and Replace dialog box (Datasheet view and Form view only)
SHIFT+F4
To find the next occurrence of the
text specified in the Find and Replace dialog box when the dialog box is
closed (Datasheet view and Form view only)
Working in Design view
F2
To switch between Edit mode (with
insertion point displayed) and Navigation
mode (Navigation mode: The mode in Microsoft
Access in which an entire field is selected and the insertion point is not
visible. In Navigation mode, you can move between fields by using the arrow
keys.)
F4
To switch to the property sheet
(Design view in forms and reports in databases and Access projects)
F5
To switch to Form view from form
Design view
F6
To switch between the upper and
lower portions of a window (Design view of tables, macros, and queries and the
Advanced Filter/Sort window only)
F7
To switch to the Code Builder from
form or report Design view (Design view window or property sheet)
SHIFT+F7
To switch from the Visual Basic
Editor to form or report Design view
ALT+V+P
To open property sheet for a
selected object
Editing controls in form and report Design view
SHIFT+ENTER
To add a control to a section
CTRL+C
To copy the selected control to the
Clipboard
CTRL+X
To cut the selected control and
copy it to the Clipboard
CTRL+V
To paste the contents of the
Clipboard in the upper-left corner of the selected section
CTRL+RIGHT ARROW
To move the selected control to the
right
CTRL+LEFT ARROW
To move the selected control to the
left
CTRL+UP ARROW
To move the selected control up
CTRL+DOWN ARROW
To move the selected control down
SHIFT+DOWN ARROW
To increase the height of the
selected control
SHIFT+RIGHT ARROW
To increase the width of the
selected control
SHIFT+UP ARROW
To reduce the height of the
selected control
SHIFT+LEFT ARROW
To reduce the width of the selected
control
Window operations
F11
To bring the Database window to the
front
CTRL+F6
To cycle between open windows
ENTER
To restore the selected minimized
window when all windows are minimized
CTRL+F8
To turn on Resize mode for the
active window when it’s not maximized; press the arrow keys to resize the
window
ALT+SPACEBAR
To display the Control menu
SHIFT+F10
To display the shortcut menu
CTRL+W or CTRL+F4
To close the active window
ALT+F11
To switch between the Visual Basic
Editor and the previous active window
ALT+SHIFT+F11
To switch to the Microsoft Script
Editor from the previous active window
Working with Wizards
TAB
Move to the Help button in the wizard
SPACEBAR, with the Help button selected
Show the Assistant in a wizard or
dialog box. To hide the Assistant, press SPACEBAR again. Note that not all wizards
or dialog boxes have Help provided by the Assistant.
ALT+N
To move to the next window in the
wizard
ALT+B
To move to the previous window in
the wizard
ALT+F
To close the wizard window
Note You can not use CTRL+TAB to navigate from one
wizard window to another. CTRL+TAB will move the cursor between dialog
boxes and controls on the wizard window.Miscellaneous
F2
To display the complete hyperlink
address for a selected hyperlink
F7
To check spelling
SHIFT+F2
To open the Zoom box to
conveniently enter expressions and other text in small input areas
ALT+ENTER
To display a property sheet in
Design view
ALT+F4
To quit Microsoft Access, close a
dialog box, or close a property sheet
CTRL+F2
To invoke a Builder
CTRL+F11
To toggle between a custom menu bar
and a built-in menu bar
CTRL+RIGHT ARROW or CRTL+COMMA (,)
To toggle forward between views
when in a table, query, form, report, page, view , PivotTable list,
PivotChart report, stored procedure, or Access project (.adp) function. If
there are additional views available, successive keystrokes will move to the
next available view.
CTRL+LEFT ARROW or CRTL+PERIOD (.)
To toggle back between views when
in a table, query, form, report, page, view, PivotTable list, PivotChart
report, stored procedure, or .adp function. If there are additional views
available, successive keystrokes will move to the previous view
F2
To rename a selected object
DOWN ARROW
To move down one line
PAGE DOWN
To move down one window
END
To move to the last object
UP ARROW
To move up one line
PAGE UP
To move up one window
HOME
To move to the first object
If you need more key comment please
Thanks for visiting blog
No comments:
Post a Comment