mary ann richardson

Articles

Analyze future profits against variable costs with Excel's data table feature

March 6, 2007 8:00am PST

Extrapolate with Excel! By using Excel, you can calculate current profits as well as potential profits based on the variables of your choice. Mary Ann Richardson shows how you can use Excel to...

1

Articles

Make data entry in Access easier by changing text boxes to combo boxes

March 6, 2007 8:00am PST

If your users get slowed down by the various formats demanded by Access data entry, learn how to make Access' data entry fields more versatile by changing text boxes to combo boxes.

3 Latest comment by mgg@...

Articles

Change automatic reference marks for Word endnotes

March 6, 2007 8:00am PST

If you don't like the way your Word endnote numbers look, change them! Mary Ann Richardson explains that you can change the reference marks from Roman numerals to a different format by making one...

Articles

Move endnotes to the end of a Word document

February 27, 2007 8:00am PST

After creating a Word document, you may find that the notes you so laboriously created belong at the end. Mary Ann Richardson explains how to move the endnotes where they belong.

Articles

Analyze Excel data with the Match function

February 27, 2007 8:00am PST

You can use Excel's Match function to scan data for certain parameters, such as a specific product sold in a particular month. Mary Ann Richardson narrows down the process in this Excel tip.

16 Latest comment by champ5515@...

Articles

Prevent users from leaving fields blank in Access

February 27, 2007 8:00am PST

If you have empty fields in Access, here's how to keep them out of your records, preventing records duplication and other headaches. Mary Ann Richardson fills you in.

4 Latest comment by dkennedy4852@...

Articles

Use heading styles to create an outline of your Word report

February 20, 2007 8:00am PST

Mary Ann Richardson explains how to create an outline of a Word report by using headings, leaving the extraneous information in the original document where it belongs.

4 Latest comment by sallie@...

Articles

Automatically check your Access 2003 forms for errors

February 20, 2007 8:00am PST

If you work in Access 2003, you can use error checking on your forms. Mary Ann Richardson explains how to activate this feature.

1

Articles

Create Excel order forms that automatically compute shipping charges

February 20, 2007 8:00am PST

Online order forms are great for figuring out shipping charges—as long as you're working with the right data. Mary Ann Richardson tells how to set up Excel so it automatically calculates the right...

2 Latest comment by mansoorm@...

Articles

Set a language to a style in Word

February 13, 2007 8:00am PST

When you enter non-English text into your Word document, chances are Word will not recognize it and interpret it as misspelled. Mary Ann Richardson brings a certain je ne sais quoi to the issue.

4 Latest comment by marxbusiness@...

Articles

Make Excel spreadsheets easier to read with natural language range names

February 13, 2007 8:00am PST

Use the labels already in your Excel spreadsheet to help you easily understand what your formulas mean. Mary Ann Richardson gives meaning to the mystery of formula results.

14 Latest comment by LocoLobo

Articles

Keep your data in sync with Access database replication

February 13, 2007 8:00am PST

By keeping your Access database on a local server, you have one centralized home for all your data, while allowing your employees to upload new data at will from their own replicas. Mary Ann...

1

Articles

Let Word create your document summary

February 6, 2007 8:00am PST

Need to summarize the information in your Word document in a hurry? By using Word's AutoSummarize feature, you can condense your document into the length of your choice.

2 Latest comment by rengifohugo@...

Articles

Change the labels in an Excel data series

February 6, 2007 8:00am PST

The Chart Wizard in Excel may work a little too well at times, which is why you'll want to read this tip from Mary Ann Richardson. Learn how to change the labels in a data series so you have one...

Articles

Split an Access database to increase application performance

February 6, 2007 8:00am PST

Trim the fat and make your Access app more nimble! By splitting the database, you can keep the bulk of the memory-heavy application on the network file server, leaving the process you really need...

23 Latest comment by akapaul2002@...

Articles

Add pictures to your Access tab controls

January 30, 2007 8:00am PST

Say it with a picture—by adding a picture to your Access tabs! Mary Ann Richardson explains how you can create visual aids by adding pictures to your Access tabs.

Articles

Save time by changing Word's Normal template defaults

January 30, 2007 8:00am PST

Do you have certain specifications you like to use in Word, necessitating you to change the Normal.dot template every time you use it? Change the definition of normal and you'll never go back...

2 Latest comment by walter.rosario@...

Articles

Add high/low lines to your Excel charts

January 30, 2007 8:00am PST

Analyze your Excel information by creating high/low lines for your data charts, allowing you to easily view parameters of a given range. Mary Ann Richardson gives you the lowdown.

4 Latest comment by nicholas.young@...

Articles

Use Word to chart the margin of error in your data

January 23, 2007 8:00am PST

You can analyze Word chart information without Excel. Mary Ann Richardson explains how to use Word's tools to figure the margin of error across your data without writing a complex formula.

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.