1-866-245-5224 sales@keystonelearning.com

Access 2003: Exploring Datasheet View

Access 2003: Exploring Datasheet View


Once you spend any amount of time in Access, you’ll discover that the bulk of your setup work will be done in tables and in Datasheet View.



Datasheet View is the name of the view you’re in when entering and editing your data. In Datasheet view, you can get a good look at the records (rows), fields (columns) and values (cells).

In Datasheet view, you can quickly navigate through your records and fields using both your keyboard and your mouse.



Navigating in Datasheet View

Mastering the art of navigation will allow you to complete your work faster. To aid in this, you’re going to learn navigation by using both the mouse and keyboard.

Using the Record Selectors

Record selectors appear at the bottom of each of your tables and help you to move from record to record in Datasheet view. In fact, you’ll see these same commands in Form view. Plus, you can use the last button on the Record Selector Toolbar to add a new record to the open table.


Figure 15. Record Selector Toolbar

Using the Keyboard

To Move…


Up One Cell

Up Arrow

Down One Cell

Down Arrow

Right One Cell

Tab or Right Arrow

Left One Cell

[SHIFT]+Tab or Left Arrow

Up One Screen of Information

Page Up

Down One Screen of Information

Page Down

End of Record Data


Beginning of Record Data


First Value in Table


Last Value in Table