Access 2003
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, while others contain numbers. These field properties are defined when the table is created.