| Word | Description |
| List Item Field | This is a database field that may only contain one of a fixed number of possible values. Examples would include: Transaction Type, Status, Account Type, Vendor Type. |
| ODBC | Open Database Connectivity (ODBC) provides a standard means for software applications to access data stored in databases of various types. |
| Query Table | This is a range of cells in an Excel worksheet where the cell values come from an underlying database query. The range of cells contains one or more columns and the number of rows may increase or decrease when the unerlying query is refreshed. |
| SQL | Structured Query Language. This is a standard language used by software applications to query, modify, and delete data contained within databases. |
| Worksheet Function | Worksheet functions in Excel can be included within formula cells to carry out mathematical calculations, text manipulation, date logic, and more. Functions may include zero or more input values (known as arguments) that are enclosed in parentheses following the function name. A function typically returns a result that is useful to the end-user or as an argument to another function. Examples of built-in Excel functions include SUM, SUMIF, SUBTOTAL, IF, VLOOKUP. |