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-Adding and Deleting Records

The only location where a new record can be added to a table is at the end of the table. It is usually very easy to reach the end of the table unless the table has thousands of records in it. The end of a table can be reached instantly by clicking on the New button on either the toolbar or at the bottom of the table. When you add a record, like editing records, you can cancel the changes provided the active cell stays on the record. Once it moves off, the computer saves the database.

There are a couple of keyboard shortcuts to make data entry faster:

KEYSTROKE SEQUENCE ACTION
[CTRL] + ['] Inserts the same value as the cell directly above it (Duplicate Command)
[CTRL] + [;] Inserts the current date into the cell
[CTRL] + [SHIFT] + [:] Inserts the current time into the cell
[CTRL] + [ALT] + [SPACEBAR] Inserts the default value of the field into the cell

Deleting Records

If there are records that need to be deleted, you have the ability to select one or several rows of records. To do this, place your pointer in the row selector boxes to the left of the record(s) to be deleted, then click (or click-and-drag) so that those rows are highlighted. Then, simply hit the [DELETE] key on your keyboard. NOTE: Delete operations CANNOT be undone. The computer will prompt you to verify you want the records deleted.


Back to TopCreating a Database Moving around in a Table Editing Records Creating Tables
   

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