mary ann richardson

Articles

Assign values to Access records automatically

January 23, 2007 8:00am PST

Use macros in Access to give your data a life of its own, complete with its own values and record assignments. Mary Ann Richardson explains how to add identity to your Access records.

Articles

Turn off Excel's auto font scaling option

January 23, 2007 8:00am PST

When you resize an Excel chart, the text may be scaled accordingly, which in turn may make the words harder to read. Mary Ann Richardson explains how to turn off this default option by disabling...

4 Latest comment by tdunbar@...

Articles

Prevent users from changing hyperlinks in your Word documents

January 16, 2007 8:00am PST

While users may not intentionally change the Web hyperlinks in your Word documents, it's easy for them to accidentally change a link simply by following it. Mary Ann Richardson shows how to make...

4 Latest comment by lbrown@...

Articles

Create a new warning for Access record deletion

January 16, 2007 8:00am PST

If you have started to glaze over the message you get whenever you delete an Access record, you may want to record a message that is more likely to grab your attention. Mary Ann Richardson shows...

5 Latest comment by sstewart@...

Articles

Make your Excel charts easier to read with custom data labels

January 16, 2007 8:00am PST

If users are spending time trying to match up each data label in your chart with its corresponding data point, then you may need to remove some of the clutter. In this Excel tip, Mary Ann...

4 Latest comment by What's All This Then

Articles

Show trends with Word charts

January 9, 2007 8:00am PST

Excel isn't the only data charting software in town—you can add trend charts using Word, and then insert it into your document or distribute the chart on its own. Mary Ann Richardson has more.

6 Latest comment by anikmankar@...

Articles

Save time with a macro for printing embedded charts in an Excel workbook

January 9, 2007 8:00am PST

If you've ever tried to print an embedded Excel chart, you know that it requires several steps. In this tip, Mary Ann Richardson helps you set up a macro to automatically isolate your embedded...

Articles

Rename fields to make your Access queries more meaningful

January 9, 2007 8:00am PST

You aren't stuck with the same fields you began with when you first created an Access query—it's possible to rename your queries without going back to square one. Mary Ann Richardson shows how to...

Articles

Using combined parameter queries in Access

January 2, 2007 8:00am PST

Access can help you easily find statistics on any set of data, but why not use Access to get information using a variety of parameters? Mary Ann Richardson explains how you can use combined...

Articles

Create high-impact charts with Excel's AutoShapes

January 2, 2007 8:00am PST

Charts are visual representations of data, so why not use Excel to further illustrate your information using actual illustrations? Mary Ann Richardson talks about AutoShapes and how to use them in...

2 Latest comment by wildsky@...

Articles

Add chapter numbering to your Word documents

January 2, 2007 8:00am PST

If you've ever tried to organize a dropped stack of documents, you know the importance of chapter and page numbering. In this tip, Mary Ann Richardson tells how you can automatically add chapter...

3 Latest comment by selvaseliyan.sadayaarjunan@...

Articles

Trade tabs for tables in Word

December 19, 2006 8:00am PST

Working with tabs in Word can be a challenge. A simple solution to this potentially tricky problem is to use nested tables without having to set the tabs. Mary Ann Richardson shows you how.

1

Articles

Avoid nested formula errors with Excel's Insert Function dialog box

December 19, 2006 8:00am PST

Excel's nested formulas option may be useful, but many people find it a challenge fraught with potential errors. Mary Ann Richardson explains an easy way around it: use the Insert Function dialog box.

Articles

Filter Access forms with one button

December 19, 2006 8:00am PST

Looking for a needle in an Access haystack? Mary Ann Richardson shows how to add a button that will easily filter the records you use the most.

7 Latest comment by wolfhound_z

Articles

Provide Web access from any Access form

December 12, 2006 8:00am PST

You can let users access the Web from within Access forms by using Explorer's Web browser control. Mary Ann Richardson talks more about this handy add-on.

Articles

How to recover disappearing table text in Word

December 12, 2006 8:00am PST

When working with tables in Word, your text may disappear, but it's not gone forever. Mary Ann Richardson teaches you how to get around this irritating feature by recovering disappearing table text.

Articles

Concatenate date cells with text cells in Excel

December 12, 2006 8:00am PST

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.

7 Latest comment by tali.tv

Articles

Easily create report snapshots of your Access files

December 5, 2006 8:00am PST

Say cheese! Rather than sending the entire Access file to another user, you can create snapshots of relevant reports. Mary Ann Richardson explains how to do it in a snap.

1

Articles

What to do when Word won't let you redo

December 5, 2006 8:00am PST

Did you know that if you use the cut command in Word, it can take away all the redos you've done up to that point? Mary Ann Richardson explains how to backtrack even when Word won't let you redo.

25 Latest comment by kemosabe18

Articles

Make Excel data easier to read with these tips

December 5, 2006 8:00am PST

If reading an Excel spreadsheet leaves you feeling cross-eyed, there are simple steps you can take to make the information easier to handle. Mary Ann Richardson shows how to delineate the data by...

3 Latest comment by Craig.A