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) for your…Continue Reading

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…Continue Reading

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…Continue Reading

There were very few things I like about Lotus Notes except, for example, the ability to create an appointment (calendar entry) from an email (no, this is not creating an appointment/meeting from an appointment/meeting request email, these are two separate scenarios). When we switched to Outlook from Lotus Notes, I found myself looking for the…Continue Reading

If you are an Outlook user and are limited to the amount of space available for your email, you may want to consider disabling Outlooks’ default setting of saving all of your sent messages. Below I will demonstrate where you can find this option and how to disable it. If you have any comments/questions, please…Continue Reading

Outlook 2007 shipped with many features that to this day I am still discovering. One of the biggest improvements from Office 2003 to Office 2007 and Windows XP to Vista has been the inclusion of a built-in search engine that allows you to index all of the items on your desktop including your email folder….Continue Reading

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 will…Continue Reading

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 you find…Continue Reading

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 am able…Continue Reading

"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…Continue Reading

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…Continue Reading

This Excel Add-in allows you to create treemaps which can be used to visually represented for easier interpretation, think of it like a multiple-level pie chart. I’ve seen maps (Smart Money’s Maps) like these used in the stock market to display different Market segments and their performance for any given day. If you’re interested in…Continue Reading