Database Tables

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

Field properties

Each table contains a number of columns called fields or data types. 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