ACC: Shortcut Keys in Microsoft Access (95/97)

ID: Q140637


The information in this article applies to:
  • Microsoft Access versions 7.0, 97


SUMMARY

This article lists the shortcut keys available in Microsoft Access 7.0 and Microsoft Access 97.


MORE INFORMATION

Global Shortcut Keys


 To                                                      Press
 -------------------------------------------------------------

 Display the Control menu                                ALT+SPACEBAR

 Copy the selection to the Clipboard                     CTRL+C

 Open the Find dialog box                                CTRL+F

 Open the Replace dialog box                             CTRL+H

 Open a new database                                     CTRL+N

 Open an existing database                               CTRL+O

 Paste the contents of the Clipboard at the insertion    CTRL+V
 point

 Cut the selection and copy it to the Clipboard          CTRL+X

 Undo typing                                             CTRL+Z or
                                                         ALT+BACKSPACE

 Display context-sensitive Help about the selected       F1
 menu command, dialog box option, property, control,
 action, keyword, or window

 Display context-sensitive Help using the question mark  SHIFT+F1
 pointer; after pressing SHIFT+F1, move the pointer
 to the item you want help about and click

 Save a database object                                  SHIFT+F12 or
                                                         ALT+SHIFT+F2

 Close the active window                                 CTRL+F4

 Quit Microsoft Access or close a dialog box             ALT+F4

 Cycle between open windows                              CTRL+F6

 Check spelling                                          F7

 Bring the Database window to the front                  F11 or ALT+F1

 Open the Save As dialog box                             F12 or ALT+F2
 

Database Window



 To                                                      Press
 -------------------------------------------------------------

 Move down one line                                      DOWN ARROW

 Move down one window                                    PAGE DOWN

 Move to the last object                                 END

 Move up one line                                        UP ARROW

 Move up one window                                      PAGE UP

 Move to the first object                                HOME

 Open the object in Design view                          CTRL+ENTER or
                                                         ALT+D
 

Datasheet View and Form View Shortcut Keys



 To                                                      Press
 -------------------------------------------------------------

 Switch between Edit mode (with insertion point          F2
 displayed) and Navigation mode

 Open the Zoom box for entering expressions and other    SHIFT+F2
 text in small input areas more conveniently

 Open a combo box or list box                            F4

 Find the next occurrence of the text specified in the
 Find or Replace dialog box when the dialog box is       SHIFT+F4
 closed

 Move to the record number box                           F5

 Switch between the upper and lower portions of a        F6
 window (Design view of tables, macros, and queries
 and the Advanced Filter/Sort window)

 Turn on Extend mode; pressing F8 repeatedly extends     F8
 the selection to the word, the field, the record
 (in Datasheet view only), and all records

 Reverse the F8 selection                                SHIFT+F8

 Cancel Extend mode                                      ESC

 Recalculate the fields in the window                    F9

 Requery the underlying tables; in a subform, this       SHIFT+F9
 requeries the underlying table for the subform only

 Add a new record                                        CTRL+PLUS(+)

 Delete the current record                               CTRL+MINUS(-)

 Save changes to the current record                      SHIFT+ENTER

 Undo changes in the current field or current record;    ESC
 if both have been changed, press ESC twice to undo
 changes first in the current field and then in the
 current record
 

Navigation Shortcut Keys



 To                                                      Press
 -------------------------------------------------------------

 To move to the next field                               TAB, ENTER, or
                                                         RIGHT ARROW

 Move to the last field in the current record            END

 Move to the previous field                              SHIFT+TAB or
                                                         LEFT ARROW

 Move to the first field in the current record           HOME

 Move to the current field in the last record            CTRL+DOWN ARROW

 Move to the last field in the last record               CTRL+END

 Move to the current field in the first record           CTRL+UP ARROW

 Move to the first field in the first record             CTRL+HOME

 Move down one screen                                    PAGE DOWN

 Move up one screen                                      PAGE UP

 Move right one screen                                   CTRL+PAGE DOWN

 Move left one screen                                    CTRL+PAGE UP

 Move down one line in a text box, combo box,            DOWN ARROW
 or list box

 Move up one line in a text box, combo box,              UP ARROW
 or list box

 Move down one set of values in a combo box or list box  PAGE DOWN

 Move up one set of values in a combo box or list box    PAGE UP

 Move to the end of the current line                     END

 Move to the end of the last line                        CTRL+END

 Move to the beginning of the current line               HOME

 Move to the beginning of the first line                 CTRL+HOME

 Move right one column (Datasheet view)                  RIGHT ARROW

 Move to the last column (Datasheet view)                END

 Move left one column (Datasheet view)                   LEFT ARROW

 Move to the first column (Datasheet view)               HOME

 Move the selected column to the right one column        RIGHT ARROW

 Move the selected column to the left one column         LEFT ARROW

 Move down one page (In Form view, when at end of        PAGE DOWN
 record, moves to bottom of next record)

 Move up one page (In Form view, when at top of          PAGE UP
 record, moves to top of previous record)

 Exit the subform and move to the next field in the      CTRL+TAB
 master form; if not in a subform, move to the next
 field

 Exit the subform and move to the previous field in the  CTRL+SHIFT+TAB
 main form; if not in a subform, move to the previous
 field
 

Selection Shortcut Keys



 To                                                      Press
 -------------------------------------------------------------

 Extend the selection or deselect one character          SHIFT+RIGHT
 to the right                                            ARROW

 Extend the selection or deselect one word               CTRL+SHIFT+
 to the right                                            RIGHT ARROW

 Extend the selection or deselect one character          SHIFT+LEFT
 to the left                                             ARROW

 Extend the selection or deselect one word               CTRL+SHIFT+
 to the left                                             LEFT ARROW

 Select the current record or cancel the record          SHIFT+SPACEBAR
 selection (in navigation mode only)

 Select the previous record (if the current record       UP ARROW
 is selected)

 Select the next record (if the current record           DOWN ARROW
 is selected)

 Select the current column or cancel the column          CTRL+SPACEBAR
 selection (in navigation mode only). Applies to
 datasheets and grids, except the grid in a table's
 Design view.
 

Data Entry Shortcut Keys



 To                                                      Press
 -------------------------------------------------------------

 Insert the current date                                 CTRL+;(semicolon)


 Insert the current time                                 CTRL+:(colon)

 Insert the default value for a field                    CTRL+ALT+SPACEBAR


 Insert the value from the same field                    CTRL+' or CTRL+"

 Insert a new line                                       CTRL+ENTER

 Add a new record                                        CTRL++(plus plus)

 Delete the current record                               CTRL+-(plus minus)

 Save changes to the current record                      SHIFT+ENTER

 Toggle the value in a check box or option button        SPACEBAR
 

Print Preview Shortcut Keys



 To                                                      Press
 -------------------------------------------------------------

 Cancel Print Preview                                    C or ESC

 Open the Print dialog box                               P or CTRL+P

 Open the Page Setup dialog box                          S

 Zoom in for a magnified view of part of the page        Z

 Move to the page number box; then, type the page        F5
 number you want to go to and press ENTER

 Move to the next page                                   PAGE DOWN
                                                         or DOWN ARROW

 Move to the previous page                               PAGE UP
                                                         or UP ARROW

 Scroll down in small increments                         DOWN ARROW

 Scroll down in large increments                         PAGE DOWN

 Move to the bottom of the page                          CTRL+DOWN ARROW

 Scroll up in small increments                           UP ARROW

 Scroll up in large increments                           PAGE UP

 Move to the top of the page                             CTRL+UP ARROW

 Scroll to the right in small increments                 RIGHT ARROW

 Move to the right edge of the page                      CTRL+RIGHT
                                                         ARROW or END

 Move to the lower-right corner of the page              CTRL+END

 Scroll to the left in small increments                  LEFT ARROW

 Move to the left edge of the page                       CTRL+LEFT ARROW
                                                         or HOME

 Move to the upper-left corner of the page               CTRL+HOME
 

Module Window Shortcut Keys



 To                                                      Press
 -------------------------------------------------------------

 Halt the execution of code or a macro                   CTRL+BREAK

 Display the previous procedure                          CTRL+UP ARROW

 Display the next procedure                              CTRL+DOWN ARROW

 Display the Debug window                                CTRL+G

 Indent selected lines                                   CTRL+M

 Remove indentation from selected lines                  CTRL+SHIFT+M

 Cut the current line and copy it to the Clipboard       CTRL+Y

 Display context-sensitive Help about the keyword        F1
 containing the insertion point, the selected
 menu command, or dialog box option

 Display the Object Browser                              F2

 View procedure definition                               SHIFT+F2

 View last position                                      CTRL+F2

 Find the next occurrence of the text specified in the   F3
 Find or Replace dialog box when the dialog box is
 closed

 Find the previous occurrence of the text specified in   SHIFT+F3
 the Find or Replace dialog box when the dialog box is
 closed

 Continue execution of code or macro                     F5

 Reset execution of code or macro                        SHIFT+F5

 Switch between the upper and lower panes                F6
 (if you have split the window)

 Step into (single step)                                 F8

 Step over (procedure step)                              SHIFT+F8

 Toggle a breakpoint at the selected line                F9

 Create instant watch for selected expression            SHIFT+F9

 Clear all breakpoints                                   CTRL+SHIFT+F9 


REFERENCES

For more information on the shortcut keys available in Microsoft Access, search the Help Index for "shortcut keys, built-in," or ask the Microsoft Access 97 Office Assistant.

Keywords : kbui UifKeybd
Version : 7.0 97
Platform : WINDOWS
Issue type : kbinfo


Last Reviewed: April 19, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.