- Subscribe to this page:
- RSS
- Email Alert
mary ann richardson
(599 results)-
Blog Post
Where is the AutoFormat As You Type feature in Word 2007?
November 11, 2008 12:00am PST
Word 2007 has relocated those handy AutoCorrect options, which is disorienting if you're used to earlier versions. See where to find the options -- or simply add buttons to the Quick Access...
5 Latest comment by lddeville
-
Blog Post
Bypass the Choose Builder dialog box when coding events in Access
November 11, 2008 12:00am PST
If you work only with event procedures, you can save yourself some time by making this small tweak in Access options.
-
Blog Post
Use custom field headers to create more professional Access reports
November 4, 2008 10:06am PST
Query-based reports give you the opportunity to turn those unfriendly field names into better-looking headers. See how this quick tweak can polish up your reports.
2 Latest comment by ttrollen@...
-
Blog Post
Quickly move data to another workbook without copy and paste
November 4, 2008 9:36am PST
Excel offers a fast, convenient way to transport data from one workbook to another. Here's a look at this simple technique.
31 Latest comment by stapleb
-
Blog Post
Control when Word 2007 updates links
November 4, 2008 9:14am PST
When you open a document, Word automatically updates any linked objects it contains, such as worksheet data. If you'd rather handle the process yourself, follow these steps to configure Word for...
5 Latest comment by Cre8tivmom
-
-
Blog Post
Calculate the total word count of a document - including text boxes
October 28, 2008 12:00am PDT
If you need to know how many words are in a document, and some of them are inside a text box, you'll have to perform at least one extra step. Here's a look at how to get the numbers you need.
-
Blog Post
Use Excel's spinners to analyze input value assumptions
October 28, 2008 12:00am PDT
The spinner offers an easy way to test different input variables to see the effect on a financial model -- without altering your underlying formulas. This example shows how to put this useful...
-
Blog Post
Create an Access form that lets users specify which data to print
October 28, 2008 12:00am PDT
You can easily add a custom form button that enables your users to choose which records to print. Mary Ann Richards steps through the process.
-
Blog Post
Use Word's Find and Replace feature to change text from Bold to Blue
October 21, 2008 12:00am PDT
You can expand the usefulness of Word's Find and Replace functionality by using it to remove and/or apply specified formatting throughout a document.
2 Latest comment by Tink!
-
Blog Post
Let Access calculate field values for you
October 21, 2008 12:00am PDT
There's no point in manually calculating a field based on the value in another field. With this simple form trick, you can have Access perform the calculation automatically.
4 Latest comment by Just_Learning
-
Blog Post
Use Excel's DGET function to let users zero in on the information they need
October 21, 2008 12:00am PDT
You can save your users considerable time (and eyestrain) by setting up a handy formula that tells Excel to display a specific cell entry for them.
2 Latest comment by fledis@...
-
Blog Post
Prevent users from inadvertently entering the wrong year in a worksheet
October 14, 2008 12:00am PDT
After typing 2008 for the past year, users are likely to slip up and type it instead of 2009 once January rolls around. Here's a simple Excel data validation trick to help catch those errors.
7 Latest comment by Willie11
-
Blog Post
Set up Access parameter queries to search for a character string
October 14, 2008 12:00am PDT
Make life easier for your Access users by building a parameter query that lets them search for specific text. Instead of fumbling around with wildcard characters, they can just enter the search...
12 Latest comment by Capo400
-
Blog Post
How to tell Word to print selected pages from different sections of a document
October 14, 2008 12:00am PDT
Choosing which pages you send to the printer is normally a straightforward process, thanks to Word's Page Range options. But if those pages belong to different document sections, you'll need to...
-
Blog Post
Calculate the value of your inventory in one step with this handy Excel function
October 3, 2008 12:00am PDT
Why use two formulas when one will do the trick? See how you can add and multiply values in one fell swoop with Excel's SUMPRODUCT function.
-
Blog Post
Create different mailings from the same list using Word 2007's Edit Recipients filter
October 3, 2008 12:00am PDT
See how a new mail merge feature in Word 2007 makes it easier to specify the records you want to include in a mailing.
-
Blog Post
Run a parameter query within an Access form
October 3, 2008 12:00am PDT
When your users need to run a parameter query while they're working in a form, this custom button will save them some time.
8 Latest comment by Noor110
-
Blog Post
Easy tricks to make your Access forms run faster
October 2, 2008 2:28pm PDT
By giving a form less data to digest, you can make it run more efficiently. These two tricks can help.
-
Blog Post
Change case in your Word documents with easy toggle shortcuts
September 30, 2008 12:00am PDT
One of the most common word processing chores is changing the case of text in a document. You can greatly streamline the process if you learn a couple of Word's most useful keyboard shortcuts.
10 Latest comment by nmurali
-
Blog Post
Transfer data from Word forms to an Excel worksheet
September 30, 2008 12:00am PDT
Avoid the hassle of manually importing Word form data into Excel. With the help of an Excel wizard, you can quickly step through the process.
10 Latest comment by mbandsb
