McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Data Files
Buzz in IT
Updates
Concepts
Flashcards
Multiple Choice Quiz
Puzzlers
Feedback
Help Center


Office XP Access 2002
Office XP Access 2002, 2/e
Timothy O'Leary, Arizona State University

Controlling Data Input, Using Advanced Queries, and Enforcing Referential Integrity

Concepts

The following concepts will be introduced in this lab:
  1. 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.
  2. Lookup Field: A lookup field provides a list of values from which the user can choose to enter data into that field.
  3. 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.
  4. Required property: The Required property specifies whether a value is required in a field.
  5. Calculated Field: A calculated filed displays the result of a calculation in a query.
  6. Crosstab Query: A crosstab query summarizes table data and displays it in a tabular format.
  7. Relationship: A relationship establishes the association between common fields in two tables.
  8. 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.