Shortcut key for "execute query" in SQL view

Question

Is there a shortcut for Microsoft Access Query Editor to execute the SQL? This clicking drives me mad.

Answer 1

Ctrl + .    from query design to datasheet
Ctrl + ,    from datasheet to query design

Mnemonically, it helps that these are keys for > and <:

Ctrl + >    from query design to datasheet
Ctrl + <    from datasheet to query design

I didn't show them that way above because that would suggest you also press the Shift key.

These commands cycle through various views, including pivots. I'm not interested in Access' pivot feature and I don't wish to accidently launch it, so that might be reason to use one of the other methods.

Answer 2

Not exactly a hot key combo, you have to press each key in sequence:

Alt, H, W, H to switch to table view

Alt, H, W, D to switch to design view

If you right click on the ribbon's button to switch to different views (design, table, sql, etc) you can add the button to the quick access bar. With that done you can then press Alt+# (where # is the number for whatever position the button is on the quick access bar).