Navigating through a table to edit records

Whether you edit your records through a Datasheet or a form, there is, as usual, a variety of ways to do it.  As far as your user is concerned, you should make it as straightforward and uncomplicated as possible:  for the user, there should only be one right way. 

Many editing operations first involve selection.  To replace a field, you first select it and then type in the new value. 

The gray area to the left of each record in the Datasheet is called the record selector.  The following symbols indicate the status of the record:

Current record. 

Record is selected. 

Record is being edited.

Last (empty) record.

To move to a field using the mouse

·         Move the mouse pointer over the required field and click.  The pointer changes shape depending on the field type.  

Note:  If you click in the leftmost position in the field, the whole field is selected.

To move through the table using the keyboard

·         To move from field to field and record to record, use one of the following methods:

Press this:

To move:

Tab

to the next field

Shift+Tab

to the previous field

Home

to the first field of the current record

End

to the last field of the current record

â

to the next record

á

to the previous record

Ctrl+Home

to the first field of the first record

Ctrl+End

to the last field of the last record

Page Up

scroll up one page

Page Down

scroll down one page

To move from record to record using the scroll bar and mouse

·         To move from record to record:  

Click on this:

To move:

to the next record

to the previous record

to the last record

to the first record

To move to a specific record using the Edit menu

·         Choose Go To from the Edit menu and select First , Last , Next , Previous or New Record .

To move to a specific record using the keyboard

·         Press F5 to highlight the record number on the scroll bar.

·         Type the number of the record you want.

·         Press Enter .