mary ann richardson

Articles

Change the default properties of the controls in the Access toolbox

February 21, 2006 8:00am PST

When you find yourself having to change the default property of an Access control every time you place it on a form or report, it's time to change the default property. Here's how to change the...

Articles

Add pizzazz to your Word text with AutoShapes

February 21, 2006 8:00am PST

Rectangular text boxes may be fine, but sometimes your Word document needs a little something extra. Find out about the variety of non-rhomboidal AutoShapes available for your text—clouds,...

3 Latest comment by EdwardsL77

Articles

Prevent duplicate Excel entries within a range

February 21, 2006 8:00am PST

If you want to avoid duplicate entries within a range when you're working in Excel, then check out this tip from Mary Ann Richardson. You'll learn how to set it up and avoid redundancy.

Articles

Save time with multiple control selection in Access

February 14, 2006 8:00am PST

Whether you design forms or reports, you will most likely need to make the same modification to more than one control at a time. Fortunately, you don't have to modify each one separately. Here are...

1 Latest comment by Kays07

Articles

Create a shortcut to a custom Word template

February 14, 2006 8:00am PST

Here's how to create a desktop shortcut in Word that will open a new document based on the template of your choice with a few clicks of the mouse.

5 Latest comment by LewesMariner

Articles

Use custom views in Excel to enhance your presentations

February 14, 2006 8:00am PST

With Microsoft Excel's custom views, you can readily access whatever worksheet areas you need, which will help your presentations to flow. Here's how to get started.

9 Latest comment by MustafaEvans

Articles

Use SQL to quickly summarize Access data by group

February 7, 2006 8:00am PST

Summarize data in a table using an SQL statement. Using Access and these instructions, it's easier than you may realize.

4 Latest comment by Tony Hopkinson

Articles

Check out font colors with the Cycle Font Color button in Excel

February 7, 2006 8:00am PST

Using colors in Excel just got easier! Skip steps, save clicks and get chromatic! Mary Ann Richardson shows us how to use this easy Excel tool.

Articles

Position your Word tables attractively on a page

February 7, 2006 8:00am PST

When working in Word, it's easy to align your tables to the surrounding text without dragging them there. Follow these steps for a streamlined look.

4 Latest comment by RayJeff

Articles

Link a picture to your Access form

January 31, 2006 2:38pm PST

If you've ever added a logo or product image to an Access form, you know that an embedded form object can take up a lot of space in your database. Learn how to use an image's Linked property to...

Articles

Create a Table of Contents from any keywords or phrases in your Word document

January 31, 2006 8:00am PST

When you're creating a Table of Contents for your Microsoft Word document, it's easy to get muddled down into many complicated steps. However, find out how easy it is to create a TOC from any...

5 Latest comment by dhays

Articles

Use Excel's Autofill to generate a series of dates

January 31, 2006 8:00am PST

Isn't it frustrating to do a task manually in Microsoft Excel when you know there must be a faster and easier method for accomplishing your goal? One Excel feature that will save you time is...

4 Latest comment by LocoLobo

Articles

Create a command button to open an Excel spreadsheet from an Access form

January 10, 2006 3:27pm PST

It's common for users to go back to original documentation when they're working with records on a Microsoft Access form. See how easy it is to create a button on a form that uses a hyperlink to...

Articles

Add a Date/Time stamp to your Excel worksheets

January 10, 2006 3:21pm PST

Are you tired of manually entering a time and date formula into each of your Microsoft Excel worksheets? Then learn how to shave time off your Excel work by creating a named Date/Time stamp formula.

7 Latest comment by vo_yager

Articles

Set a table format for your entire Word document

January 10, 2006 3:07pm PST

If you often work on lengthy Microsoft Word documents that contain tables that are the same format, do you usually grumble when you have to reset the format? Learn how to ease your frustrations by...

4 Latest comment by jmaechtlen@...

Articles

Create a pop-up form in Access

December 6, 2005 7:53pm PST

If users need to access data that is not on their forms, you could add a subform; or, you can add a command button that, when clicked, will pop open the form that contains the necessary data. Find...

1

Articles

Cut down on worksheet typing with Excel formulas

December 6, 2005 6:54pm PST

Tired of typing the same list of items across a number of Excel cells for each worksheet you add to your workbook? Then learn how to create a named formula that will enter the data for you.

16 Latest comment by dnadeau@...

Articles

Distribute data evenly across your Word table's columns and rows

December 6, 2005 6:47pm PST

If you're having trouble reading the text in your Microsoft Word table, then you may want to override the default setting and add line spacing and realign data within table cells. Mary Ann...

1 Latest comment by crmf70@...

Articles

Ease Access database maintenance with these quick keyboard shortcuts

November 29, 2005 5:49pm PST

Database maintenance is a necessary evil. You can make this chore more bearable by utilizing the three simple keyboard shortcuts in this Microsoft Access tip.

Articles

Simplify your Excel formulas with named constants

November 29, 2005 5:38pm PST

If use a constant in your Microsoft Excel workbook formulas, such as sales tax or car mileage allowance, then check out how using a named constant can save yourself considerable time.

6 Latest comment by SmartLinkRAF