- Subscribe to this page:
- RSS
- Email Alert
mary ann richardson
(600 results)-
Blog Post
Create an Access form that calculates how many months a project has been underway
September 30, 2008 12:00am PDT
Set up a simple form that can quickly tell you how long you've been working on a project. Mary Ann Richardson walks through the process.
-
Blog Post
Work with your files without leaving Word
September 23, 2008 12:00am PDT
Word's Open dialog box is full of functionality that lets you perform all sorts of file tasks. See how to take advantage of this convenient -- and sometimes essential -- approach to file management.
11 Latest comment by soalla-bell.derek.s@...
-
Blog Post
Stay current on all daily transactions with the help of Excel functions
September 23, 2008 12:00am PDT
With a handful of well-constructed formulas, you can keep on top of the latest information in your Excel worksheets.
1
-
Blog Post
Transfer data from a Word form to an Access table using the Import Text Wizard
September 23, 2008 12:00am PDT
When you've collected info via a Word form, you don't have to manually enter it into Access. Mary Ann Richardson steps through an example that demonstrates the wizard way to knock out the task...
-
Blog Post
Add upcoming renewal dates to your Access database
September 16, 2008 8:40am PDT
Calculating future dates in Access is easy, thanks to the DateAdd function and SQL UPDATE command. Mary Ann Richardson walks through an example to demonstrate this technique.
-
-
Blog Post
What to do when you can't change the tabs from Word's ruler
September 16, 2008 8:21am PDT
If you're trying to format a selection of paragraphs that have different indents, Word won't let you set tabs for all of them using the handy ruler shortcut. Here's a trick for getting around this...
1
-
Blog Post
Let Access tell your customers when their orders have been shipped
September 9, 2008 7:05am PDT
Your customers will appreciate it if you send them a shipping notification. See how a little command button magic allows you to automate the process in your Access forms.
-
Blog Post
Convert measurements to metrics in Excel
September 9, 2008 6:56am PDT
Excel offers a function that can save you all kinds of time when you need to convert measurements. Here's a look at how you can put this function to work.
3 Latest comment by martian@...
-
Blog Post
Use Word bookmarks to make addressing envelopes a snap
September 9, 2008 6:48am PDT
Word offers special bookmarks that let you automate the process of addressing your envelopes. Mary Ann Richardson explains this handy feature.
-
Blog Post
Give your Word documents a professional look by adding symbols
September 2, 2008 12:00am PDT
The smallest details often make a big difference in the appearance of your documents. See how the simple trick of adding a couple of special characters can improve your page design.
1 Latest comment by Tink!
-
Blog Post
Let users view Web pages from within an Access form
September 2, 2008 12:00am PDT
Your users don't have to waste time bouncing between Access and a Web browser. See how to add a control that lets them browse without ever leaving their form.
-
Blog Post
Use a single mailing list to send out two entirely different letters
August 26, 2008 12:00am PDT
Thanks to Word's mail merge fields, you can automate the process of producing different letters based on criteria you specify. This example shows how it works.
-
Blog Post
Keep users up to date with an Access form marquee
August 26, 2008 12:00am PDT
Instead of sending out an incessant stream of memos and e-mails, present the latest bulletins within your users' forms. Here's how to set it up.
6 Latest comment by awadhass
-
Blog Post
Let Excel's conditional formatting keep you abreast of upcoming due dates
August 26, 2008 12:00am PDT
You can easily set up your worksheets to provide a handy reminder that deadlines are getting close. Here's a look at how to use conditional formatting to flag items in a specified timeframe.
2 Latest comment by alle11969@...
-
Blog Post
Import and convert Web text to columns in an Excel worksheet
August 19, 2008 12:00am PDT
Armed with a Web query and some conversion options, you can bring Web table data into a worksheet in a format you can use. This example walks through the process.
9 Latest comment by mattohare@...
-
Blog Post
Create a title style in Word to save time and mouse clicks
August 19, 2008 12:00am PDT
It's easy to define a custom style for your document titles -- and it will greatly simplify the task of formatting title text. Mary Ann Richardson explains how to do it.
-
Blog Post
Use color to flag Access form fields
August 19, 2008 12:00am PDT
Colorizing a form field can bring important data to your notice. Mary Ann Richardson details a trick that tells Access to change the color of a field depending on its value.
-
Blog Post
Use Access Query Totals to obtain a list of your customers' recent activity
August 12, 2008 12:00am PDT
When you need to round up data on when your customers last placed an order, an Access query can do the trick. Here's a quick walk-through that shows you how.
-
Blog Post
Adjust line spacing for more attractive borders
August 12, 2008 12:00am PDT
If you build a little space between your borders and text, the results will be better looking and easier to read. Here's a quick way to fine-tune the spacing so it's just right.
1 Latest comment by wfsaccounting@...
-
Blog Post
Use Excel 2007's Date feature to stay on top of deadlines
August 12, 2008 12:00am PDT
If you need a helpful reminder that project deadlines are looming, try this simple conditional formatting trick. Excel will highlight any dates that fall within the parameters you set.
