<div>
Yes, query designer, get into Management Studio, open a create a new query window and press button &quot;Design Query in Editor&quot;
</div>


<div>
Glad I could be of any help !
</div>


<div>
<div class="content wysiwyg-content">
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. &nbsp;The report generator is a heck of a lot easier to use then Crystal Report. &nbsp;The second useful feature is the tool you use to build a query, it is easy to build a complex join with multiple tables.<br />
<br />
In SQL Server 2005 is there such a tool to visually do joins between multiple tables? &nbsp;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.<br />
<br />
Thanks in advance.
</div>
</div>


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.

Yes, query designer, get into Management Studio, open a create a new query window and press button &quot;Design Query in Editor&quot;

Does SQL Server 2005 have a query designer tool similiar to MS Access?

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&#39;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.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.