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 |