Them thar Access datatypes:

BINARY
BIT
TINYINT
MONEY
DATETIME(See DOUBLE)
UNIQUEIDENTIFIER
REAL
FLOAT
SMALLINT
INTEGER
DECIMAL
TEXT
IMAGE
CHARACTER (though apparently you're supposed to use CHAR in SQL -RB)

Some day I'll commit 'em to memory, but until then, there they are.

[Update 7/21]

Seems only a few of these "really work". Here's an example SQL statement that I moved from a SQL Server table once it's been Jet-ified.

CREATE TABLE StudentInfo (
[StudentInfoId] COUNTER,
[lastName] CHAR(50) NULL ,
[firstName] CHAR(50) NULL ,
[middleName] CHAR(50) NULL ,
[preferName] CHAR(50) NULL ,
[addressIdaddressId] NUMBER null,
[hPhone] CHAR(50) NULL ,
[sex] INTEGER NULL ,
[dob] date NULL ,
[pobCity] CHAR(50) NULL ,
[pobStateId] integer NULL ,
[religion] CHAR(50) NULL ,
[parish] CHAR(50) NULL ,
[fatherAddressIdrelationInfoId] number NULL,
[motherAddressIdrelationInfoId] number NULL,
[livesWithType] integer NULL ,
[livesWithOther] CHAR(50) NULL ,
[bFatherDead] INTEGER NULL ,
[bMotherDead] INTEGER NULL ,
[bDivorced] INTEGER NULL ,
[bFatherCust] INTEGER NULL ,
[bMotherCust] INTEGER NULL ,
[bJoinCust] INTEGER NULL ,
[prevSchool] CHAR(50) NULL ,
[prevSchoolAddressId] integer NULL ,
[bRepeatGrade] INTEGER NULL ,
[txtWhyRepeat] text NULL ,
[bEval] INTEGER NULL ,
[txtWhyEvaled] text NULL
);