English Language

Following shortcuts are quite useful for Excel (only English language pack). If German language pack differs, you can find it in the next section of this article.

Below my list of useful MS Access shortcuts / keyboard commands.

Shortcuts / keyboard commands

Description  Shortcut 
Switch between database windows (tabs, queries, forms, etc.)  Ctrl. + F6 
Switch between Navigation pane, Ribbon and database windows F6 
Switch view on a query into design view Alt. + H + W + D
Switch back to before selected database window Ctrl. + Shift + F6
Close a database window Ctrl. W

Below a selection of shortcuts in MS SQL Server Management Studio version 2012.


Description  Shortcut
Open a new query. Ctrl. + N 
Execute a single query in an sql document. Select the rows of interest and hit F5 to execute.
Close a selected document. Ctrl. + F4
Open an existing file. Ctrl. + O