A series or collection-based function is one that considers a particular column and performs an operations on all of its cells. http://www.functionx.com/access/Lesson31.htm
A domain-based function is used to get a value from another object and deliver it to the object in which it is being used or called. http://www.functionx.com/access/Lesson32.htm
Microsoft Access provides a series of function destined to perform various types of financially related operations. http://www.functionx.com/access/Lesson34.htm
In this article the guys from SQL Book outline some useful functions that can be used in our SQL queries. http://www.databasedev.co.uk/access-sql-string-functions.html