Access Shortcut Keys: Keys for Working in Datasheet View

Access 97/2000 Shortcut Keys

[Keys for general Use] [Keys for Use in the Database Window] [Keys for Selecting Text or Data] [Keys for Editing Text or Data] [Keys for Working in Datasheet View] [Keys for Moving Around in Form View] [Keys for Working in Print Preview and Layout Preview]

Keys for Working in Datasheet View

Go to a specific record

To	Press
Move to the record number box	F5, then type the record number and press ENTER

Move between fields and records

To	Press
Move to the next field	TAB, ENTER, or RIGHT ARROW
Move to the last field in the current record, in Navigation mode	END
Move to the previous field	SHIFT-TAB, or LEFT ARROW
Move to the first field in the current record, in Navigation mode	HOME
Move to the current field in the next record	DOWN ARROW
Move to the current field in the last record, in Navigation mode	CTRL-DOWN ARROW
Move to the last field in the last record, in Navigation mode	CTRL-END
Move to the current field in the previous record	UP ARROW
Move to the current field in the first record, in Navigation mode	CTRL-UP ARROW
Move to the first field in the first record, in Navigation mode	CTRL-HOME

Move to Another Screen of Data

To	Press
Go down one screen	PAGE DOWN
Go up one screen	PAGE UP
Go right one screen	CTRL-PAGE DOWN
Go left one screen	CTRL-PAGE UP

Move Columns

To	Press
Turn on Move mode	CTRL-F8 (MOV appears in the lower right corner of the window)
Move the selected column one column to the right	RIGHT ARROW (in Move mode)
Move the selected column one column to the left	LEFT ARROW (in Move mode)
Turn off Move mode	ESC

Go Back to the Top of the Page

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

This site was created and is managed with Microsoft FrontPage