Entering a Record


10 Minute Guide to Microsoft Access 2002
By Joe Habraken
Table of Contents
Lesson 7.  Entering Data into a Table

Entering a Record

After you've created the table and fine- tuned its structure, you are ready to enter data into the table. This means that you should have access to all the data that you need to enter. Then, all you have to do is open the table and input the data records.


Using Forms to Enter Data Access doesn't limit you to entering data directly into the table. You can also enter data using a form. Form creation and data entry using a form are covered in Lesson 13, "Modifying a Form."

First, from the database window, double-click the table in which you want to enter the records. The table opens in the Datasheet view (see Figure 7.1). If this is the first time you have entered data into the table, only one empty record appears in the table. As you complete each record, a new blank record (a new row) appears.

Figure 7.1. A table's existing structure can be edited in the Design view.

To enter records into the table, follow these steps:

  1. Click in the first field of the first blank record (if necessary). If the first field is an identification field, such as Customer ID, and you selected the AutoNumber data type for the field, press Tab to advance to the next field (the AutoNumber field is automatically filled in for you).

  2. Type the value for that field.

  3. Press Tab to move to the next field and enter that field's data.

  4. Continue pressing Tab and entering data until you complete the last field in the record. When you press Tab in the last field, a new record (a new row) appears, and the insertion point moves to the first field in the new record.

  5. Continue entering records as required.


Data Entry Tricks Access offers some hotkey combinations for entering dates and data found in the same field in a previous record. To insert the current date, press Ctrl+; (semicolon). To insert the current time, press Ctrl+: ( colon ). To repeat the value from the same field in the previous record, press Ctrl+' (apostrophe).

You should be aware that, as you enter each field's data and move onto the next field, Access automatically saves your table data. This is very different from other Office applications, such as Word or Excel, where you must save your data after entering it.


10 Minute Guide to Microsoft Access 2002
10 Minute Guide to Microsoft Access 2002
ISBN: 0789726319
EAN: 2147483647
Year: 2000
Pages: 160
Authors: Joe Habraken

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net