I have experienced that this function works great for returning smaller amounts of data from Access databases. I say smaller amounts, but you can also return relatively larger amounts as well. But be warned, as with every Query process, the larger the data, the longer it takes to return the data.
I use this function to create "VLOOKUP()'s" from Access database. It has also come in really handy when creating reference tables for pivot tables and charts as well!