![]() 1 byte OLE Object Pictures, graphs, or other ActiveX objects from another Windowsbased application. Yes/No Boolean (true/false) data Access stores the numeric value zero (0) for false, and -1 for true. ![]() Table-1 Access Data Types Data Type Usage Size Text Alphanumeric data Up to about 1 gigabyte (GB), but controls to display a memo are limited to the first 64,000 characters Memo Numeric data 1, 2, 4, 8, or 16 bytes Number Dates and times 8 bytes Data/Time 4 bytes (16 bytes for ReplicationID) 8 bytes Currency Monetary data, stored with 4 decimal places of precision 8 bytes AutoNumber Unique value generated by Access for each new record. Help you define the characteristics of foreign key fields that link to other tables. Access also gives you a 12th option, Lookup Wizard, to You can see the detailsĪbout each data type in Table-1. Access 2010 supports 11 types of data, each with a specific purpose.
0 Comments
Leave a Reply. |