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. |