mary ann richardson

Blog Post

Add a watermark to your Word 2007 document

September 25, 2007 12:00am PDT

Word 2007 includes a number of predefined watermarks that you can add to your document without any additional formatting. Here's how to set them up.

3 Latest comment by miross

Blog Post

Hide Access database objects from unauthorized users

September 25, 2007 12:00am PDT

If you're working on a new Access form for your database that you don't want released to the public just yet, you can prevent others from accessing this form. Mary Ann Richardson explains to hide...

4 Latest comment by danrev99@...

Blog Post

Create professional-looking page borders in Word 2007

September 18, 2007 12:00am PDT

Whether you're creating a flyer for your company bulletin board or the cover page for your quarterly department report, adding a professional-looking page border can help attract attention to your...

10 Latest comment by martha.lapierre@...

Blog Post

Format Excel column charts to match data series values

September 18, 2007 12:00am PDT

It would be great if you could change the color of certain Excel columns so they would stand out; unfortunately, Excel does not support conditional formatting of data series objects. Instead,...

3 Latest comment by helmma

Blog Post

Add more white space to long Access reports for better readability

September 18, 2007 12:00am PDT

The more records output to an Access report, the harder it becomes to read. When you see your employees taking out their rulers to read your reports, it's time to add some white space between the...

7 Latest comment by richard.morgan@...

Blog Post

Replace Access navigation bars with a command button for easier data entry

September 11, 2007 12:00am PDT

When designing a data entry form, it's a good idea to replace the navigation bars with an Add New Record command button. A conveniently placed button not only makes it easier to enter data, but it...

4 Latest comment by ssharkins@...

Blog Post

Automatically add new data to an Excel chart

September 11, 2007 12:00am PDT

Once you go through all the work of creating and formatting a chart, you don't want to have to start over again when new data comes in. Fortunately, you don't have to with Excel. You can simply...

3 Latest comment by erins.ghost@...

Blog Post

Format Word 2007 documents using Change Case and Clear Formatting commands

September 11, 2007 12:00am PDT

Word 2007's Ribbon has two commands -- Change Case and Clear Formatting -- that make formatting easier. Mary Ann Richardson explains how you can use Change Case to change text case from upper to...

3 Latest comment by frank_s

Blog Post

Use Word's Tabs dialog box to set multiple tabs

September 4, 2007 12:00am PDT

Measure twice, cut once -- or, in the case of Word tabs, get rid of the ruler entirely. Mary Ann Richardson explains how you can use the Tabs dialog box to easily set multiple tabs with one dialog...

2 Latest comment by islandjiXi

Blog Post

Group Excel charts together for displaying, copying, and pasting

September 4, 2007 12:00am PDT

Here's how to link two or more Excel charts together for easy manipulation within a document or presentation.

Blog Post

Illustrate data tables using Excel charts

August 28, 2007 12:00am PDT

Charts are an easy way for people to easily assess your data, but you may run into trouble including data tables in your Excel form. Here's how to illustrate data tables using Excel charts.

2 Latest comment by jimit.7830@...

Blog Post

Save time with these Word 2007 edit options

August 28, 2007 12:00am PDT

Word 2007 has some neat new features, including the ability to format your document the way you want. Unfortunately, sometimes when you edit, your document's formatting can get mixed up. Here's...

Blog Post

Compare two sets of Excel chart data using transparent columns

August 21, 2007 12:00am PDT

You may only have room on your desktop for one Excel chart, so how do you assess two charts without printing them both out? Learn how to make your charts transparent for easy data comparison.

5 Latest comment by RobinHackshall

Blog Post

Create a field for a changing Access data table using the Lookup Wizard

August 21, 2007 12:00am PDT

When information changes, it may be a challenge to ensure that the facts are consistent everywhere. With Access, you can make sure this is the case by using the Lookup Wizard to create a field for...

Blog Post

Set [Tab] to correctly indent your paragraph in Word

August 21, 2007 12:00am PDT

Sometimes the [Tab] key in Word works a little too efficiently, indenting sections and paragraphs you don't want moved. Mary Ann Richardson guides you through the pitfalls -- and benefits -- of [Tab].

11 Latest comment by gmdp

Blog Post

Linking multiple list boxes in Access

August 14, 2007 12:00am PDT

Access' list boxes are handy for referencing particular records, but they can quickly get out of control. Here's how to link certain list boxes together, eliminating the need for time-consuming...

2 Latest comment by tanyaacatherine@...

Blog Post

Customize the Word 2007 Ribbon with these quick tips

August 14, 2007 12:00am PDT

Is the Word 2007 Ribbon getting unwieldy? Mary Ann Richardson explains how you can put your most used commands on the Ribbon -- or move it altogether.

3 Latest comment by webweasel2@...

Blog Post

Monitor performance with Excel 2007's conditional formatting

August 14, 2007 12:00am PDT

Red means stop, green means go, yellow means watch out. By employing this principle, you can monitor data and inventory performance -- green for good, red for not-so-good -- across your Excel 2007...

Blog Post

Change Excel 2007 spreadsheets to tables for easier data analysis

August 7, 2007 12:00am PDT

Excel spreadsheets may be good for calculations, but reading them can be challenging. Here's how to convert your Excel 2007 spreadsheets to easy-to-read tables.

Blog Post

Assemble professional documents with Word 2007's building blocks

August 7, 2007 12:00am PDT

Now that you've written your report, make it pop. Mary Ann Richardson explains how you can put together a great-looking document in a hurry using Word 2007's built-in components.