ACCC Seminars

Welcome
Database Concepts
Creating a Database
Working with Records
Creating Tables
Queries
Forms
Reports
Related Links

Handout (PDF)
ACCC Seminars
Rev. Oct 3/2001

Access 2000 Introduction


 

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.


Back to TopCreating a Database Creating a Database Adding and Deleting Records Creating Tables
   

Seminar materials: <http://www.accc.uic.edu/seminars/access2000-intro>
Last Modified: October 3, 2001 — pjm