In access using a single table for getting complicated queries , it is not uncommon to see loads of temporary queries.
However in SQL server you have the feature of "Derived tables" which are basically SQL Selects embedded / named and reused in a larger query. You can still use views ( Stored queries in SQL Server) for performance benefits but to keep things clean don't make too many views if they are just going to be a part of some cooler query and you think that views help understand better. They don't (generally they just get cluttered) and derived tables are so much cooler :).
Sql query inside an sql query for peace of mind :) and you know immediately how its being used.
Read more here :