AQT Basics
Shortcut Keys
Standard shortcut keys
AQT implements the normal shortcut keys that Windows users are used to.
Ctrl + C | copy |
---|---|
Ctrl + V | paste |
Ctrl + X | cut |
Shift + Del | cut |
Shift + Insert | paste |
Ctrl + Insert | copy |
Ctrl + F6 | move between windows |
Database Explorer shortcut keys
The following shortcut keys are active in the Database Explorer window:
Ctrl + C | copy selected cells |
---|---|
Ctrl + O | new database connection |
Ctrl + F2 | add object to favorites |
Ctrl + E | edit list of related tables |
Ctrl + K | edit list of user-defined keys |
Ctrl + L | |
Ctrl + T | |
Ctrl + B | Open Filter Objects window |
F1 | Help |
F5 | refresh middle-grid |
F6 | refresh object-tree |
F7 | |
F9 | display middle-grid table that has focus |
F11 | display right-grid table that has focus |
Shift + Ctrl + F5 | search table that has focus |
Display Data shortcut keys
The following shortcut keys are active in the Display data window:
Ctrl + A | select all |
---|---|
Ctrl + C | copy cells |
Ctrl + D | delete row/s (edit mode only) |
Ctrl + E | edit mode on/off |
Ctrl + F | find |
Ctrl + G | show/hide group-by box |
Ctrl + H | allow variable row height |
Ctrl + I | column info |
Ctrl + K | |
Ctrl + L | lock display from being overwritten |
Ctrl + N | hide all Null columns |
Ctrl + M | get more rows |
Ctrl + O | select column/s |
Ctrl + P | print data |
Ctrl + R | select row/s |
Ctrl + S | search table |
Ctrl + T | two-colour display on/off |
Ctrl + U | undo last hide column |
Ctrl + V | paste cells (edit mode only) |
Ctrl + Z | close query |
Ctrl + F2 | |
Ctrl + F5 | full refresh |
Shift + F2 | |
Shift + F3 | apply layout |
Shift + F5 | show all rows (after a find) |
F1 | help |
F2 | show row detail |
F3 | find next |
F4 | view row numbers |
F5 | refresh data |
F7 | export results |
F11 | extended edit (edit mode only) |
F12 | cancel row update (edit mode only) |
Run SQL Window shortcut keys
The following shortcut keys are active in the Run SQL window:
Ctrl + A | select all |
---|---|
Ctrl + B | change list-box position |
Ctrl + C | copy |
Ctrl + D | clear text |
Ctrl + E | Edit SQL using editor |
Ctrl + F | find |
Ctrl + G | show/hide data grid |
Ctrl + H | view SQL history |
Ctrl + I | go to line |
Ctrl + L | lower case |
Ctrl + M | capitalize text |
Ctrl + N | open another SQL window |
Ctrl + O | open query |
Ctrl + P | print SQL |
Ctrl + R | replace |
Ctrl + S | save query |
Ctrl + T | switch to another table |
Ctrl + U | upper case |
Ctrl + V | paste |
Ctrl + X | cut |
Ctrl + W | line wrap |
Ctrl + Y | redo |
Ctrl + Z | undo |
Ctrl + F5 | go to results window |
Ctrl + F7 | export to table |
Ctrl + F11 | comment text |
Ctrl + F12 | uncomment text |
Ctrl + Shift + F5 | search table |
F1 | help |
F2 | build column list for query table |
F4 | select current statement |
F5 | run SQL |
F6 | check syntax |
F7 | export data |
F8 | explain SQL |
F9 | display query table |
F12 | find matching bracket |
Shift + F2 | toggle bookmark |
Shift + F3 | next bookmark |
Shift + F4 | previous bookmark |
Shift + F12 | select to matching bracket |
Shift + Delete | cut |
Shift + Insert | paste |
Query Builder shortcut keys
Ctrl + C | copy SQL to Windows clipboard |
---|---|
Ctrl + N | open new query window |
Ctrl + O | open query |
Ctrl + P | print screen |
Ctrl + S | save query |
Ctrl + T | add another table |
Ctrl + F5 | go to results window |
F1 | help |
F5 | run query |
F6 | check syntax |
F7 | export data |
Customizing your Shortcut keys
AQT gives you the ability to customize your Shortcut keys for some windows:
the Database Explorer window
the Run SQL window
the Data Display window
the Query Builder window
For all these windows, clicking on View > Customize Shortcut keys will show you Customize Shortcut Keys window.
The Customize Shortcut Keys window shows you all the Menu items available on the window, and allows you to specify which shortcut keys is to be used for that item. Note that some menu items are dynamically created for the window and may not be in this list.
Clicking OK will save the customizations and apply these to all open windows.
Clicking Revert will remove the customization information. This change will not be applied to the open windows; instead only comes into effect when the window is next opened.
Technical Note
Menu Customizations are held in the registry at HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Cardett\Menu. If you think that the menu customizations are causing problems with a window opening, you can remove the entry from the registry (this has the same effect as Revert).