This is described in the SAS/ACCESS documentation, please dig in there.
In short, most ACCESS interfaces with relational data source support push down (or implicit SQL pass through) of joins, order by, BY, group by, WHERE and a selection of functions. There are also a couple of SAS PROCs that have been pass through enabled, such as FREQ and SUMMARY.
Data never sleeps