| A | B |
|---|
| table | arrangement of columns and rows |
| entry | single piece of data in a database table |
| field | category of similar information contained in a table |
| record | complete description of all of the fields related to one item in a table |
| text | data identified as text |
| memo | data type used for lenthy entries allowing combinations of text and numbers |
| number | used for data that may be calculated , sorted or filtered |
| date/time | used to arrange and sort data such as the input mask field property |
| currency | format numbers or decimal values with a dollar sign |
| auto number | used to assign a number to each record |
| yes/no | data type that allows a use to select a yes or no value in a database cell |
| lookup wizard | data type used to preset values for database entries |
| field properties | control how data is entered in a field |
| field size | used to control the size of a field that is measured in characters |
| format | used to control the layout of a field, such as decimal places |
| input mask` | regulates how dates are entered in a field |
| caption | used for column naming that allows a more user friendly and properly formatted name |
