Access 2000
Database Tables
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. Others contain numbers. These Field Properties are defined when the table is created.