Introduction.
Keyboard Shortcuts are very useful, if practiced and memorized, for frequently used actions without shifting back and forth between mouse and keyboard. Microsoft Access has an extensive list of Keyboard Shortcuts to make our work much easier. You can enter the search term Keyboard Shortcuts on the Help Menu to get a category-wise list. I have selected some of them and given them at the end of this post for reference.
If you look carefully at the MS-Access Menu Options you can find one letter in each Menu Item is underlined indicating that it is a Keyboard Shortcut Code.
For example, the letter E in the Edit menu is underlined, indicating that you can open the Edit Menu using ALT+E Keyboard Shortcut. Most of the Options within the Edit Menu also have keyboard shortcut Codes on the right side of each one. These are all predefined keyboard shortcuts in the system.
Defining Custom Shortcuts
When we design Forms we can define our own custom Keyboard Shorts (Access Keys) on the Form Controls in a similar way with the help of a & symbol. If you insert a & symbol on the left side of a character in the Caption of the Command Button (or in the Caption of a Label) you can use ALT+character to make the Command Button act as if it is being clicked and runs the action programmed into that Button.
For example, if you have a Command Button on a Form with the Caption Export you can write the Caption as &Export; so that ALT+E Keyboard Shortcut can be used to run the Export action. When we define keyboard shortcuts this way we should see that does not end up with the same built-in Shortcuts.
Here, we already have a Built-in Keyboard Short &Edit, which uses the ALT+E combination. We can insert the & symbol on the left side of any letter within the word Export (like Ex&port for ALT+P) to avoid conflict with the built-in codes.
There are other methods to define Keyboard Shortcuts. You can put all your Custom Keyboard Shortcuts in a Macro for specific actions, like Print Previewing/Printing Report, for opening a Particular Form in Design View or Normal View, Run a Macro to Process Report Data, etc. You must name the Macro as Autokeys. An image of the Example Macro is given below.
The first line Action OpenReport runs when the CTRL+O keys are used, CTRL+K runs another Macro.
If you assign an action to a key combination that is already being used by MS-Access (for example, CTRL+C is the key combination for Copy), the action you assign this key combination replaces the Access key assignment.
AutoKeys
A list of key combinations that you can use in your Autokeys Macro is given below.
Key Code | Key Press |
---|---|
^A or ^4 | CTRL+A or CTRL+4 |
{F1} | F1 |
^{F1} | CTRL+F1 |
+{F1} | SHIFT+F1 |
{INSERT} | INS |
^{INSERT} | CTRL+INS |
+{INSERT} | SHIFT+INS |
{DELETE} or {DEL} | DEL |
^{DELETE} or ^{DEL} | CTRL+DEL |
+{DELETE} or +{DEL} | SHIFT+DEL |
A macro with the name Autoexec runs automatically when you open a database.
General Purpose Keyboard Shortcuts
A list of useful general-purpose Keyboard Shortcuts is given below for your reference.
Seq | Key Strokes | Action |
---|---|---|
SAVING AND PRINTING | ||
1. | CTRL+S or SHIFT+F12 or ALT+SHIFT+F2 | To save a Database Object |
2. | F12 or ALT+F2 | To open the Save As... dialog box |
3. | CTRL+P | To Print the Current or Selected Object |
FINDING REPLACING | ||
4. | CTRL+F | To open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only |
5. | CTRL+H | To open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only) |
6. | SHIFT+F4 | To find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only) |
WORKING IN DESIGN VIEW | ||
7. | F2 | To switch between Edit mode (with insertion point displayed) and Navigation mode |
8. | F4 | To switch to the property sheet (Design view in forms and reports in databases and Access projects) |
9. | F5 | To switch to Form view from the form Design view |
10. | F6 | To switch between the upper and lower portions of a window (Design view of tables, macros, and queries and the Advanced Filter/Sort window only) |
11. | SHIFT+F7 | To switch from the Visual Basic Editor to form or report Design view |
12. | ALT+V+P | To open the property sheet for a selected object |
Editing Controls in Form and Report Design View | ||
13. | CTRL+C | To copy the selected control to the Clipboard |
14. | CTRL+X | To cut the selected control and copy it to the Clipboard |
15. | CTRL+V | To paste the contents of the Clipboard in the upper-left corner of the selected section |
16. | CTRL+RIGHT ARROW | To move the selected control to the right |
17. | CTRL+LEFT ARROW | To move the selected control to the left |
18. | CTRL+DOWN ARROW | To move the selected control down |
19. | SHIFT+DOWN ARROW | To increase the height of the selected control |
20. | SHIFT+RIGHT ARROW | To increase the width of the selected control |
21. | SHIFT+UP ARROW | To reduce the height of the selected control |
22. | SHIFT+LEFT ARROW | To reduce the width of the selected control |
WINDOW OPERATIONS | ||
23. | F11 | To bring the Database window to the front |
24. | CTRL+F6 | To cycle between open windows |
25. | ENTER | To restore the selected minimized window when all windows are minimized |
26. | CTRL+F8 | To turn on Resize mode for the active window when it's not maximized; press the arrow keys to resize the window |
27. | ALT+SPACEBAR | To display the Control menu |
28. | SHIFT+F10 | To display the shortcut menu |
29. | CTRL+W or CTRL+F4 | To close the active window |
30. | ALT+F11 | To switch between the Visual Basic Editor and the previous active window |
MISCELLANEOUS | ||
31. | F7 | To check to spell |
32. | SHIFT+F2 | To open the Zoom box to conveniently enter expressions and other text in small input areas |
33. | ALT+ENTER | To display a property sheet in the Design view |
34. | ALT+F4 | To quit Microsoft Access, close a dialog box, or close a property sheet |
35. | CTRL+F2 | To invoke a Builder |
Who knows where to download XRumer 5.0 Palladium?
ReplyDeleteHelp, please. All recommend this program to effectively advertise on the Internet, this is the best program!
Hey
ReplyDeleteReally glad to get into this forum
It's what I am looking for.
Hope to know more member here.
Sorry. Does someone realize how to define true EA from fraudulent and a true Forex signals from fake? sorry for inconvinience
ReplyDeleteThanks very good for report, I follow your blog
ReplyDeletenice to be here.... thanks for share
ReplyDeleteGreat article, i
ReplyDeletehope can know much information About it!
[...] Autokey macro, check this http://msaccesstips.com/2007/12/keyboard-shortcuts/ __________________ If this resolves your issue, please use the Thread Tools and mark the thread [...]
ReplyDelete