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 Navigating Records

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.

[Navigating in Datasheet View] [Navigating in Subdatasheets] [Navigating in Form View] [Navigating in Design View]

Navigating in Datasheet View

Going to a Specific Record

To perform this action...

Press...

To go to a specific record by using the record number box

F5, then type the record number and press ENTER

Moving between Fields and Records

To perform this action...

Press...

To move to the next field

TAB or RIGHT ARROW

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

END

To move to the previous field

SHIFT+TAB, or LEFT ARROW

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

HOME

To move to the current field in the next record

DOWN ARROW

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

CTRL+DOWN ARROW

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

CTRL+END

To move to the current field in the previous record

UP ARROW

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

CTRL+UP ARROW

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

CTRL+HOME

Moving to Another Screen of Data

To perform this action...

Press...

To go down one screen

PAGE DOWN

To go up one screen

PAGE UP

To go right one screen

CTRL+PAGE DOWN

To go left one screen

CTRL+PAGE UP

Go Back to the Top of the Page

Navigating in Subdatasheets

You can navigate between fields and records in a subdatasheet with the same shortcut keys you use in Datasheet View.

Going to a Specific Record
To perform this action... Press...
To go to a specific record by using the record number box from the subdatasheet F5, then type the record number and press ENTER
Expanding and Collapsing Subdatasheets

To perform this action...

Press...

To expand the record�s subdatasheet from the datasheet

CTRL+SHIFT+DOWN ARROW

To collapse the subdatasheet

CTRL+SHIFT+UP ARROW

Navigating between Datasheets and Subdatasheets

To perform this action...

Press...

To enter the subdatasheet from the last field of the previous record in the datasheet

TAB

To enter the subdatasheet from the first field of the following record in the datasheet

SHIFT+TAB

To exit the subdatasheet and move to the first field of the next record in the datasheet

CTRL+TAB

To exit the subdatasheet and move to the last field of the previous record in the datasheet

CTRL+SHIFT+TAB

To enter the next field in the datasheet from the last field in the subdatasheet

TAB

To bypass the subdatasheet and move to the next record in the datasheet

DOWN ARROW

To bypass the subdatasheet and move to the previous record in the datasheet

UP ARROW

Go Back to the Top of the Page

Navigating in Form view

Going to a Specific Record

To perform this action...

Press...

To go to a specific record by using the record number box

F5, then type the record number and press ENTER

Navigating between Fields and Records

To perform this action...

Press...

To move to the next field

TAB

To move to the previous field

SHIFT+TAB

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

END

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

CTRL+END

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

HOME

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

CTRL+HOME

To move to the current field in the next record

CTRL+PAGE DOWN

To move to the current field in the previous record

CTRL+PAGE UP

Navigating in Forms with More than One Page

To perform this action...

Press...

To go down one page (at the end of the record, to move to the equivalent page on the next record)

PAGE DOWN

To go up one page (at the end of the record, to move to the equivalent page on the previous record)

PAGE UP

Navigating between Main Forms and Subforms

To perform this action...

Press...

To enter the subform from the preceding field in the main form

TAB

To enter the subform from the following field in the main form

SHIFT+TAB

To exit the subform and move to the next field in the master form or next record

CTRL+TAB

To exit the subform and move to the previous field in the main form or previous record

CTRL+SHIFT+TAB

Go Back to the Top of the Page

Navigating in Design View

To perform this action... Press...
To switch between Edit mode (with insertion point displayed) and Navigation mode 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 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 invoke the field list in a form, report, or data access page (If field list is already open, to move focus to field list) F8
To switch from the Visual Basic Editor to form or report Design view SHIFT+F7
To switch from a control's property sheet in form or report Design view to the design surface without changing the control focus SHIFT+F7
To display a property sheet in Design view ALT+ENTER
To open the selected form in Form view ENTER or ALT+O
To open the selected table, query, form, report, data access page, macro, or module in Design view CTRL+ENTER or ALT+D
To move the focus to a subsection when focus is set to a section CTRL+TAB
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 by a pixel along the page's grid RIGHT ARROW
To move the selected control to the left by a pixel along the page�s grid LEFT ARROW
To move the selected control up by a pixel along the page�s grid UP ARROW
To move the selected control down by a pixel along the page�s grid DOWN ARROW
To move the selected control to the right by a pixel (irrespective of the page�s grid) CTRL+RIGHT ARROW
To move the selected control to the left by a pixel (irrespective of the page�s grid) CTRL+LEFT ARROW
To move the selected control up by a pixel (irrespective of the page�s grid) CTRL+UP ARROW
To move the selected control down by a pixel (irrespective of the page�s grid) CTRL+DOWN ARROW
To increase the width of the selected control (to the right) by a pixel SHIFT+RIGHT ARROW
To decrease the width of the selected control (to the left) by a pixel SHIFT+LEFT ARROW
To decrease the height of the selected control (from the bottom) by a pixel SHIFT+UP ARROW
To increase the height of the selected control (from the bottom) by a pixel SHIFT+DOWN ARROW
To move the focus from the page design surface to the address/subject dialog box when sending a page as an e-mail SHIFT+TAB
To move the focus from the Field List or Data Outline back to the data access page design surface ESC

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