CODEWITHSUNDEEP
ms-access
Abid
Abid

Reputation: 133

Access Database query analyzer

Where is the query analyzer in Access Database?

Upvotes: 2

Views: 5318

Answers (7)

Ben McIntyre
Ben McIntyre

Reputation: 1968

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

(disclosure: this is my product)

Upvotes: 0

bstrunk
bstrunk

Reputation: 23

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.

Upvotes: 0

David Boyle
David Boyle

Reputation: 31

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.

Upvotes: 2

Kevin Ross
Kevin Ross

Reputation: 7215

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

Upvotes: 5

JUST MY correct OPINION
JUST MY correct OPINION

Reputation: 36107

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

Upvotes: 1

dartdog
dartdog

Reputation: 10862

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.

Upvotes: 0

o.k.w
o.k.w

Reputation: 25790

Microsoft Access for Beginners— Part III: Writing the Queries

Upvotes: 4

Related Questions