ISNULL() function replaces NULL with a specified value. -- The ISNULL() function returns the replacement if the expression evaluates to NULL. -- Before returning a value, it implicitly converts the ...

You would use Is Null and Is Not Null in query expressions and SQL WHERE clauses. IsNull(), on the other hand, is a Visual Basic for Applications (VBA) function and would be used only in VBA modules.