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

Access 2007: Exploring Datasheet View

Access 2007: 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 20. 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