An individual piece of data. In Access, you start with a table, and that table contains fields. You can include as many or as few fields as needed. A field has a unique field name, a data type, and a field size. You can also set other elements for the field.
- field caption
Text that you can add to a field that will be used for the field label (rather than the field name) in a form.
- field description
Text that is displayed when that field is selected. You can use a field description to aid in data entry.
- field property
An option that you can set for a field to control how the field appears or works. For instance, you can set the Required property to Yes to require an entry in a particular field.
- field size
The size of the field; different field types have different default sizes. You can change the size as needed.
A method for displaying only a subset of records. You can filter records in a table, form, or query.
- filter expression
Similar to an equation; you can create an expression for comparing and then filtering data—for instance, all products that cost more than $100 (>100).
A method for entering data into the data table. Rather than a large grid that displays many records, you can display and enter data one record at a time.