Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The title really covers it all - when manually typing a query in SQL View with Access 2010, is there a keyboard shortcut to run the query, like Ctrl + E in SQL Server Management Studio?

If not, it's almost as annoying as not being able to use Ctrl + A to select all text in the query window...

share|improve this question
up vote 1 down vote accepted

The fastest way I found was using the keyboard navigation.

F10, J, Q, X

share|improve this answer
This was funny - I came here to answer my own question since I just now figured out how to do this, only to see it was answered today. Thanks. – John Straka Sep 6 '12 at 16:50

If you're in design view then try Ctrl+ . (full stop). To switch back use Ctrl+ , (comma).

From SQL view things work the other way round - Ctrl+ comma to switch to datasheet view and then Ctrl+ . to switch back to SQL view.

Think these are really meant as a way to toggle through all possible views. Should also work when designing forms as well

share|improve this answer

The shorcut key to run sql query in Access is F10, R then G. In this manner you can run your sql query in Access.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.