Create an ODBC Connection to Access Database

The Microsoft Access, also known as MSAccess, is a management system database from Microsoft, packaged with Microsoft Office Professional which combines the Microsoft Database Engine with a graphical user interface. In Windows 64bit to check whether the 32-bit Microsoft Access Database Engine drivers are installed, go to C:\Windows\SysWOW64\odbcad32.exe. If on a 32-bit machine, go to C:\Windows\System32\odbcad32.exe to access the utility.  Go to the drivers tab. If the Microsoft Access Driver lists .mdb and .accdb, then the correct drivers are installed….

Read More

Keyboard Shortcuts for Microsoft Word 2013 – Quick Reference

Common tasks in Microsoft Word TO DO THIS PRESS Create a nonbreaking space. CTRL+SHIFT+SPACEBAR Create a nonbreaking hyphen. CTRL+SHIFT+HYPHEN Make letters bold. CTRL+B Make letters italic. CTRL+I Make letters underline. CTRL+U Decrease font size one value. CTRL+SHIFT+< Increase font size one value. CTRL+SHIFT+> Decrease font size 1 point. CTRL+ Remove paragraph or character formatting. CTRL+SPACEBAR Copy the selected text or object. CTRL+C Cut the selected text or object. CTRL+X Paste text or an…

Read More

Posted in Microsoft Word Comments Off on Keyboard Shortcuts for Microsoft Word 2013 – Quick Reference
Keyboard Shortcuts for Microsoft Word 2013 – Navigating the Ribbon

Access any command with a few keystrokes Access keys let you quickly use a command by pressing a few keys, regardless of where you are in the program. Every command in Word 2013 can be accessed by using an access key. You can get to most commands by using two to five keystrokes. To use an access key: Press ALT. The KeyTips are displayed over each feature that is available in the current view. Press the letter shown in…

Read More

Keyboard Shortcuts for Microsoft Word 2013 – Basics

Display and use windows TO DO THIS PRESS Switch to the next window. ALT+TAB Switch to the previous window. ALT+SHIFT+TAB Close the active window. CTRL+W or CTRL+F4 Restore the size of the active window after you maximize it. ALT+F5 Move to a task pane from another pane in the program window (clockwise direction). You may need to press F6 more than once. F6 Move to a task pane from another pane in the program window (counterclockwise direction). SHIFT+F6 When…

Read More

Keyboard Shortcuts in Excel 2013

Ctrl combination shortcut keys KEY DESCRIPTION Ctrl+PgDn Switches between worksheet tabs, from left-to-right. Ctrl+PgUp Switches between worksheet tabs, from right-to-left. Ctrl+Shift+& Applies the outline border to the selected cells. Ctrl+Shift_ Removes the outline border from the selected cells. Ctrl+Shift+~ Applies the General number format. Ctrl+Shift+$ Applies the Currency format with two decimal places (negative numbers in parentheses). Ctrl+Shift+% Applies the Percentage format with no decimal places. Ctrl+Shift+^ Applies the Scientific number format with two decimal places. Ctrl+Shift+# Applies the…

Read More

Posted in Microsoft Excel Comments Off on Keyboard Shortcuts in Excel 2013
Useful Shortcuts for PowerPoint 2013

TO DO THIS PRESS Perform the next animation or advance to the next slide. N, ENTER, PAGE DOWN, RIGHT ARROW, DOWN ARROW, or SPACEBAR Perform the previous animation or return to the previous slide. P, PAGE UP, LEFT ARROW, UP ARROW, or BACKSPACE Go to slide number. number+ENTER Display a blank black slide, or return to the presentation from a blank black slide. B or PERIOD Display a blank white slide, or return to the presentation from a blank white…

Read More

Useful Shortcuts for PowerPoint 2010

TO DO THIS PRESS Start a presentation from the beginning. F5 Perform the next animation or advance to the next slide. N, ENTER, PAGE DOWN, RIGHT ARROW, DOWN ARROW, or SPACEBAR Perform the previous animation or return to the previous slide. P, PAGE UP, LEFT ARROW, UP ARROW, or BACKSPACE Go to slide number. number+ENTER Display a blank black slide, or return to the presentation from a blank black slide. B or PERIOD Display a blank white slide, or return…

Read More

How to Setup Firefox to use Windows Authentication

  If you have an ASP.NET application that is behind an IIS Web Server and it configured to use Windows authentication or what they called trusted login. Typically you can download a plugin for Firefox and it will help you perform windows authentication automatically. What if you are not allowed install any plugin or don’t want to use any plugin. When you try to connect to a ASP.NET application via Windows authentication it will display they following error message:…

Read More