Hotkeys/Shortcut keys of Microsoft Access.

Shortcut keys of Microsoft Access.

Crtl+N : Open new Database.
Ctrl+O: Open existing Database.
Alt+F4: Quit MS access.
Ctrl+p: Print current or selected object.
S: Open the page setup dialog box from print preview.
P: Open Print dialog box from print preview.
C or Esc:Cancel print preview.
Ctrl+S /Shift+F12/Alt +Shift+F2: Save data base.
AltF2/F12: Open the save as dialog box.
F4 / Alt+Down Arrow:Open combo box.
F9: Refresh the contents of a look up field.
Down Arrow: move down one line.
Page Down: Move down one page.
Up Arrow: Move up one line.
Page Up:Move Up one page.
Tab: Exit combo box or list box.
Ctrl+F: Open find tab and replace box.
Ctrl+H: Open replace tab in the find and replace dialog box.
Shift+F4: Find the next occurrence of the text specified in the find and replace dialog box when the dialog box is closed.

Read More

Shortcut Keys of MS Excel/ Microsoft Office tricks.

F2 : Edit the selected cell.
F5: Go to a specific cell .
F7: Spell check selected text and /or document.
F11: Create Chart
Ctrl+Shift+; : Enter the current time.
Ctrl+; :Enter the current date.
Alt+shift+F1: Insert new worksheet.
Shift+F3: Open the excel formula window.
Shift+F5: Bring up search box.
Ctrl+A: select all contents of the worksheet.
Ctrl+B: Bold highlighted Selection.
Ctrl+I : Italic highlighted Selection.
Ctrl+K: Insert link.
Ctrl+U: Underline highlighted  selection.
Ctrl+5: Strike through highlighted selection.
Ctrl+P: Bring up the print dialogue box to bring printing.
Ctrl+Z: Undo last action.
Ctrl+F9: Minimize current window.
Ctrl+F10: Maximize current window.
Ctrl+F6: Switch between open work books/windows.
Ctrl+Page down: Move between Excel worksheets in the same excel document.
Ctrl+Tab: move between two or more excel files.
Alt+=: Create a formula to sum all of the above cells.
Ctrl+'  : Insert the value of the above cell into the cell currently selected.
Ctrl+shift+! : Format number in comma format.
Ctrl+Shift+$ : Format number in currency format.
Ctrl+Shift+# : Format number in date format.
Crtl+Shift+% : Format number in percentage format.
Crtl+Shift+^ : Format number in scientific format.
Crtl+Shift+@ : Format number in time format.
Crtr+Arrow key : move to next section.
Ctrl+Space: Select the entire colum.
Shift +Space : Select entire row.

Read More

Best trick to take Screenshot on your Android Device

Hello friends..

Here sharing with you all trick which you may be knowing i guess i.e print screen .. Now share whats on your screen wall of your android device with your friends or who ever you want in just two simple steps.

1. Press and hold down the Power and Volume-down buttons simultaneously.

2. Open the Gallery app, and you can see your screenshot already saved in the Screenshots album.

3. Now use those images and share with your  friends.

Read More

Trick to Create, Rename and Remove Folders in Android Device

Friends ,  Today's post i'm gonna shrare you trick that could help you  for quickly take a look for an app to open if you have many icons spreading across a few home screens. So lets create a folder to group similar apps together that could help you to find it soon and  make it easy to work with

•     Create a Folder for Apps Touch and hold any icon for a second.
•     Drag the icon over the top of another. The system then automatically groups two app icons in a folder.
•     Touch the folder, then tap "Unnamed Folder", key in a name for the folder and tap "Done".
• Now you can rename a folder at any time—tap a folder then tap its name to rename.

While the system auto creates a folder for you, it does the same to removing a folder automatically—tap a folder to expand it, then clear all grouped items inside the folder—just touch and hold, then drag them out from the folder one by one.

Note: Older Android system doesn't support this feature, but you can rely on a third-party app such as GO Launcher EX to achieve almost the same effect.

Read More