Where is the query analyzer in Access Database?
-
1Tutorial 4 U: techonthenet.com/access/tutorials/passthrough/basics01.phpOMG Ponies– OMG Ponies2010-03-04 01:58:55 +00:00Commented Mar 4, 2010 at 1:58
-
i meant to say that where is query analyzer in the access database..Abid– Abid2010-03-04 02:03:47 +00:00Commented Mar 4, 2010 at 2:03
-
Edit your question instead of indicating this in comment.JeffO– JeffO2010-03-04 02:24:40 +00:00Commented Mar 4, 2010 at 2:24
-
What do you mean when you say "query analyzer"?John Saunders– John Saunders2010-03-04 02:26:54 +00:00Commented Mar 4, 2010 at 2:26
Add a comment
|
7 Answers
If you by query analyser you mean like SQL servers’ show execution plan, there is no direct relation however you can you the jet showplan switch to display what the actual execution plan is. Here is a link on its usage
https://web.archive.org/web/1/http://articles.techrepublic%2ecom%2ecom/5100-10878_11-5064388.html
Comments
1 Comment
Timo
@okw, link is dead.
Access beginners should start by using the query designer. This is a visual tool that lets you visually create joins and filters etc. In Access 2007 and later query design is invoked on the create tab. Access is not ideally suited to manually writing your own SQL, certainly not if you're a newcomer to Access's own SQL dialect. You can do that but you'll find it quite frustrating. Access's query design capabilities are one of the main reasons to use it.
Comments
You can:
- write the query in any source code that interacts with Access' DBO, ODBC, etc. interfaces;
- store queries in the Queries section of the design view;
- execute ad-hoc queries using third-party tools like Visual Access or other similar products (including many open-source ones).
answered Mar 4, 2010 at 2:03
JUST MY correct OPINION
36.2k17 gold badges80 silver badges99 bronze badges
1 Comment
Conrad Frix
Oracle SQL Developer is another one of those 3rd party tools
Assuming you have a database open Open the query window it creates queries graphically there is a sql window option available once you have the query view open.
2 Comments
Abid
i am using nothwind be database.. in the view, there list data sheet view, pivot table, pivot chart,and design view.. but there is not query..
JUST MY correct OPINION
The queries are in the design view.
In Access 2010, in the ribbon, click Database Tools, select Analyze Performance from the Analyze group. Select the Queries Tab in the dialog box that appears.
Comments
There is something very like Query Analyser for MS Access now: https://www.arrow-of-time.com/AXF.aspx
(disclosure: this is my product)
