click below
click below
Normal Size Small Size show me how
Vocabulary
Access Lesson 3
Term | Definition |
---|---|
Ascending | A sort order that sorts data from beginning |
Composite Key | Two or more primary keys used in a table |
Descending | A sort order that sorts data from the end to the beginning, such as Z to A or 99 to 0 |
Filter | A set of rules for determining which records will be displayed |
Foreign Key | A primary key from one table that is used in another table |
Innermost Field | A secondary sort field in a multifield sort |
Outermost Field | The primary sort field in a multifield sort |
Referential Integrity | A rule that prevents orphaned records |
Sort | To arrange data alphabetic, numerically, or chronologically |
Wildcard | A character used to find words or phrases that contain specific letters or combinations of letters |