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 |
