Home Up Bookstore Site Map Site Search

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 Editing Text or Data

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.

You can use these shortcuts in Table Datasheet or Form view.

Moving the Insertion Point in a Field

If the insertion point isn't visible, press F2 to display it.

To perform this action...

Press...

To move it one character to the right

RIGHT ARROW

To move it one word to the right

CTRL+RIGHT ARROW

To move it one character to the left

LEFT ARROW

To move it one word to the left

CTRL+LEFT ARROW

To move it to the end of the field, in single-line fields

END

To move it to the end of the field, in multiple-line fields

CTRL+END

To move it to the beginning of the field, in single-line fields

HOME

To move it to the beginning of the field, in multiple-line fields

CTRL+HOME

Entering Data in Datasheet or Form View

To perform this action... Press...
To insert the current date CTRL+; (SEMICOLON)
To insert the current time CTRL+SHIFT+: (COLON)
To insert the default value for a field CTRL+ALT+SPACEBAR
To insert the value from the same field in the previous record CTRL+' (APOSTROPHE)
To add a new record CTRL++ (PLUS SIGN)
To delete the current record CTRL+- (MINUS SIGN)
To save changes to the current record SHIFT+ENTER
To switch between the values in a check box or option button SPACEBAR
To insert a new line CTRL+ENTER

Refreshing Fields with Current Data

To perform this action... Press...
To recalculate the fields in the window F9
To requery the underlying tables; in a subform, this requeries the underlying table for the subform only SHIFT+F9
To refresh the contents of a Lookup field, list box, or combo box F9

Copying, Moving, and Deleting Text

To perform this action...

Press...

To copy the selection to the Clipboard

CTRL+C

To cut the selection and copy it to the Clipboard

CTRL+X

To paste the contents of the Clipboard at the insertion point

CTRL+V

To delete the selection or the character to the left of the insertion point

BACKSPACE

To delete the selection or the character to the right of the insertion point

DELETE

To delete all characters to the right of the insertion point

CTRL+DELETE

Undoing Changes

To perform this action...

Press...

To undo typing

CTRL+Z or ALT+BACKSPACE

To 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)

Go Back to the Top of the Page


Home ] 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 ]

Send mail with questions or comments about this web site to our webmaster.
Last modified: June 05, 2004

Labelled with ICRA