Monday, December 19, 2011

OUTLOOK Shortcuts

Some useful OUTLOOK shortcuts:
  • Alt + . (period) Open the Address Book with the To field selected
  • Alt + A Open the Action drop-down menu
  • Alt + B Open the Address Book with the BCC field selected
  • Alt + C Select message recipients for CC field
  • Alt + D Switch to Daily calendar view
  • Alt + E Open the Edit drop-down menu
  • Alt + F Open the File drop-down menu
  • Alt + G Open the Go drop-down menu
  • Alt + H Open the Help drop-down menu
  • Alt + I Open the Find tool bar / Open the Insert drop-down menu
  • Alt + J Move to the Subject field
  • Alt + K Check names in the To, CC, or BCC field against the Address Book (cursor must be in the corresponding message header field)
  • Alt + L Reply All
  • Alt + M Switch to Monthly calendar view
  • Alt + N Open the Accounts drop-down menu
  • Alt + O Open the Format drop-down menu / Switch to Today calendar view
  • Alt + P Open the Message Options dialog box
  • Alt + R Reply / Switch to Work Week Calendar view
  • Alt + S Send
  • Alt + T Open the Tools drop-down menu
  • Alt + V Open the View drop-down menu
  • Alt + W Forward an item / Switch to Weekly calendar view
  • Alt + Y Switch to Daily calendar view
  • Ctrl + 1 Go to Mail
  • Ctrl + 2 Go to Calendar
  • Ctrl + 3 Go to Contacts
  • Ctrl + 4 Go to Tasks
  • Ctrl + 5 Go to Notes
  • Ctrl + 6 Go to Folder List
  • Ctrl + 7 Go to Shortcuts
  • Ctrl + 8 Go to Journal
  • Ctrl + A Select all
  • Ctrl + B Bold when editing a rich text message
  • Ctrl + C Copy
  • Ctrl + D Delete an item (message, task, contact, etc.)
  • Ctrl + E Activate the Find drop-down menu / Center Align when editing a rich text message
  • Ctrl + F Forward
  • Ctrl + J Open a new Journal Entry from the selected item (message, task, contact, etc.)
  • Ctrl + K Check names in the To, CC, or BCC field against the Address Book (cursor must be in the corresponding message header field)
  • Ctrl + M Send/Receive all
  • Ctrl + O Open
  • Ctrl + P Print
  • Ctrl + Q Mark the selected message Read
  • Ctrl + R Reply
  • Ctrl + S Save a draft message
  • Ctrl + T Tab
  • Ctrl + U Mark the selected message Unread
  • Ctrl + V Paste
  • Ctrl + X Cut
  • Ctrl + Y Go to Folder
  • Ctrl + Z Undo
  • Ctrl + Backspace Delete the previous word
  • Ctrl + End Move to the end
  • Ctrl + Home Move to the beginning
  • Ctrl + Shift + A Open a new Appointment
  • Ctrl + Shift + B Open the Address Book
  • Ctrl + Shift + C Create a new Contact
  • Ctrl + Shift + E Open a new folder
  • Ctrl + Shift + F Open the Advanced Find window
  • Ctrl + Shift + G Flag message for follow up
  • Ctrl + Shift + J Open a new Journal Entry
  • Ctrl + Shift + K Open a new Task
  • Ctrl + Shift + L Open a new Distribution List
  • Ctrl + Shift + M Open a new Message
  • Ctrl + Shift + N Open a new Note
  • Ctrl + Shift + O Switch to the Outbox
  • Ctrl + Shift + P Open the New Search Folder window
  • Ctrl + Shift + Q Open a new Meeting Request
  • Ctrl + Shift + R Reply All
  • Ctrl + Shift + S Open a new Discussion
  • Ctrl + Shift + U Open a new Task Request
  • Ctrl + Shift + Y Copy a Folder
  • Shift + Tab Select the previous message header button or field
  • F1 Open Outlook Help
  • F3 Activate the Find toolbar
  • F4 Open the Find window
  • F7 Spellcheck
  • F9 Send and receive all
  • F10 Select File from the Outlook toolbar button
  • F11 Activate the "Find a contact" dialog box
  • F12 Save As
  • Alt + F4 Close the active window

Wednesday, September 14, 2011

Dropping all DB tables, views, indexes, sequences in one query.

Most of the time one faces the issues like one need to delete all the tables, views, indexes or sequences in the database.
So following the query which generates DROP statements for all the components present in the Oracle database:

SELECT 'DROP TABLE ' || table_name || ';' AS statement FROM user_tables
Union
SELECT 'DROP VIEW ' || view_name || ';' AS statement from user_views
Union
SELECT 'DROP INDEX ' || index_name || ';' AS statement from user_indexes
Union
SELECT 'DROP SEQUENCE ' || sequence_name || ';' AS statement from user_sequences
Union
SELECT 'DROP SYNONYM ' || SYNONYM_name || ';' AS statement from user_SYNONYMs;

Cheers :)

Thursday, April 14, 2011

Productivity Tool - PowerPro

The PowerPro software provides the user with a launch bar that is both compact and powerful. It also includes a menu and tray icon functionality. The program integrates three functionalities. It can run commands such as tool bars, tray icons, scheduler, menus, timer, mouse and hot keys. The PowerPro software can also be used by the user to close, maximize, minimize, position, roll-up to caption and tray minimize other program's windows. The program also provides utility functions. It can send keystrokes to programs, provide virtual desktops, run commands when Windows first opens, serve as a clipboard extender, can shutdown, enable keyboard macros, show all folder files in a menu, enable sounds, wallpaper and screensaver activation as well as randomization.

In practical scenarios, software professionals can use this to :
·         Add List of putties to connect to various servers and get rid of typing username password each time.
Command is as follows:
putty.exe -ssh <UserName>@<ServerIP> -pw <Password>
·         Create shortcuts to various software.
·         Create shortcuts to documentation page(so no need to open browser and then search for bookmark if done).


You can more explore about this software using following link:
·         Home Page: http://powerpro.webeddie.com/index.html
·         Feature & Configuration Demo: http://powerpro.webeddie.com/tour/index.htm

So after exploring this, you can save time and concentrate on other work :)

Cheers!!!

Wednesday, February 2, 2011

Keynote NF : Handy and productive tool to manage notes.

I would like to let you know about a good lightweight tool : Keynote NF
As we use notepad to save various important notes or mark some to-dos.
Due to this desktop gets messy and its trouble to find things which we have written for our simplicity :)
Using keynote one can save the important notes or any under process notes in single file.
It is having various features, I have found few of it while its usage:
  • Simple to use and Lightweight – When not in use keeps running in background.
  • Freeware – No licenses.
  • Supports Rich Text and various feature like MS Word.
  • Alarm / Reminders.
  • Tree based to arrangements of notes and multiple tabs.
  • Good search capabilities.
  • No need to install – Unzip and start using it.
You can explore it more and I am sure you may find it handy as compared to using notepad.
Here are details about Keynote NF:
Keynote NF Downloads (No need to install – Unzip and Use it):

Cheers!