How to Add Data to a Microsoft Access Table

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

Things You'll Need

  • Microsoft Access
Show More

Instructions

    • 1

      Launch MS Access and open your database.

    • 2

      Use the F11 key to switch to the database window.

    • 3

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

    • 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

      Click in the first cell in the empty record.

    • 6

      Type the information that should go there.

    • 7

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

    • 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.

Related Searches:

Comments

You May Also Like

Related Ads

Featured