How To

How to Add Data to a Microsoft Access Table

Contributor
By eHow Contributing Writer
(7 Ratings)

This is how you get your information into a database table you've set up. These instructions work for Access 97.

Difficulty: Moderately Easy
Instructions

Things You'll Need:

  1. Step 1

    Launch MS Access and open your database.

  2. Step 2

    Use the F11 key to switch to the database window.

  3. Step 3

    Click on the Table tab. A list of tables appears.

  4. Step 4

    Select the table that you want to use, then click Open. The table appears. Each horizontal row represents one record. Each column in the row represents a field in the record.

  5. Step 5

    Click in the first cell in the empty record.

  6. Step 6

    Type the information that should go there.

  7. Step 7

    Move from one horizontal column to the next by using the Tab key or by clicking in the column.

  8. Step 8

    When one record is complete, a new, blank record will automatically appear at the bottom of the rows.

Tips & Warnings
  • In Access, a database is made up of various "tables," but each table is probably what you'd think of as a "database" - it's a collection of records.
  • If you created a form for entering data, you will have the choice between entering your data through a form or directly into a table.

Post a Comment

Post a Comment
  • Have you done this? Click here to let us know.
I Did This

Related Ads

Computers
Alexia Petrakos,

Meet Alexia Petrakos eHow's Computers Expert.

Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US

eHow Computers
eHow_eHow Technology and Electronics