Keyboard
The Keyboard tab allows you to define (or change) keyboard shortcuts for any DatabaseSpy command.
In the Set accelerator for drop-down list, you can differentiate between shortcuts that are valid in the Default menu or in the DatabaseSpy Design menu.
To assign a new Shortcut to a command:
1.Select the All Commands category using the Category combo box.
2.Select the command you want to assign a new shortcut to, in the Commands list box.
3.Click in the Press New Shortcut Key text box, and press the shortcut keys that are to activate the command. The shortcuts appear immediately in the text box. If the shortcut was assigned previously, then that function is displayed below the text box. (To clear this text box, press any of the control keys, Ctrl, Alt or Shift).
4.Click the Assign button to assign the shortcut.
The shortcut now appears in the Current Keys list box.
To de-assign or delete a shortcut:
1.Click the shortcut you want to delete in the Current Keys list box.
2.Click the Remove button.
3.Click the Close button to confirm.
To reset all shortcut keys:
1.Click the Reset All button to reset all the shortcut keys to the state they were when the program was installed. A prompt appears stating that all toolbars and menus will be reset.
2.Click Yes to confirm the reset.
The following tables list the currently assigned keyboard shortcuts by key and by function, respectively.
Hotkeys by key
Shortcut | Command name |
|---|---|
F1 | Table of Contents |
F3 | Find next |
F5 | Execute |
Alt | Show Paths |
Alt+Enter | Property Window |
Shift+Alt+Enter | Select entire Statement |
Shift+Delete | Cut |
Alt+Backspace | Undo |
Ctrl+Insert | Copy |
Shift+Insert | Paste |
Alt+Down | Next Statement |
Alt+Up | Previous Statement |
Alt+Home | First Statement |
Alt+End | Last Statement |
Alt+Insert | Append new row |
Ctrl+C | Copy/Copy selected cells |
Ctrl+D | New Design Editor |
Ctrl+E | Export database data... |
Ctrl+F | Find... |
Ctrl+H | Replace... |
Ctrl+I | Import data to the database... |
Ctrl+N | New SQL Editor |
Ctrl+O | Open... |
Ctrl+P | Print... |
Ctrl+Q | Create a database connection... |
Ctrl+S | Save |
Ctrl+S | Save Project |
Ctrl+V | Paste |
Ctrl+X | Cut |
Ctrl+Y | Redo |
Ctrl+Z | Undo |
Ctrl+Alt+E | Edit data |
Ctrl+Alt+O | Options... |
Ctrl+Alt+R | Retrieve all rows |
Ctrl+Alt+T | Retrieve first n rows |
Ctrl+Shift+N | New Project |
Ctrl+Shift+O | Open Project |
Ctrl+Shift+S | Save All |
Ctrl+Shift+V | Paste as new row |
Hotkeys by function
Command name | Shortcut | Alternative shortcut |
|---|---|---|
Append new row | Alt+Insert | |
Copy | Ctrl+C | Ctrl+Insert |
Copy selected cells | Ctrl+C | |
Cut | Ctrl+X | Shift+Delete |
Edit data | Ctrl+Alt+E | |
Execute | F5 | |
Export database data... | Ctrl+E | |
Find next | F3 | |
Find... | Ctrl+F | |
First Statement | Alt+Home | |
Import data to the database | Ctrl+I | |
Last Statement | Alt+End | |
New Design Editor | Ctrl+D | |
New Project | Ctrl+Shift+N | |
New SQL Editor | Ctrl+N | |
Next Statement | Alt+Down | |
Open... | Ctrl+O | |
Open Project | Ctrl+Shift+O | |
Options... | Ctrl+Alt+O | |
Paste | Ctrl+V | Shift+Insert |
Paste as new row | Ctrl+Shift+V | |
Previous Statement | Alt+Up | |
Print... | Ctrl+P | |
Property Window | Alt+Enter | |
Create a database connection | Ctrl+Q | |
Redo | Ctrl+Y | |
Replace... | Ctrl+H | |
Retrieve all rows | Ctrl+Alt+R | |
Retrieve first n rows | Ctrl+Alt+T | |
Save | Ctrl+S | |
Save All | Ctrl+Shift+S | |
Save Project | Ctrl+S | |
Select entire Statement | Shift+Alt+Enter | |
Show Paths | Alt | |
Table of Contents | F1 | |
Undo | Ctrl+Z | Alt+Backspace |