Query Designers and Creators

Zack
Zack used Ask the Experts™
on
Heyas,

Can anyone recommend any good query design/creator tools for MS Access and MySQL?

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
"query design/creator tools for MS Access"
Sure ... for Access ... the built in Query Designer tool.  Is there something missing from it that you need?
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
hellworld12345

Yes...
It is also called the QBE grid.
(Q)uery (B)y (E)xample

It's either that or learn SQL.

There have been many attempts to build "natural language" query tools, but none really caught on.

Your Question is Kind of like asking if there is a VBA Code Builder...

So I too am wondering what your actual question is here...?

JeffCoachman
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
You can see this book for ways to interpret/write SQL in a way that might help you here:
http://www.amazon.com/SQL-Queries-Mere-Mortals-Manipulation/dp/0321444434/ref=dp_ob_image_bk
Database Architect / Application Developer
Top Expert 2007
Commented:
Yes ... that SQL book by John Viescas ... is outstanding.

BTW ... there are a couple of good AddIns for the QBE ...

mx
Theo KouwenhovenApplication Consultant

Commented:
Hi hellworld12345,

Do you have problems with your query or with your design/create
ZackGeneral IT Goto Guy

Author

Commented:
Cheers for the info.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial