Pin Frequently Used Documents and Save Time in Office 2007

Jun 30, 2009 View Comments by Gilberto J Perera

I have a set of documents that I frequently use in Excel and Word. Most of the time I can find them using the Recent Documents menu, but at times when they are not listed (because I’ve opened so many other documents) I have to locate the files to open them. I am always looking [...]

How-to Read more

Sneak Peek: Access, Excel, PowerPoint, and Word 2010

Jun 16, 2009 View Comments by Gilberto J Perera

Like I stated in my previous post, I was able to get a copy of Office 2010 and have been playing with it since. The videos below are just a preview of each of the applications mentioned below, more will follow. Even though it is a technical preview I found it to be [...]

Uncategorized Read more

How to Add A Telephone Mask in an Access Table

Nov 10, 2008 View Comments by Gilberto J Perera

This post is a continuation of an Access How-to Series that I’m working on, the last article that I posted walked you through the creation of a table in Access. This how-to will address the application of masks to fields in your table, specifically the telephone mask. The Telephone Mask can be very useful if [...]

How-to Read more

How to Create Tables in Access

Oct 29, 2008 View Comments 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 View 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