mary ann richardson

Blog Post

Add a button to an Access form that tells you which version is running

March 10, 2009 8:57am PDT

Users don't always know what version of Access they're using -- which can slow things down when you're helping troubleshoot a problem. Make it easy for them (and for you) by creating a convenient...

2 Latest comment by Marshwiggle

Blog Post

OneNote 2007: If you can print it, you can mark it

March 10, 2009 8:51am PDT

You can easily annotate or draw on printable content with the help of OneNote -- which is a great help when you're collaborating on a project. Mary Ann Richardson explains how to take advantage of...

Blog Post

Organize your Inbox by converting Outlook 2007 e-mail into tasks

March 3, 2009 9:20am PST

When you receive e-mails you need to act on -- but not right away -- consider turning them into tasks, complete with follow-up reminders.

18 Latest comment by dr.vick

Blog Post

Instead of queries, use the Access 2007 PivotTable view

March 3, 2009 8:38am PST

Access 2007 lets you create pivot tables without building a query. See how this feature can simplify your data analysis.

2 Latest comment by aaiii

Blog Post

Open multiple Word 2003 documents in one window

March 3, 2009 8:20am PST

Consolidate and streamline your Word document display to avoid the clutter of individual application windows.

3 Latest comment by kmcpanama@...

Case Studies

HP BladeSystems Cut Operational Costs, Save Energy and Aid Managed Services Delivery for Telstra International

March 1, 2009 12:00am PST

Telstra International, a leading global telecommunications provider, delivers global network connectivity and a broad portfolio of scalable data hosting and managed services to enhance the...

Provided by: Hewlett-Packard (HP)

Blog Post

Use Word to type on a printed form without a typewriter

February 24, 2009 8:25am PST

There's no need to manually scrawl your way through a paper form. Convert the form to an online image you can fill out using Word.

73 Latest comment by jhmcmullen

Blog Post

Add information from related tables to your Access totals queries

February 24, 2009 8:01am PST

Totals queries can be a little limited in the information they include. Here's a trick that will make them a little more useful.

3 Latest comment by danidina7@...

Blog Post

Use Excel's REPT function to visually display data comparisons

February 24, 2009 6:36am PST

This cool trick uses the REPT function in a slightly unorthodox way: to create a worksheet-style 'progress bar' that presents a quick visual comparison of data in specified cells.

8 Latest comment by N / A

Blog Post

Create a self-running PowerPoint presentation

February 17, 2009 3:45pm PST

Setting up a presentation to run all by itself -- at a kiosk, say, or on your Web site -- requires just a few steps. Mary Ann Richardson explains how to set slide transitions and configure the...

Blog Post

Let Access enter today's date automatically

February 17, 2009 3:18pm PST

Your users shouldn't have to manually type the current date over and over into an Access form. Save them some time and effort by automating the process.

8 Latest comment by Dayle1011

Blog Post

Make your Access reports more readable by numbering detail items

February 10, 2009 1:44pm PST

One simple way to improve your report design is to number each item. Mary Ann Richardson steps through an example that demonstrates this technique.

1

Blog Post

Clean up your data with this easy-to-use Excel function

February 10, 2009 1:34pm PST

Here's a truly efficient way to get rid of garbage characters that have tagged along with imported data: Just let the Excel CLEAN function remove them for you.

3 Latest comment by trueseek1@...

Blog Post

How to space controls evenly across an Access form

February 3, 2009 2:33pm PST

Access offers a handy command that makes it easy to give your forms a more polished look. See how equally spacing controls can improve the effect.

Blog Post

Create a custom PowerPoint presentation from a set of slides

February 3, 2009 2:14pm PST

Custom presentations enable you to deliver a selection of slides from your main show -- handy if you're pressed for time or need to tweak the information for a particular audience. See how easy it...

6 Latest comment by km1@...

Downloads

Use Excel's Text To Columns command to separate first and last names

February 2, 2009 12:00am PST

If you need to split a list of names into two columns, you don't have to do it manually. See how this Excel wizard can quickly knock out the task for you.This download is also available as an...

Provided by: Mary Ann Richardson

Blog Post

Use Excel's Text To Columns command to separate first and last names

January 27, 2009 3:18pm PST

If you need to split a list of names into two columns, you don't have to do it manually. See how this Excel wizard can quickly knock out the task for you.

75 Latest comment by excelinexcel

Blog Post

How to convert imported text into numbers

January 27, 2009 3:02pm PST

Reformatting data you've imported into Excel can be tricky if it comes in as text. Here are two tricks for working around this problem.

2 Latest comment by jpol99

Blog Post

Enhance your training with online interactive slide shows

January 27, 2009 2:19pm PST

Let your users watch instructional presentations at their own pace. Using PowerPoint's slide show setup options, you can easily make a presentation viewable online.

Blog Post

How to delete space above a column to even up the text

January 27, 2009 2:08pm PST

Word's spacing options can throw your text out of alignment if you have multiple columns. Here's a quick fix that will even things up.