Access - Ch 2 Flashcards
Unnecessary storing of duplicate data in 2+ tables
Data Redundancy
Determines types of data that can be entered
Data Type
Same as a Primary Key from a different table
Foreign Key
Determine how the field looks & behaves
Field Properties
Used to create a label that is more understandable
Caption Property
Determines maximum # of characters in the field area
Field Size
Changes the way a field is displayed
Format
Simplifies data by providing literal characters that are typed for every entry
Input Mask
Automatically predefined value for each field
Default Value
Requires that data entered must conform to specified rule
Validation Rule
Specifies the error message that displays when rule is violated
Validation Text
Indicates that value is necessary for the record
Required
Used for calculated field only
Expression
Used for calculated fields only
Result Type
Enforces rules in database that are used to preserve relationships between tables
Referential Integrity
PK table must only have 1 occurrence of each value, can match multiple FK values in related field
One-to-Many Relationship type
Used to set rules to determine which records will be selected
Criteria Row
Special characters that can represent one or more characters in text value
Wildcards
Enable you to limit the query results to those meeting the criterion only
Comparison Operators
Blank field
Null
Contain 2+ tables, enable you to take advantage of the relationships that have been set in database
Multitable Queries
