Chapter 6: Working with Datasheet View
227
FIGURE 6.8The Zoom window. Notice that you can see a lot more of the field’s data — not all 65,536 characters, but
still quite a lot.
Navigating Records in a Datasheet
Wanting to make changes to records after you’ve entered them is not unusual. You might want to
change records for several reasons:l (^) You receive new information that changes existing values.
l You discover errors in existing values.
l (^) You need to add new records.
When you decide to edit data in a table, the first step is to open the table — if it isn’t already open.
From the list of tables in the Navigation Pane, double-click on tblProducts to open it in
Datasheet view. If you’re already in Design view for this table, click the Datasheet View button to
switch views.
When you open a datasheet in Access that has related tables, a column with a plus sign (+) is
added to indicate the related records, or subdatasheets. Click a row’s plus sign to open the sub-
datasheet for the row.
Moving between records
You can move to any record by scrolling through the records and positioning your cursor on the
desired record. With a large table, scrolling through all the records might take a while, so you’ll
want to use other methods to get to specific records quickly.
Use the vertical scroll bar to move between records. The scroll-bar arrows move one record at a
time. To move through many records at a time, drag the scroll box or click the areas between the
scroll thumb and the scroll-bar arrows.