AQT Basics

Shortcut Keys

Table of Content

Table of Content

Table of Content

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

data loader

Ctrl + T

generate text

Ctrl + B

Open Filter Objects window

F1

Help

F5

refresh middle-grid

F6

refresh object-tree

F7

export data

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

group calculations

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

link to related tables

Ctrl + F5

full refresh

Shift + F2

format data

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