Create a table in access and specify the field type

Creating a table in access generally uses ADO to execute SQL statements to create a table. What is the field type in access in SQL statements? There is an article in msdnArticleDetailed introduction:

Http://msdn.microsoft.com/office/understanding/access/codesamples/default.aspx? Pull =/library/en-US/dnacc2k/html/acintsql. asp

The following is an SQL statement I wrote. It is successfully executed using the adoconnection object in Delphi:
Create Table Test Table (
The text 255 varchar not null,
Text 20 varchar (20) not null,
Datetime,
Number 1 byte,
Number 2 smallint,
Number 4 integer,
Boolean,
Automatically numbered counter (10, 5) Constraint pk_tviplevel26 primary key,
Fractional numeric,
Single precision real,
Double precision float default 0 not null,
Note: memo,
Currency,
OLE object image)

In the access query designer, this statement cannot be executed by default 0;
where: Counter () indicates that the initial value starts from 10 and increases by 5 each time, if there is no (), it starts from 1 and increases by 1 each time;
numeric indicates decimal, you can use numeric () to specify two decimal places;