问题描述:

Where is the query analyzer in Access Database?

网友答案:

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

网友答案:

Microsoft Access for Beginners— Part III: Writing the Queries

网友答案:

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.

网友答案:

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).
网友答案:

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.

网友答案:

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.

网友答案:

There is something very like Query Analyser for MS Access now: https://www.arrow-of-time.com/AXF.aspx

(disclosure: this is my product)

相关阅读:
Top