mary ann richardson

Articles

Create a survey form in Word

May 30, 2006 7:00am PDT

One of the best ways to gauge user responses and collect data is with a survey. In this Word tip, Mary Ann Richardson explains how to create a customized survey form, step by step.

4 Latest comment by mcclassie

Articles

Forecast the future with Excel trendlines

May 30, 2006 7:00am PDT

Trying to predict the future based on past experiences, but you're lacking the right formula? If you've forgotten high school algebra, fear not. With trendlines, Excel can project future figures...

6 Latest comment by dale.hawkins@...

Articles

Prevent users from resizing Access report windows

May 23, 2006 7:00am PDT

Working with Access pop-up windows, dialog boxes, or forms that absolutely, positively must not be resized? Mary Ann Richardson explains how to use the Border Style property in Access 2002 and...

Articles

Prevent an Excel spreadsheet from displaying preliminary results

May 23, 2006 7:00am PDT

When figuring poll numbers, it's easy to jump to conclusions. However, conditional formatting will hide the results of your research until all the data is assembled. Whether you're electing your...

1

Articles

Move or resize multiple Word objects at once

May 23, 2006 7:00am PDT

A drawing in Word is more than the sum of its parts—that is, until you try to move it. Mary Ann Richardson shows you how to move or resize layered drawings or objects in Word without them falling...

1

Articles

Position a logo along the side of a page in Word

May 16, 2006 7:00am PDT

Objects created in WordArt may be convenient, but you can't move them around like other images. Mary Ann Richardson shows you how to get around this default setting by making the logo a floating...

4 Latest comment by FoothillsCG.com

Articles

Change an Access query's Default View Property to PivotTable

May 16, 2006 7:00am PDT

Are you still toggling Access queries back and forth between Datasheet and PivotTable or PivotChart views? Mary Ann Richardson shows you how to change the default view property of a query so it...

1

Articles

Change your Excel chart's number formats

May 16, 2006 7:00am PDT

When you use Excel's Chart Wizard to create a chart, by default the chart takes on the number formats used in the worksheet that includes the charted data. Mary Ann Richardson shows you a way to...

Articles

Prevent users from deleting or copying Access records by removing the record selector

May 9, 2006 7:00am PDT

If your users have restricted use of your Access records, it's essential that they not be allowed to print, copy, or delete particular records. Mary Ann Richardson shows how to protect the records...

8 Latest comment by Quadrance

Articles

Search for invalid data in your Excel file

May 9, 2006 7:00am PDT

When working in Excel, it's not unusual to accidentally enter data that's out of range for the file you're working in. Mary Ann Richardson shows how you can add the Formula Auditing toolbar with...

2 Latest comment by pweegar@...

Articles

Customize Word text wrapping with Edit Wrap Points

May 9, 2006 7:00am PDT

Not everything is modular and even. That's why Word's Edit Wrap Points feature lets you decide how you want your text to flow around your graphics—even if the images are irregularly shaped. Mary...

Articles

Prevent Access form labels from printing

May 2, 2006 7:00am PDT

Labels in Access documents may be helpful in conveying instructions, but some things are best left onscreen. Mary Ann Richardson shows how to keep Access form labels from winding up on your printout.

Articles

Create a combo box for users' data in an Excel chart

May 2, 2006 7:00am PDT

Combo boxes in Excel are handy because they allow individual users access to various ways to view data without changing the integrity of the information itself. Mary Ann Richardson explains how to...

4 Latest comment by lou.montoya1@...

Articles

Balance text in Word columns in three easy steps

May 2, 2006 7:00am PDT

When entering text into Word columns, it can be a battle trying to get the text to balance. Mary Ann Richardson explains how to let Word fight the battle for you and keep your columns in line.

4 Latest comment by shantelle1015

Articles

Personalize Word documents with the Mail Merge toolbar

April 25, 2006 7:00am PDT

Forget the form letters—Mail Merge is a handy tool for personalizing handouts, business documents, or anything you'd like to distribute by name. Mary Ann Richardson tells about how to use this...

1

Articles

Obtain quarterly records in Access with the DatePart function

April 25, 2006 7:00am PDT

How did your company's stock fare last quarter? Who came aboard during the first quarter last year? Mary Ann Richardson shows how to use the DatePart function in Access to obtain quarterly results.

2 Latest comment by Tony Hopkinson

Articles

Create an Excel chart that automatically updates with new data

April 25, 2006 7:00am PDT

Are you constantly changing your Excel chart's data range as new information becomes available? Mary Ann Richardson shows how to set up the chart to automatically update as you add new rows of...

15 Latest comment by excelhelp

Articles

Keep embedded charts off your worksheet printouts in Excel

April 18, 2006 7:00am PDT

You can print an embedded chart in Excel without its worksheet by simply selecting the chart and choosing File | Print or clicking the Print button, but did you know that you can print a worksheet...

Articles

Change a form's properties with Form View

April 18, 2006 7:00am PDT

Form follows function, and you can change the function—or properties—of a form by using Form View. Mary Ann Richardson teaches us how to format your Access form in Form View.

1

Articles

Quick tips for adding borders and shadows to pictures in Word

April 18, 2006 7:00am PDT

Make your pictures stand out in Word by adding a border and drop shadow. It's easier than you think—follow these six easy steps, and see how your pictures pop. It's easier than you think—follow...