Quiz #15 Flashcards
Field Properities
Characteristics of a field that determine how long an entry can be, how the entry will be formatted, whether there should be a default entry and what can entered
Caption
An alternate, “friendly” name for a field
Input Mask
A field template to validate how each character is entered into a field
Plain Text
A file that contains no formatting or structural codes - only text
Delimiter
The character that separates one field from another in a plain text file
Parent Table
The main table of a relationship
Child Table
The second table of a relationship
Referential Integrity
A property of a relationship between two tables
Subdatasheet
A child table related to the main table
Orphan
A value in the foreign key that does not have a corresponding primary key in the parent table