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

How to/Trick to Install a Third Party App on your Android Device

Today's trick is that how  you can install Third party apps on your android device. Third party app  is only available from sources other than the Play Store and you think it's useful and secure to install, the Android system allows you to do so after changing the settings. So here sharing with you those steps below

• Run the Settings app and tap Security under Personal
• Tick "Unknown sources" under Device Administration
• Tap "OK" to the system reminder that your device and personal data are more vulnerable to attack by apps from unknown sources.
• You can now browse to the app file ending with .apk, known as the Android Package, tap and install it .
• Now you have finished installing the app and you are done with it.
  

Read More

Trick to Safeguard Your Email Address/Gmail tricks

We find it a safe measure to share our personal information and images through emails  which is the common thing that most of the time we follow but what if your email is been hacked by hackers , as in today's day to day life its common. Today I'm gonna share a trick which helps you to  protect your mails just by following few simple steps.

• Fist you need to Edit Profile
• Contact Information
• Clicking on the icon beside your email address
• Checking 'Only Me'.

    

Now change your primary email address to a one that is only known to you by going to Account Settings>Email> and changing your primary email to the new one (known only to you) and removing your previous email address.

    For additional security, when in Account Settings, check 'Secure browsing' and 'Send me an email when a new computer or mobile device logs into this account' and click Save.

Some of the safety measures:

• At last Be careful before clicking on suspicious links. 
• Always check the URL in the address bar before signing in. 
• Avoid logging in through various "Facebook widgets" offered by websites and blogs.  
• Facebook's homepage to sign in. 
• Always try to use Safe Search while searching. 
• If you do manage to get phished, report the website so that others may get a warning before visiting it

Read More

Top 5 Best Diwali/Deepawali facebook timeline covers/ google plus covers

 Hello friends .. 

Here sharing with you all best five timeline covers for this Diwali for Facebook and Google plus profile...  update your timeline covers with this new and awesome colorful  images along with the messages.

Check out Here for awesome collection of status message and Deepawali wishes

Read More