mary ann richardson

Blog Post

Easily change a picture's shape and shadow in Word 2007

November 6, 2007 12:00am PST

In Word 2007, you can preview a change you'd like to make to a picture, such as rounded corners or a drop shadow, before you actually apply it. Mary Ann Richardson explains how.

Blog Post

Create a macro for printing multiple Access reports

November 6, 2007 12:00am PST

Did you know that you can create a macro to print a number of Access reports all at once? Mary Ann Richardson shows you the steps.

5 Latest comment by john.nealis@...

Blog Post

Help users get to their Excel workbooks quickly

November 6, 2007 12:00am PST

Rather than having your employees navigate through different folders to get to their Excel workbooks, allow them to place them all into their Favorites folder. Follow these steps to make it easier...

4 Latest comment by LocoLobo

Blog Post

Use Access menus to add page numbers, dates, and times to your reports

October 30, 2007 12:00am PDT

In Access, you can use menus to add page numbers, dates, and times to your reports -- and Access provides menus so that you don't have to know the code for setting these controls. Here's how to...

Blog Post

Export your VBA code for use in another Excel application

October 30, 2007 12:00am PDT

After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply...

2 Latest comment by shanu.vb

Blog Post

Prevent users from changing data by using Access form control properties

October 23, 2007 12:00am PDT

Access allows you to prevent users from inadvertently changing data on their forms. Here's how to set the control properties called Enable and Locked to prevent data entry.

Blog Post

Save time in Excel with automated reports

October 23, 2007 12:00am PDT

You can use Excel programming to automate a lot of your employees' monthly reporting. For example, if your employees submit a monthly travel expense report, learn how you can develop an...

18 Latest comment by wizard57m-cnet

Blog Post

Change the default font in Word 2007

October 23, 2007 12:00am PDT

Word 2007's Normal template uses a new default font, Calibri 11. If you have been using Times New Roman or Arial 12 as your default font, you still can -- just change the default. It's easy --...

4 Latest comment by Larry@...

Blog Post

Keep Word headers and footers from overlapping your document's text

October 16, 2007 12:00am PDT

When you find your header is almost overlapping the first line of text in your Word document, you do not need to make your header smaller; you need to increase the distance of the header text from...

Blog Post

Have Access automatically print your reports

October 16, 2007 12:00am PDT

If you need to print out an Access report by 10:00 every Friday morning, you don't have to do it manually. Follow these steps to create a macro to print the report and schedule it to run at that...

12 Latest comment by jteeple@...

Blog Post

Add autonumbering to your Excel spreadsheet

October 16, 2007 12:00am PDT

Unlike Access, Excel does not have an autonumbering feature that increments a number each time you add a new row. With Excel 2003 and 2007, you can use the Row function to add your own...

16 Latest comment by noemir

Blog Post

10+ tips for boosting your Word 2007 productivity

October 11, 2007 7:53am PDT

If your users have recently made the jump to Word 2007 -- or an upgrade is just around the corner -- you could be in for a lot of hand-holding. We've put together a collection of tips from our...

1

Downloads

10+ tips for boosting your Word 2007 productivity

October 11, 2007 12:00am PDT

If your users have recently made the jump to Word 2007 -- or an upgrade is just around the corner -- you could be in for a lot of hand-holding. This collection of tips from our Office Suite...

Provided by: Mary Ann Richardson

Blog Post

Include an attachment field with your Access 2007 database

October 9, 2007 12:00am PDT

With Access 2007's new attachment fields, you can attach most file types to your database records for better illustration of your data across reports. Mary Ann Richardson explains how you can...

4 Latest comment by vevans@...

Blog Post

Use Word 2007's new Reading Highlight feature to highlight words in your document

October 9, 2007 12:00am PDT

If you've ever wished you could use Word's Find feature to search for a particular word and highlight all occurrences of that word, then have the document stay highlighted even after you turn off...

5 Latest comment by rachelps

Blog Post

Differentiate pie slices with Excel's Bar Of Pie chart option

October 9, 2007 12:00am PDT

Too many tiny slices? One way to make your Excel chart more coherent is to use the Bar Of Pie chart option. The bar of pie chart displays the tiny pie slices into a horizontal bar chart so they...

13 Latest comment by gerila_7@...

Blog Post

Formatting Yes/No fields in Access reports

October 2, 2007 12:00am PDT

Check boxes are fine for data entry, but you may not want to use them on a formal report. Follow these steps to create a report that replaces check boxes with specific word properties.

1 Latest comment by ssharkins@...

Blog Post

Transfer information to other documents using Word 2007's View Side By Side feature

October 2, 2007 12:00am PDT

When you need to copy information from one Word 2007 document to another, you could copy and paste -- or, you could just right-click and drag the information from one document to another. Word...

7 Latest comment by Ron_007

Blog Post

Set up minimum and maximum markers on Excel line charts

October 2, 2007 12:00am PDT

When working with an Excel chart, you may wish to emphasize which month had the most sales and which month had the least sales. You could manually add a text box or other graphic to the...

3 Latest comment by shwe

Blog Post

Use stacked Excel charts to compare data over time

September 25, 2007 12:00am PDT

When you need to present two or more Excel charts of similar items, rather than present them separately, stack them together so that they are easier to compare. Follow these steps to create a...

8 Latest comment by SheaJeff