Microsoft Office Tutorials and References
In Depth Information
Working with a Datasheet Full of Data
Table (discussed next). The Fields tab has buttons that let you add and
rename fields, change a field’s formatting, and settings to validate data.
✦ Table: The second Table Tools tab, Table, has buttons for creating
macros and for viewing relationships and object dependencies.
The two Table Tools tabs — Fields and Table — are available only when you
have a table open in Datasheet view. If you want to do something to the
datasheet that you might otherwise do in Design view, the tool you need
probably is on one of these tabs.
Navigating the data
Moving around in a datasheet is pretty straightforward. Use the vertical scroll
bar (see Figure 1-7) or the Page Up and Page Down keys to move quickly up
and down the datasheet, from record to record. Use the horizontal scroll bar
to move from left to right, and press Enter or Tab to move the cursor from
field to field.
You can use three tools to move around:
✦ Mouse: Click a cell, drag the scroll bars, or click the arrows at the ends
of each scroll bar.
✦ Keyboard: Press Page Up, Page Down, and the other keys listed in