In this paper, the authors describe a custom relational algebra query software environment that enables database instructors to teach relational algebra programming. Instead of defining query ...

If Access cannot run the entire query on SQL Server, it will run as much as possible on it, and when it retrieves the results set from SQL Server, it will then complete the query locally.