How to Create Tables in Access

Oct 29, 2008 1 Comment by Gilberto J Perera

In simple terms a database is a collection of tables that are related and/or unrelated to each other and can store information in various formats. In the previous tutorial I showed you how to create a database from scratch, in this tutorial I’ll show how to create tables (the foundation to any database) [...]

How-to Read more

How to Create A New Access Database

Oct 28, 2008 No Comments by Gilberto J Perera

This article is the first in a series of articles that demonstrates the basics of using databases in Access. I will also create a series for those of you that use Open Office Base (an open source alternative to Access). The guide below will walk you through the process of creating a database. If you [...]

How-to Read more

How to Add Background Images to Your Email Messages

Oct 20, 2008 1 Comment by Gilberto J Perera

If you’ve ever wanted to add a picture to the background of an email message, you’ll quickly find that locating that option is not as intuitive as one would like. This is a great tool for those of you who would like to use your company logo as an email background or would simply like [...]

How-to Read more

How to Add Watermarks to Your Word Documents

Apr 26, 2008 No Comments by Gilberto J Perera

The other day I was asked by one of my colleagues if I knew how to add the "DRAFT" watermark in Word documents. I must admit, I did not know, so after a little search using Word’s Help content I found that there is an option in Word that enables this feature. Below you [...]

How-to Read more

How to Add A Second Axis to Your Charts in Excel

Jan 24, 2008 19 Comments by Gilberto J Perera

When using Excel and working with two data sets that differ greatly in range it can be difficult to chart those values due to the larger range of one of your data sets. A classic example of this would be your monthly data and your YTD values for each month. When you put these together [...]

How-to Read more

How to Use Autofilters to Sort Data in Excel

Sep 18, 2006 2 Comments by Gilberto J Perera

Most of the time I work with a lot of data and I’ve found that the most effective and simple way of sorting and making use of that data is by applying AutoFilters in Excel. The AutoFilter tool allows you to arrange a set of data in a variety of ways which helps [...]

How-to Read more

How to Organize Emails by Color

Jul 17, 2006 No Comments by Gilberto J Perera

I recieve an enormous amount of emails on a daily basis, but there are really very few that I have the time to read and so I started to look for an easy way of letting Outlook help me find those that I need to read. Using a small setting in Outlook I [...]

How-to Read more

Now You Can Insert Your Creative Commons License with a Click of a Button

Jun 23, 2006 No Comments by Gilberto J Perera

"This add-in enables you to embed a Creative Commons license into a document that you create using the popular applications: Microsoft Office Word, Microsoft Office PowerPoint, or Microsoft Office Excel. With a Creative Commons license, authors can express their intentions regarding how their works may be used by others.
The add-in downloads the Creative Commons [...]

Reviews Read more

How to Change Color Schemes in Office 2007 Beta 2

Jun 23, 2006 No Comments by Gilberto J Perera

Microsoft’s new Office iteration allows you to customize it like never before. For those of you who use Windows XP. Office 2007 defaults to the blue color scheme which resembles that of Windows XP. You can however make it look like Windows Vista Theme by applying the Vista color scheme. If you’re like me and [...]

How-to Read more

How to Use the Compare and Merge Feature in Word

May 30, 2006 No Comments by Gilberto J Perera

Microsoft Word allows you to view the changes that took place between one version of a particular document and another. This tool is specifically useful when writing contracts which can vary from time to time or other documents whose format can be reused and changes tracked. I read about this feature on a recent [...]

How-to Read more