The following concepts will be introduced in this lab:
- Input Mask: An input mask is a field property that controls where data is entered in a field, the kind of data, and the number of allowable characters.
- Lookup field: A lookup field provides a list of values from which the user can choose to enter data into that field.
- Copy and Import: Selections can be copied or duplicated to new locations in a database, between databases, or to other applications; or imported from another application and converted into a format that can be used in a table.
- Required Property: The Required property specifies whether a value is required in a field.
- Calculated Field: A calculated field displays the result of a calculation in a query.
- Crosstab query: A crosstab query summarizes table data and displays it in a tabular format.
- Relationship: A relationship establishes the association between common fields in two tables.
- Subdatasheet: A subdatasheet is a data table that is nested in another data table and that contains data related or joined to the table where it resides.