| A | B |
|---|
| Application Parts | A gallery that you can use to insert predefined templates consisting of objects like tables, forms, and reports into a preexisting database. |
| Quick Start | A collection of predefined objects that you can add to your database, arranged by parts for tracking things such as comments, contacts, and issues. |
| Template | A ready-to-use database that contains all of the tables, queries, forms, and reports needed for performing a specific task. |
| Ascending | A sort order that sorts data from beginning to end. |
| 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 alphabetically, numerically, or chronologically. |
| Wildcard | A character used to find words or phrases that contain specific letters or combinations of letters. |
| Input mask | A set of placeholder characters that forces users to enter data in a specific format. |
| Multivalued lookup field | A field that allows you to select more than one value from a list. |
| Properties | Controls the appearance or behavior characteristics for objects and related parts like fields and controls. |
| Quick Start field | A predefined set of characteristics and properties that describes a field, including a field name, a data type, and a number of other field properties. |
| Validation rule | An expression that limits the values that can be entered in the field. |
| Validation text | The text in the error message that appears when users violate a validation rule. |
| Zero-length string | A string that contains no characters and is used to indicate that you know no value exists for a field. |
