Product Guide for Total Access Speller

How many times has this happened to you?

You spend days, even weeks, working on Microsoft Access forms and reports. You check and re-check and make sure every button works, and every report is complete and accurate. The big day comes. You show your application to users, or send reports out to the company. And all that people remember is the spelling error you missed.

Total Access Speller is an add-in for Microsoft Access that makes it easy to spell check your object properties and designs. Although Microsoft Access includes a spell checker, it only handles data in tables. What about typos in your forms, reports, labels, captions, and validation text? No matter how much work you do to make your Access applications fast and reliable, if there are typos in your user interface or on your reports, that is what your users (and your boss) will remember.

Total Access Speller solves this problem by providing an easy-to-use wizard that allows you to spell check all properties that can contain text. Total Access Speller uses the Microsoft Office spell checker so your language and custom dictionaries are available. What’s more, Total Access Speller can automatically write spell check changes back to most object types automatically. There is simply no better way to ensure the professional quality of your Access applications.

Ensure Professional Applications

Creating Access applications takes time and effort. To create professional reliable applications, you spend time creating a data design, implementing tables and queries to drive data, and forms and reports to present that data to users. But no matter how much time you spend on design, performance optimization, coding and testing, all it takes is a few typos in critical areas and your application looks less than professional.

Performing spell checking manually takes forever and is prone to errors. And since Microsoft Access can only spell check data in tables, you are on your own in performing this critical quality check on your applications. Total Access Speller solves this problem by providing an automated spell checking solution for Microsoft Access.

How it Works

Total Access Speller is implemented as a Microsoft Access add-in. Simply open your database and select Total Access Speller from the Add-ins menu. The wizard form appears, making it easy to select the objects you want, perform spell checking, and save your results.

Total Access Speller performs spell checking on properties for the following object types:

• Tables and table fields
• Queries and query fields
• Forms, Controls, and Embedded Macros
• Reports, Controls, and Embedded Macros
• Macros
• User Defined Command bars

The built-in list of properties covers all properties that can contain text that appears in your application’s user interface, and you can enable or disable properties or add your own. With Total Access Speller, you are in complete control of spell checking.

Special Handling for HotKeys in Captions

Labels associated with form controls often have "&" to designate shortcut hotkeys. That can be in the middle of a word which would normally confuse a spell checker. Total Access Speller takes this into account to let you spell check the "true" word, then preserves your hotkey letter.

Applying Changes

After reviewing all the text for spelling, Total Access Speller writes your updates back to your database. A set of reports are available to document:

• Changes you attempted
• Changes that were successfully applied
• Changes that failed (maybe due to validation rules)
• Changes that have to be manually made (for instance, Access security prevents automated updates of macros)
• Any lost hotkeys if your change results in an existing hotkey letter to no longer exist in the caption

100% Guaranteed

Total Access Speller is 100% guaranteed to pay for itself the first time you use it. You will quickly find spelling errors in your applications that are easy to fix. And when you distribute your applications, you can do so knowing that there aren’t any typos! If you are not completely satisfied with Total Access Speller, return it for a complete refund.

Part of the Total Solution

Total Access Speller is a member of the award-winning family of Access add-ins that make your life easier. Like our Total Access Analyzer and Total Visual CodeTools products, Total Access Speller helps you deliver better Access applications in less time.

Versions and Pricing

Because of the differences in object properties and behaviors between Access versions, Total Access Speller is Access version specific. Total Access Speller works with all Access database formats supported by your Access version.

For instance, for Access 2010, Total Access Speller works as an add-in for MDB (Access 2000-2010 formats), Access Data Projects (ADP), and ACCDB (Access 2007-2010) databases.

Top Eight Reasons Why Total Access Speller Will Save Your Company Time and Money

1. Spelling Errors are a Fact of Life
   Even the simplest of Access applications contains multiple forms and reports, each with plenty of properties that can contain spelling errors. Nothing is worse than seeing an obvious typo show up on a program's form, or an important corporate report.
   
   
2. Microsoft Access Provides Absolutely No Help
   Even though Microsoft Access includes a built-in spell checker, it works only on data in tables. It does nothing for the forms and reports you create. So you are either on your own, or you can use Total Access Speller to solve your spelling problems once and for all.
   
   
3. Total Access Speller is Thorough
   Total Access Speller checks all the properties that can appear on forms and reports, making it easy to ensure you have professional applications. You can even add your own properties.
   
   
4. Using Total Access Speller Couldn't be Easier
   Total Access Speller comes as an Access add-in--start it right from the Access menu! Then use our super-simple wizard to select your objects, perform spell checking, and write changes to your objects. It couldn't be easier.
   
   
5. Never, Ever be Embarrassed Again!
   Only Total Access Speller gives you the solution to the nagging problem of spelling errors on forms and reports. No other product even attempts this.
   
   
6. Absolutely Risk Free Guarantee
   We are so confident in Total Access Speller that if it doesn't pay for itself in 30 days, return it for a prompt and courteous refund.
   
   
7. Professional Documentation
   All FMS products come with a professional user guide and extensive online help: learning and using our products couldn't be easier.
   
   
8. FMS is the World Leader in Access products
   No other Access company has been around longer than FMS. No other Access company has won more awards than FMS. We have shipped our commercial products since 1987. You can buy from FMS with confidence.