| A | B |
|---|
| yes/no | data type in toggle format that allows a user to select a yes or no value in a database cell |
| lookup wizard | data type used to define preset values for database entries; increases productivity and accuracy by reducing amount of data entry |
| memo | data type used for lengthy entries that allows combinations of text and numbers |
| currency | data type used to format numbers as decimal values with a dollar sign; default is two decimal places |
| date/time | data type used to arrange and sort data chronologically |
| auto number | used to automatically assign a number to each record and to assist in preventing duplication of data |
| fields | should be formatted in accordance with the data they contain |
| field name | should be short and descriptive |
| data type | defines the value of a cell; used to control how data will be searched |
| text | used for data that will be sorted in alphabetical order or listed randomly |
| number | used for data that may be calculated |
| field property | defines the format of the data within the cell; used to control how data is entered |
| field size | used to control the size of the field; measured in characters |
| format | used to control the layout of the field; such as one or two decimal places |
| input mask | template-like field property that regulates how data is entered in a cell |
| caption | field property used for column naming that allows a more user-friendly and properly formatted field name than in database design |
