| Office XP Access 2002, 2/e Timothy O'Leary,
Arizona State University
Controlling Data Input, Using Advanced Queries, and Enforcing Referential Integrity
ConceptsThe 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 filed 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.
|
|