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'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.
prgManAsked:
Who is Participating?
 
YveauConnect With a Mentor Commented:
yes there is !
open a table from the object explorer, and a query designer toolbar shows up.
Here is your Access like GUI !

Hope this helps ...
0
 
ptjcbConnect With a Mentor Commented:
There is a Query Designer.

Select a database. Click New Query. In the blank window, right-click and select Design Query in Editor
0
 
fmonroyCommented:
Yes, query designer, get into Management Studio, open a create a new query window and press button "Design Query in Editor"
0
 
Patrick MatthewsConnect With a Mentor Commented:
prgMan said:
>>While I would never use MS Access for an multi-user application

Never?  I don't think I'd go that far.  For a relatively small number of simultaneous users (say,
<50) going over a LAN, a properly built Access app can work just fine.

>>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.

You can use Access to link to the SQL Server 2005 db, then use Access's more friendly
query and report designers...

>>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.

SQL Server 2000's Enterprise Manager had a somewhat similar tool for designing views; in some
respects it was even better than Access's designer for SELECT queries, as you could see the
GUI and the SQL at the same time.  The big drawback, of course, is that since it's limited to
views, you do not get the UPDATE, INSERT, or DELETE capabilities.

I do not have SS 2005 installed, but there must be something analagous in the design studio...
0
 
YveauCommented:
Glad I could be of any help !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.