| A | B |
|---|
| Referential integrity | A record is "safe" from being deleted |
| Autonumber | A number assigned automatically to keep records numbered |
| Input Mask | A template of how to enter data - like a phone number |
| One to Many | A relationship where the data in one table connects to data in several other tables |
| Junction Table | Where you can see the actual relationship |
| Field | A category of information notated by a column |
| Record | A group of fields in a row |
| Entry | One piece of data in a database |
| Table | Where data lives in a database |
| Lookup | A dropdown list that prevents having to type in data for a specific entry |
| Memo | Holds up to 64000 characters |
| Yes/No | A selection noted by check boxes |
| Number | This will default to "Long Integer" in the field properties area |
| < | Less than |
| > | Greater than |
| And | Means a search has to meet multiple criteria - fewer results |
| OR | Data can meet only one of two criteria - more results |
| Ascending | A - Z |
| Descending | Z - A |
| Primary Sort | The first field used in a sort |
| Secondary Sort | The second field used in a sort |
| Caption | A field property allowing you to rename a field |
| Primary Key | Required for relationships - ex. Social Security Number |
| Filter by Selection | Selecting data by clicking on an entry |
| Filter by Exclusion | Excluding data by clicking on data that you DO NOT want |
| Currency | Money |
