If you have ever looked at the cfqueryparam data type matrix you will notice MS Access is conspicuously absent. Yes, I know its not a supported database, but it has its place.
Anyway, I took a stab at merging the matrix from livedocs and a comparison between data types in Access and SQL Server on MS technet. I have not tested all of the types yet so no guarantees on accuracy.
ColdFusion Jet MSSQL CF_SQL_BIT Yes/No bit CF_SQL_DECIMAL Decimal, Currency decimal, money, small money CF_SQL_FLOAT Double float CF_SQL_INTEGER Long Integer int CF_SQL_LONGVARBINARY OLE Object image CF_SQL_LONGVARCHAR Memo text, ntext CF_SQL_MONEY Double CF_SQL_REAL Single real CF_SQL_SMALLINT Integer smallint CF_SQL_TIMESTAMP Date/Time datetime, smalldate time CF_SQL_TINYINT Byte tinyint CF_SQL_VARCHAR Text varchar, nvarchar, sysname