Explain the use of the Caption property.
Access uses the contents of the Caption property as the column heading in Datasheet view and as the attached label when you add data-bound controls to forms and reports.
Explain the benefits of indexes.
Indexes improve performance when you're searching, sorting, or grouping on a field or fields.
Explain the difference between the Format property and the Input Mask property.
Whereas the Format property determines how data displays, the Input Mask property determines what data the user can enter in a field.
Explain the difference between field properties and table properties.
Field properties apply to a single field, whereas table properties apply to a table as a whole. By using table properties, for instance, you can compare the contents of one field to the contents of another field.