Microsoft Access Products and User Matrix

FMS offers a wide range of sophisticated, commercial off the shelf (COTS) products to maximize your investment in Microsoft Access. As the world's leading provider of 3rd party products for Access, we have extensive experience meeting the needs of the MS Access community. In fact, most of our products were inspired by the challenges we encountered ourselves.

We hope our products find a place in your toolbox so that you can operate at peak efficiency. Click here for a summary list and description of all the FMS Products for Microsoft Access.

Our products have many features, so it's difficult to describe them with a few words and pick how it's best for you. We hope you'll use this summary to identify products that are relevant to you, and dig deeper to discover why so many Access professionals use our solutions.

The boxes in Yellow are particularly appropriate for that product and user category.

		User Category
Product Name	Primary Feature	End User	Power User	Developer	Quality Assurance	Database Administrator
Total Access Analyzer	Analyze your databases for improvements. #1 Access add-in of all time!	Fix errors, learn and apply Best Practices	Learn and apply Access Best Practices	Find and fix problems before shipping	Find problems as part of testing	Helpful for taking over existing databases
Total Access Admin	Monitor who is in your database	maybe	for multi-user environments	Troubleshooting database corruption		See who's currently locking a database
Total Access Components	Enhance your user interface	Add cool features without coding	Dazzle your users; add a professional touch	The only collection of ActiveX controls for Access
Total Access Detective	Find differences between databases and objects	For data differences between tables	If you lost track of what you modified	Know exactly what changed between two databases or objects	Know what changed between versions
Total Access Emailer	Personalized email blaster can sends data & reports	Easily email everyone on your list	Email Access data and reports	Add and deploy email blasts in your applications
Total Access Memo	Rich text memo fields to forms and reports	Write and store formatted memos		Give your users the rich text memo fields they expect
Total Access Speller	Spell checker	Fix typos on report labels		Find and fix typos for your user interface	Find typos before shipping
Total Access Startup	Launch the right version of Access and your database		if building databases for others	Easily deploy new builds		Centrally manage DBs across a network
Total Access Statistics	Statistically analyze your data	Extend the power of Access queries	Add statistical values to your reports	Amaze your users with your number crunching ability
Total Visual Agent	Compact, backup, run macros, etc. on an automated schedule			If you're responsible for databases, you want this to run nightly	Schedule tasks	Make sure databases are kept healthy
Total Visual SourceBook	Royalty free source code library		great way to learn how to code	Why write code we've already written and tested?
Total Visual CodeTools	Code writing, cleanup, and delivery tools. Apply error handling and variable naming conventions.			Code builders and helpers you'll use continuously	Add line numbers to trap exactly where a crash occurs	Make sure your team uses this for consistent styles and error handling. Cleans up existing code
Total Zip Code Database	USPS zip codes for city & state lookup and fill	Enter a zip code and never type a city name again	Save time and eliminate typos	Deliver magic by auto filling city and state when users enter a zip code	Improve quality during data entry
Suites	Multi-product bundles		maybe	Absolutely!

Category Definitions

• End User
  Uses Access interactively for data collection, querying, reporting, etc. Does not program or write macros.
• Power User
  Uses Access interactively and able to create automated solutions with macros and rudimentary VBA.
• Developer
  Creates databases for use by others. Experienced with writing VBA modules. Creates multi-user solutions across a network and/or deployed to other sites. Concerned about quality, maintainability, ease of deployment, and on going support. Interested in adopting best practices and providing features without always coding it from scratch.
• Quality Assurance
  Tests applications. Benefits from tools that assist with improving quality, reliability, and consistency. Burdened with proving mistakes and crashes are real and reproducible.
• Database Administrator
  Ensures that applications are properly maintained, backed up, compacted, etc. after they are deployed. Also concerned that best practices are used when new users and developers are added, and when old ones leave.