SQL Var types question

Here is a line of code from a function from an MS Access 2000 DB I am working on.

VB Code:

DoCmd.RunSQL "ALTER TABLE tester ADD Notes memo"

I know I can use VarChar, Int, Currency, and probably others.

Q1. Where can I see a full list of types I can use?
Q2. Failing that any one know what the type is for a Yes/no (boolean) field is?

Don't you have access?

It's YES/NO from the GUI Design View, and in an SQL String that would be BOOLEAN.

VB Code:

'TEXT
        'MEMO
        'LONG
        'TINYINT
        'SMALLINT
        'INTEGER
        'REAL
        'FLOAT
        'DECIMAL
        'DOUBLE
        'COUNTER
        'BIT
        'YESNO
        'DATE

hmm... maybe I had it confused? :(