Access 2003 Shortcut Keys
[Keys for General Use] [Keys for Use in the Database Window] [Keys for Navigating Records] [Keys for Selecting Text or Data] [Keys for Editing Text or Data] [Keys for Working in Print Preview and Layout Preview] [Keys for Working in the Query Designer in an Access Project] [Keys for Working with PivotTable and PivotChart Views]
Keys for General Use
All shortcut keys are based on the U.S. keyboard layout. Keys on other layouts may not correspond exactly to the keys on a U.S. keyboard.
For keyboard shortcuts in which you press two or more keys together, the keys to press are separated by a plus sign,
like this: SHIFT+F10.
For shortcuts in which you press keys one after the other, the keys to press are separated by a comma,
like this: ALT, F, X.
Displaying and Using Windows
|
To perform this action... |
Press... |
|
To bring the Database window to the front |
F11 |
|
To cycle between open windows |
CTRL+F6 |
|
To restore the selected minimized window when all windows are minimized |
ENTER |
Opening Database Files
|
To perform this action... |
Press... |
|
To open a new database |
CTRL+N |
|
To open an existing database |
CTRL+O |
|
To quit Microsoft Access |
ALT+F4 |
Printing and Saving
|
To perform this action... |
Press... |
|
To print the current or selected object |
CTRL+P |
|
To open the Print dialog box |
CTRL+P |
|
To open the Page Setup dialog box from Print Preview |
S |
|
To open the Print dialog box from Print Preview |
P |
|
To cancel Print Preview or Layout Preview |
C or ESC |
|
To save a database object |
CTRL+S or SHIFT+F12 or ALT+SHIFT+F2 |
|
To open the Save As dialog box |
F12 or ALT+F2 |
Using Combo Boxes and List Boxes
|
To perform this action... |
Press... |
|
To open a combo box |
F4 or ALT+DOWN ARROW |
|
To refresh the contents of a Lookup field, list box, or combo box |
F9 |
|
To move down one line |
DOWN ARROW |
|
To move down one page |
PAGE DOWN |
|
To move up one line |
UP ARROW |
|
To move up one page |
PAGE UP |
|
To exit the combo box or list box |
TAB |
Finding and Replacing Text or Data
|
To perform this action... |
Press... |
|
To open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only) |
CTRL+F |
|
To open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only) |
CTRL+H |
|
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) |
SHIFT+F4 |
Working in Design View
|
To perform this action... |
Press... |
|
To switch between Edit mode (with insertion point displayed) and Navigation mode (where the entire field is selected and the insertion point is not visible). |
F2 |
|
To switch to the property sheet (Design view in forms and reports in databases and Access projects) |
F4 |
|
To switch to Form view from form Design view |
F5 |
|
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) |
F6 |
|
To switch to the Code Builder from form or report Design view (Design view window or property sheet) |
F7 |
|
To switch from the Visual Basic Editor to form or report Design view |
SHIFT+F7 |
|
To open property sheet for a selected object |
ALT+V, P |
Editing Controls in Form and Report Design View
|
To perform this action... |
Press... |
|
To add a control to a section |
SHIFT+ENTER |
|
To copy the selected control to the Clipboard |
CTRL+C |
|
To cut the selected control and copy it to the Clipboard |
CTRL+X |
|
To paste the contents of the Clipboard in the upper-left corner of the selected section |
CTRL+V |
|
To move the selected control to the right |
CTRL+RIGHT ARROW |
|
To move the selected control to the left |
CTRL+LEFT ARROW |
|
To move the selected control up |
CTRL+UP ARROW |
|
To move the selected control down |
CTRL+DOWN ARROW |
|
To increase the height of the selected control |
SHIFT+DOWN ARROW |
|
To increase the width of the selected control |
SHIFT+RIGHT ARROW |
|
To reduce the height of the selected control |
SHIFT+UP ARROW |
|
To reduce the width of the selected control |
SHIFT+LEFT ARROW |
Working with Wizards
|
To perform this action... |
Press... |
|
To move to the Help button in the wizard |
TAB |
|
To move to the next window in the wizard |
ALT+N |
|
To move to the previous window in the wizard |
ALT+B |
|
To close the wizard window |
ALT+F |
Note: You can't use CTRL+TAB to navigate from one wizard window to another (CTRL+TAB moves the cursor between dialog boxes and controls on the wizard window).
Sending E-Mail Messages
|
To perform this action... |
Press... |
|
To send the active database object as an e-mail message |
ALT+F, D, A |
|
To open the Address Book |
CTRL+SHIFT+B |
|
To check the names in the To, Cc, and Bcc boxes against the Address Book |
ALT+K |
|
To select the next box in the e-mail header or the body of the message when the last box in the e-mail header is active |
TAB |
|
To select the previous field or button in the e-mail header |
SHIFT+TAB |
Miscellaneous
|
To perform this action... |
Press... |
|
To display the complete hyperlink address for a selected hyperlink |
F2 |
|
To check spelling |
F7 |
|
To open the Zoom box to conveniently enter expressions and other text in small input areas |
SHIFT+F2 |
|
To display a property sheet in Design view |
ALT+ENTER |
|
To quit Microsoft Access, close a dialog box, or close a property sheet |
ALT+F4 |
|
To invoke a Builder |
CTRL+F2 |
|
To toggle between a custom menu bar and a built-in menu bar |
CTRL+F11 |
|
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+RIGHT ARROW or CRTL+, (COMMA) |
|
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) |
CTRL+LEFT ARROW or CRTL+. (PERIOD) |
