mary ann richardson News and Other Resources

Articles

Use one-way Excel tables to analyze data

April 20, 2005 1:38am PDT

Analyzing data doesn't have to be a headache-inducing endeavor. This example shows how you can use Excel's one-way tables feature to determine if a project will come in under budget without a lot...

9 Latest comment by Tony Hopkinson

Articles

Add page numbers to an Access report

April 20, 2005 1:27am PDT

When you create a report from scratch in Microsoft Access, sometimes you don't get to utilize all of the handy benefits of the report wizard. For instance, learn how to manually add the page...

5 Latest comment by jsamford

Articles

Prevent hidden text from printing in Word

April 20, 2005 1:00am PDT

If you need to print Word documents that contain sensitive information or notes that you don't want to be made public, you can simply hide the text that you don't want printed. Learn how to...

5 Latest comment by jbanwarth@...

Articles

Create a form-type Data Access page in Access

April 12, 2005 2:38pm PDT

It would be useful if your mobile users could view and edit data from their Access database anywhere, anytime from their mobile devices. Learn how to do just that by creating a form-type Data...

Articles

Customize workbook printing in Excel

April 12, 2005 2:12pm PDT

If all of your Excel spreadsheets need to contain a certain header and must print in a specific view, then you'll relish this time-saving trick. Mary Ann Richardson explains how you can create a...

12 Latest comment by mgmoreno

Articles

Change the default font in your Word documents

April 12, 2005 1:58pm PDT

If your client asks that all reports be in a specific Word font, you may grow weary of having to change the font each time you open a Word document. Check out how easy it is to select and set a...

8 Latest comment by Hommme

Articles

Add a Switchboard to your Access application

April 6, 2005 1:57am PDT

Most IT pros use the Database Window in Microsoft Access to access forms and reports. Mary Ann Richardson explains why a better method is to create a Switchboard, which allows users to go directly...

11 Latest comment by anty1

Articles

Make subtotal values stand out in Excel

April 6, 2005 1:03am PDT

When using Data | Subtotals to summarize data in your Excel worksheets, the more columns there are between the resulting subtotal labels and their values, the harder it is to read the data. Here's...

4 Latest comment by atlituba@...

Articles

Create a shortcut key for printing selected text in Word

April 6, 2005 12:51am PDT

When you want to print a selected portion of text in Microsoft Word 2002 or 2003, it would be nice if you didn't have to use the Print menu every time. Find how out how you can make this process...

13 Latest comment by minnetonkacje

Articles

Use a query to check referential integrity in Access

March 30, 2005 2:36am PST

Learn how to create a select query to find records in one table that don't have related records in another table. This capability will save you loads of time when you need to query data.

Articles

Open Excel without a blank workbook

March 30, 2005 2:17am PST

Tired of opening Excel from your desktop shortcut and seeing an empty workbook? Then follow these step-by-step instructions to create an application that will not display an empty workbook.

17 Latest comment by Danzo87

Articles

Use Handwriting Recognition to sign letters in Word

March 29, 2005 11:09pm PST

Word 2002's Handwriting Recognition feature allows you to use a pen and electronic tablet or a mouse to add a signature to your documents. Find out how you can start adding this feature to all...

16 Latest comment by nallanp2003@...

Articles

Resize text in Word with keyboard shortcuts

March 22, 2005 5:12pm PST

When you're testing out various font sizes to see which one looks best in your Word document, it can be cumbersome to use the Font menu or the Formatting toolbar. Learn how a few keyboard...

17 Latest comment by esvlwg@...

Articles

Add data validation to an Access form

March 22, 2005 4:54pm PST

All is not lost if you didn't set data validation for a field during table design. See how you can add data validation to an Access form in four simple steps.

3 Latest comment by PLWarrior

Articles

Use index sheets to quickly navigate in an Excel workbook

March 22, 2005 4:40pm PST

Navigating through dozens of sheet name tabs in Microsoft Excel to find the one you need can be quite time consuming. Cut your navigation time in half by creating index sheets that contain a list...

114 Latest comment by jwmccoy

Articles

Create an AutoLookup query in Microsoft Access

March 15, 2005 5:31pm PST

Microsoft Access allows you to base a form on an AutoLookup query that will automatically fill in customer information once you enter the CustomerID. Learn how to create an AutoLookup query.

12 Latest comment by BigLicia21@...

Articles

Add the Watch Window toolbar to your Excel spreadsheet

March 15, 2005 5:14pm PST

An easy way to track when changes are made to cells in Excel is to add the Watch Windows toolbar to your spreadsheet. This helps you tell at a glance the current value of the cells you specify.

4 Latest comment by anty1

Articles

Mixing column and paragraph formats in Word documents

March 15, 2005 4:48pm PST

Having trouble trying to figure out how to feature column and paragraph formats within the same Word document? It's simple when you follow these six steps.

8 Latest comment by DoctorDisk

Downloads

The Test Factory 4.8 (Mac)

December 6, 2004 12:00am PST

The Test Factory is a desktop application that creates multiple choice tests that students may perform in a computer network setting or on a single station computer. In the network version a...

Provided by: Thinking Cap