mary ann richardson

Articles

Create a simple Web page in Word

November 28, 2006 8:00am PST

You don't need to be an HTML wizard or own special software to build a simple Web page. Mary Ann Richardson explains how you can use Word to create a Web-ready page that can be uploaded to your...

10 Latest comment by abdu.elnagheeb@...

Articles

Turn Access forms into HTML pages in five steps

November 28, 2006 8:00am PST

Easily convert your Access information to a server-ready Web page using Data Access Pages and the page wizard. Mary Ann Richardson walks you through the process.

Articles

Prevent Excel spreadsheet headers and footers from printing over your data

November 28, 2006 8:00am PST

Your Excel spreadsheet may look great onscreen, but when you go to print it, headers and footers may be a problem. Mary Ann Richardson explains how to increase margins and include all your data,...

Articles

Display grouped data over the Web with Access' page wizard

November 21, 2006 8:00am PST

In this Access tip, Mary Ann Richardson discusses the page wizard, which can help you create a Web-ready grouped data display.

Articles

Keep Word from mistakenly changing what you type

November 21, 2006 8:00am PST

Word can be very handy for correcting mistakes, but sometimes what Word perceives as an error is actually an intentional keystroke. Mary Ann Richardson explains how to keep Word from automatically...

21 Latest comment by nospam@...

Articles

Reset the last cell of your Excel worksheet

November 21, 2006 8:00am PST

Excel often will default to the last cell you've entered data into—even if you've wiped it out. Mary Ann Richardson shows how to create a macro that will reset the unwanted cell.

10 Latest comment by acandiani@...

Articles

Autoform:Pivot Chart makes analyzing Access data a snap

November 14, 2006 8:00am PST

Analyzing Access data doesn't need to be difficult. If you're working with demographics or any other kind of sortable customer data, Access' Autoform:Pivot Chart feature can help you create a...

1

Articles

Peruse reviewers' comments quickly with Word's Select Browse Object

November 14, 2006 8:00am PST

With Word's Select Browse Object tool, it's easier than ever to review all the comments from your reviewers without missing a thing. Mary Ann Richardson walks you through the necessary steps.

1

Articles

Find a perfect match in a lookup table in Excel

November 14, 2006 8:00am PST

Using the FALSE argument in Excel can help you find a true match in a lookup table, while eliminating a lot of the confusion that is common with such comparisons. Mary Ann Richardson explains how...

1 Latest comment by radicalrat2@...

Articles

Create Access reports from crosstab queries

November 7, 2006 2:17pm PST

Did you know that you can create a report from your Access file's crosstab data? Here's how to organize and clarify your data in a unique Access report.

3 Latest comment by dwayne.fitz@...

Articles

Use line numbers when reviewing Word documents

November 7, 2006 8:00am PST

Using line numbers in Word can help your readers find a particular section or paragraph. Mary Ann Richardson tells how to use Line Numbering to keep everyone on the same page.

7 Latest comment by dcaldwell@...

Articles

Get Excel to calculate formulas with circular references

November 7, 2006 8:00am PST

Don't go around in circles unnecessarily—when you have a circular reference in Excel, the program usually gives you an error message. However, if you want to calculate repeatable formulas, you can...

3 Latest comment by nareshhusys

Articles

Add time and date stamps to your Access records automatically

October 31, 2006 8:00am PST

With all the Access records created every day, it's not surprising that you may need to go back and reference what you've already done—but you may not know where to begin. Mary Ann Richardson...

8 Latest comment by brian@...

Articles

Copy an Excel formula without changing its cell references

October 31, 2006 8:00am PST

If you copy a formula from one place to another, Excel will want to readjust the references to reflect the change. However, if you want the formulas to stay the same, Mary Ann Richardson can help...

56 Latest comment by f.quintas

Articles

Vertically center graphics and text on one page within a Word document

October 31, 2006 8:00am PST

You don't need to hit the [Enter] key over and over again to get the body of your Word document to line up—have Word do it for you. Mary Ann Richardson brings the tip front and center.

2 Latest comment by papgas@...

Book Chapters

Set your software development project on the road to success with these practical tools and strategies

October 25, 2006 12:00am PDT

Ever wonder why many software projects run into trouble, and many never ship at all—while others run like well-oiled machines? Learn how to set your software development project on the road to...

Provided by: Pragmatic Bookshelf

Articles

Use Access queries to archive old data

October 24, 2006 7:00am PDT

Chances are you regularly access only a fraction of the Access records that live in your system—so why not archive the ones you don't use as often? It's not only possible but simple to selectively...

16 Latest comment by geekgirlau

Articles

Use Find to edit selected cells in an Excel worksheet all at once

October 24, 2006 7:00am PDT

Did you know that you can search for and edit multiple cells in Excel? Mary Ann Richardson discusses the Find tool and how you can use it to make big changes in a snap.

1

Articles

Easily convert 2-D objects into 3-D in Word

October 24, 2006 7:00am PDT

Just because a sheet of paper is flat doesn't mean your images must be! Mary Ann Richardson tells how to make a two-dimensional object pop as a three-dimensional image in Word—and how to add a...

1 Latest comment by clutterbug@...

Articles

Increase your Access options with nonexclusive option groups

October 17, 2006 7:00am PDT

A, B, or both A and B? You may have your Access forms set up to allow users to choose one option, but what if you want your users to have more choices? Mary Ann Richardson talks about nonexclusive...

1