Database Tables

Learn how to read, manipulate, and create Access 2003 database tables in this free lesson.

Field properties

Every table contains a number of columns called fields or datatypes. Fields are unique pieces of information that make up the information in a table. Tables usually contain multiple fields.

In a previous example, we mentioned that a table might consist of the fields Last Name, First Name, Phone, Address, City, State, and Zip. Each field has unique properties. Some contain characters, while others contain numbers. These field properties are defined when the table is created.

Field Properties