Text holds letters and numbers not used in calculations.
Number can only hold numbers used in calculations and reports.
Memo can store long texts.
Date/Time a date or time or combination of both.
AutoNumber assigns a number to each record.
OLE Object (object linking and embedding) holds sounds and pictures.
Yes/No for alternative values like true/false, yes/no, on/off, etc.
Hyperlink adds a link to a website