The NZ function will convert a Null value into a value of your choosing.
If is quite useful when you are doing Outer Joins, and the field you are pulling back might not exist because there is no match. So, if you have a formula like this:
NZ([Field1],"No match")
it will return the value of Field1, if it exists. If it doesn't, it will return "No Match".