Ok, this maybe a really stupid question..

Operating on a split database..

If I have a table with a bunch of values, say Department names for example.

If I create a query and fill it with the contents of the Departments table, does references to that Departments query access the backend at all?
This is of course only when values are being read and not written to..

cheers

Queries return data from tables. The table is accessed each time the query is run.