Query Analyzer in Access 2000

Access enables you to query analysis by creating a view of the query.

Select query-> Create a query in Design view, and then close the Pop-up Table selection dialog box.

Right-click on the window below to select SQL view, of course, you can also enter from the System menu or toolbar at this time;

Query results return the query statement editing interface also right click on the form to select SQL view.

However, remember that you do not need to save the final results, otherwise it really becomes a view.