Add Data To the Database

Select the Data Type

Type it In

Paste Data From Another Source

Import Data from Another Source

Access 2007

Adding Data to the Database

The links on the right will discuss the various ways you can put data into the database.

Before entering data into your table(s), let's review a few basic database rules.

1. Only one kind of data should be stored in a table. For example, if the table contains student contact information, then student class information should be in another table.

2. A field should have only one value. For example, do not put two addresses in the address field.

3. Each field in a table accepts only one type of data. For example, you cannot put text in a number field. When you build your record design for a blank database, you need to consider field type. When using a template, you need to examine the field types and ensure they meet your needs.

The next section discusses data typing.