mary ann richardson

Articles

Send an e-mail from a table in Access without switching to an e-mail client

August 24, 2005 12:34am PDT

Imagine how thrilled your users would be if they could look up a contact's e-mail address in Microsoft Access and send the contact an e-mail—without leaving Access. Find out how to accomplish this...

3 Latest comment by DBJ57L

Articles

Adjust text to fit within an Excel cell

August 24, 2005 12:30am PDT

Microsoft Excel's AutoFit feature is great when you need to resize a cell to display more text than the cell currently allows. But when you can't change the size of a cell to fit the text, this...

11 Latest comment by moni123

Articles

Disable AutoCorrect's automatic capitalization in Word

August 24, 2005 12:21am PDT

Although Microsoft Word's features are often quite useful, sometimes you may find that a feature is superfluous to your task at hand. For instance, if you want to disable Word's automatic...

3 Latest comment by CXY

Articles

Create top 10 lists in Access with the Top Values combo box

August 16, 2005 5:30pm PDT

Are you looking for a snapshot of the 10 best performers in your sales department for the last quarter? Then check out how easy it is to create top 10 lists in Microsoft Access with the Top Values...

1 Latest comment by appugouda@...

Articles

Add a picture to an Excel worksheet's header

August 16, 2005 5:24pm PDT

If you're looking for a way to add some pizzazz to let your Excel spreadsheets stand out, a simple trick is to add a picture to your worksheet's header or footer. Read this Excel tip to learn how...

Articles

Keep Word from spell checking specific text

August 16, 2005 5:13pm PDT

Even though Microsoft Word's spelling checker can be extremely useful, there may be times when you want to turn off this feature for selected text. Mary Ann Richardson provides you with three...

Articles

Create an employee directory in Access using a multicolumn report

August 10, 2005 12:00am PDT

Don't you find that Microsoft Access' Report formats based on forms or single-column lists are usually inadequate when you want to create an employee or client directory? Then check out this tip...

2 Latest comment by Address Book Software

Articles

Make Excel spreadsheets easier to read with 3-D effects

August 10, 2005 12:00am PDT

Microsoft Excel spreadsheets are a fantastic way to organize data; however, sometimes your spreadsheets may get a bit cluttered and become hard to read. Find out how you can use 3-D effects in...

3 Latest comment by rachael@...

Articles

Sort nontabular data in Word with Table Sort

August 9, 2005 7:00am PDT

Sorting data that isn't in a table in Microsoft Word can be an arduous task—but it doesn't need to be. The next time you have to sort nontabular data see how using Word's TableSort command can...

6 Latest comment by Mary Weilage

Articles

Use Access's Union query to create a mailing list from two different tables

August 2, 2005 3:57pm PDT

Have you ever needed to send the same letter to people listed in two different databases? If so, you probably thought you needed to create two different mailing lists. That's not the case—you can...

5 Latest comment by buickjim@...

Articles

Create a gauge chart in Excel to show a job's progress

August 2, 2005 3:54pm PDT

A useful way of conveying what percentage of a job is complete is to create a gauge chart in Microsoft Excel. Even though a gauge chart is not listed in the default chart types, you can still...

4 Latest comment by budimand@...

Articles

Clear formatting from text pasted into a Word document

August 2, 2005 3:53pm PDT

When Microsoft Word users grab a block of text to insert into their document either from another document or from the Web, they may not always want to keep the formatting associated with the text....

10 Latest comment by juhlster1021

Articles

Copy an existing table structure into a new Access database

July 26, 2005 7:35pm PDT

If you've been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the table...

Articles

Keep Excel from automatically updating charts

July 26, 2005 7:29pm PDT

There are times when Microsoft Excel is almost too efficient. For instance, Excel automatically updates a chart when a change is made to the chart data. If you want to capture a snapshot of your...

2 Latest comment by dhsalda

Articles

How to use the mouse to change your Word document's margins

July 26, 2005 5:54pm PDT

When using the mouse and the ruler to change margins in Word documents, users often confuse the ruler's document margin markers with the paragraph indent markers. Learn how to find and move the...

24 Latest comment by trish3333@...

Articles

Enhance grouping in your Access reports

July 19, 2005 5:53pm PDT

Grouping related customer records in your Microsoft Access reports allow you to look at data from different angles. Discover a quick way to put these groups in sections and then enhance these...

Articles

Navigate between windows in Excel workbooks

July 19, 2005 5:47pm PDT

When you're working with Microsoft Excel, it's common to have two or more workbooks open at once. Learn a handful of basic ways to efficiently navigate between workbooks.

Articles

Link to another file in your Word document

July 19, 2005 5:38pm PDT

If you insert text from a another file into one of your Microsoft Word documents, there may be cases when you want to be able to update the text when changes are made to the source file. This tip...

3 Latest comment by Priyanka7487

Articles

Delete unnecessary data with Access' Delete query

July 12, 2005 9:57pm PDT

It's dumbfounding to imagine how much data we hang on to even when it's no longer necessary. The next time you do a little database housekeeping, you should take advantage of Microsoft Access'...

3 Latest comment by solson@...

Articles

Get up-to-the minute data with Excel's automatic Web queries

July 12, 2005 9:40pm PDT

When your job depends on having the latest stats, it behooves you to find the most efficient way to receive this information. Discover how Excel 2002 and 2003's Web query feature allows your...

6 Latest comment by pyketin@...