Add Data To the Database

The links in this section 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.