In T-SQL, you can do this:
SELECT ProductId, COALESCE(Price, 0)
Access supports the Nz function and allows you to use it in a query. Note though that Nz is the same as the T-SQL ISNULL function. It can not take an arbitary number of parameters like COALESCE can.