| Term | Definition |
|---|
| ISNULL() | function is used to specify how we want to treat NULL values |
| Text | Use for text or combinations of text and numbers. 255 characters maximum |
| Memo | Memo is used for larger amounts of text. Stores up to 65,536 characters. Note: You cannot sort a memo field. However, they are searchable |
| Byte | Allows whole numbers from 0 to 255 1 byte |
| Integer | Allows whole numbers between -32,768 and 32,767 2 bytes |
| Long | Allows whole numbers between -2,147,483,648 and 2,147,483,647 4 bytes |
| Single | Single precision floating-point. Will handle most decimals 4 bytes |
| Double | Double precision floating-point. Will handle most decimals 8 bytes |
| Currency | Use for currency. Holds up to 15 digits of whole dollars, plus 4 decimal places. Tip: You can choose which country's currency to use 8 bytes |
| AutoNumber | AutoNumber fields automatically give each record its own number, usually starting at 1 4 bytes |
| Date/Time | Use for dates and times 8 bytes |
| Yes/No | A logical field can be displayed as Yes/No, True/False, or On/Off. In code, use the constants True and False (equivalent to -1 and 0). Note: Null values are not allowed in Yes/No fields 1 bit |
| Ole Object | Can store pictures, audio, video, or other BLOBs (Binary Large OBjects) up to 1GB |
| Hyperlink | Contain links to other files, including web pages |
| Lookup Wizard | Let you type a list of options, which can then be chosen from a drop-down list 4 bytes |
Combine with other sets
Share on Facebook
Share on MySpace