| Q1: | Explain the use of the Caption property. |
|
A1:
| 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. |
| Q2: | Explain the benefits of indexes. |
|
A2:
| Indexes improve performance when you're searching, sorting, or grouping on a field or fields. |
| Q3: | Explain the difference between the Format property and the Input Mask property. |
|
A3:
| Whereas the Format property determines how data displays, the Input Mask property determines what data the user can enter in a field. |
| Q4: | Explain the difference between field properties and table properties. |
|
A4:
| 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. |
