How to create an Access database from templates
Posted on April 25, 2009 - Filed Under MS Office Tips | Leave a Comment
Office Access 2007 includes a pack of prebuilt stand alone database applications. I usually use the templates to get started on an MS Access project. With a template, you won’t have to start from scratch – you have something working right from the start.
The trick is to find the right template that will match your requirement. Usually the templates are good enough for generic database requirements. In some cases, a little tweaking is involved to suite the client’s need.
How to query webpages using Excel
Posted on April 3, 2009 - Filed Under MS Office Tips | Leave a Comment
Excel users are usually required to import data from several sources. Web pages have become a common platform for corporate and non-corporate groups for presenting data. In this tutorial we will show you how to connect Excel to webpages that contains tables so you can get extract the tabular data from it.
To import data from Excel, click the Data menu > Import External Data > New Web Query:
Enter the URL on the address bar then click go to display the page on the window. Click the arrow next to the table that you want to import then click the import button:
How to blog from Word 2007
Posted on March 30, 2009 - Filed Under MS Office Tips | 2 Comments
Office 2007 has a lot of improvements and, as a blogger, I particularly noticed its new ability to handle blog posts. In this post I will show you how to post and edit blog posts using Word 2007.
First, open Word 2007 then click New Document. Choose New blog post as a template:
On first use, it will ask you to setup your blog account. Enter the following information: Blog Post URL (i.e. this should be your own blog account’s URL, for example www.wordpress.com or www.blogger.com), user name and password. Check the remember password if you want this to be saved for your future blog posts. If you have many blog accounts, you can add more later.
How to open a WPS file
Posted on March 24, 2009 - Filed Under MS Office Tips | Leave a Comment
WPS is the file extension for a Microsoft Works file that Microsoft does not support very well at all. If, for some crazy reason, you end up with one of these files, first tell the person to upgrade their old computers and then read on to learn how to open it!
You can open a WPS file in one of two ways: either convert it to a Word document if you want to be able to edit it or download a WPS viewer.
How to copy only formulas in Excel
Posted on March 23, 2009 - Filed Under MS Office Tips | 1 Comment
Most of us using Excel and other MS Office tools might be very familiar with the basic copy and paste capability. You copy a part of the document (Control-C) and then you paste it on another part of the document (Control-V).
However did you know that in Excel there are several “special paste” options that you can use in Excel? In this tip we will show you how to use the special options so you can apply it to copy formulas and formula values.
Check for MS Office errors using MS Office Diagnostics
Posted on March 12, 2009 - Filed Under MS Office Tips | Leave a Comment
Are you having MS Office system errors? Crashes, glitches, startup errors, and other common Office problems are most of the time fixed by reinstalling MS Office. But what if the errors persist? What if the actual cause is NOT in MS Office itself, but instead bad memory sectors in the RAM or a harddisk error?
Before calling Microsoft support, follow the steps below. Most likely we will save you a great amount of trouble with this easy to use diagnostic tool included with your MS Office 2007 tools.
