Search code examples
ms-access

Shortcut key for "execute query" in SQL view

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

Solution

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