While I would never use MS Access for an multi-user application there are two features I love about MS Access, the first is the report generator. The report generator is a heck of a lot easier to use then Crystal Report. The second useful feature is the tool you use to build a query, it is easy to build a complex join with multiple tables.
In SQL Server 2005 is there such a tool to visually do joins between multiple tables? I've not seen anything about this but there is so much to learn on 2005 that I may have simply not come across it.
Thanks in advance.