| |
Working
with Records-Moving Around in a Table
When you
are in a table, you will need to move back and forth in the
records to view them or make editing changes. In the table,
like many application programs, the mouse will allow you to
click on any record or field that you want. There are also
some keystrokes that can move you around in a table. These
keystrokes can move you between cells in the table or within
the same cell if you are editing the cell.
| KEYSTROKE
SEQUENCE |
ACTION |
| [ENTER] |
Advances
the active cell one to the right or to the next record
if at end of the record |
| [TAB] |
Same
as [ENTER] key |
| [SHIFT]+[TAB] |
Moves
the active cell back one to the left or to the previous
record if at the beginning of a record |
| Arrow
Keys |
Move
to the next active cell or record in that direction |
| [HOME] |
Moves
to the first field in a record or to the beginning of
the active cell when editing |
| [END] |
Moves to the last field in a record or to the end of the
active cell when editing |
| [CTRL]+[HOME] |
Moves
to the first field in the first record of the table |
| [CTRL]+[END] |
Moves
to the last field in the last record of the table |
| [F5] |
Allows
user to type the record number to go to |
| [SHIFT]+[F2] |
Zooms
in on the active cell to see its contents |
There
are also NAVIGATION BUTTONS at the bottom of the table.
These buttons allow a user to either enter a new record, advance
one record, advance to the end of the table, go back one record,
or go back to the beginning of the table. NOTE: if the mouse
is held down on either button to advance or go back one record,
the active cell will move forward or back several records
rapidly. Near the Navigation buttons, the computer also indicates
the current record number and the number of total records
in the table.

ONE
IMPORTANT NOTE REGARDING TABLES IN A DATABASE
Since
most databases contain hundreds, even thousands, of records,
it is critical that work be saved as often as possible in
case there is a problem with the computer. To that end, Access
has an automatic save feature. A user can enter or edit a
record as often as they wish and still reject the changes
made, provided the active cell remains on the same record.
Once the user moves up or down to another record, the computer
automatically re-saves the database. Any changes made to a
record become permanent.
|