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