Field objects define a specific field (sometimes referred to as a column). TableDef, QueryDef, Index, Relation, and Recordset objects all contain Fields collections. The following table explains the Field object’s representation for each type of object that can contain a Fields collection.
| Object | Description of Fields collection |
| TableDef | Defines the fields in a table, but doesn’t contain data. |
| QueryDef | Defines the fields in a query, but doesn’t contain data. |
| Index | Defines the characteristics of the fields that make up an index in the context of the information the index must maintain about the field. |
| Relation | Defines the characteristics of the fields that make up a relationship in the context of the information the relationship must maintain about the field. |
| Recordset | Defines the fields that exist in the tables or queries that the recordset is based on. Contains data in the field’s Value property. |