Well, it depends on your situation. We started with SQL Server 4.7 and Access 2.0, and at that point the query tools in Access were much more friendly than the tools for creating sprocs. Over time that has changed with both products, but for simple queries, Access is good quick tool with the query designer. However it isn't likely to be as efficient as a query in SQL Server. We found that an excellent tool was to create indexed views in SQL Server, so that the ODBC driver converted the Access Queries to SQL syntax, and delivered excellent performance. Truth be told, I think it depends on which tool you learned first. We learned both at the same time, and have a foot in both camps. :unsure:
You can't see the view if you don't climb the mountain!