Technology Training Community

When you are working with a large spreadsheet, do you find yourself frequently scrolling up and down to other sections within the worksheet verifying your formulas are working properly?

Do you know about all of the different things you can do using the Paste Special options when you copy data? Here are a few of the options you will find on the Paste Special Dialogue box.

Most people who use Excel are familiar with Wrap Text. This is the command that is often used when you want text to appear on multiple lines within a single cell.

If you use a field that contains a null in a mathematical expression, you might get unexpected results. For example, you have a field named cost, which contains the cost of an item.

Today, I am going to examine Null when associated with text fields.  I will continue this subject in my next post by looking at Null associated with number fields.  A Null value is data that is

Have you found that you have multiple Microsoft Access databases? Do you waste time trying to find the database you want to work with?

Are you having difficulties finding the Compact and Repair feature in Microsoft Access 2007? In Access 2003, you found this feature in the tools menu by selecting Database Utilities.

I have been asked a number of times if it is possible to export a report created using Microsoft Access 2007 to Excel.

A wildcard is a special character that can represent any character that may appear in the same position in the file.

I was recently asked if it is possible to change the case of the text in an Access database. The answer is yes.