Chances are, you plan to store many different types of information in your database tables—names, dates, product IDs, financial information, and so on. That's where data types come in; they enable you to specify what type of data a particular field contains. For example, you use the Text data type for fields that contain text (such as names) ; likewise, you use the Number data type for fields that contain numbers (such as product IDs, telephone numbers, and so on) . For dates, you use the Date/Time data type, and for monetary values, you use the Currency data type. Other data types include Memo, AutoNumber, Yes/No, OLE Object, and Hyperlink; you'll learn about some of these in Part 4. |