title: Microsoft Access 2007: Can I make Access behave like any other ad-hoc query editor?
body: <p>Working with Access is a pain, imo.  I am used to ad-hoc utilities like Benthic, Toad, Oracle SQL Developer, SQLA, etc.  Microsoft Access seems like a child's toy in comparison.  I want a full-featured SQL editor that doesn't assume I am trying to create a view-style query whose sole purpose is to exist as a permanent fixture in my database that returns data.  I'd like to be able to write out multiple queries in a single pane and then hit F9 on the SQL that I want to execute.  I also would like to be able to indent my SQL.</p>
  
  <p>Am I missing an advanced feature of Access or is this really as simple as Access gets?</p>