The FMS Professional Solutions Group continues to create innovative software solutions that are making an impact on organizations and lives. Check out our updated consulting site to learn more about our solutions in action. See how we are making a difference from disaster relief in Haiti and Chile to the recent snowstorms in Washington DC. Here are some other highlighted solutions:

Let us bring this expertise to help you use data to make better decisions.

The complete list of modules and procedures in our Total Visual SourceBook professional source code library is now available for your review. From the list of Microsoft Access/Office/VBA/VB6 modules, you can click on any item to get its details.

194 royalty-free modules and classes are available covering all aspects of application development. Learn more about what's available, so you can simply use our code rather than writing your own. It's all open source, so you can learn from it or enhance it to your specific needs.

The Microsoft Azure platform is now available for production use.

We've been using Azure over the past year for web/asp.net hosting and SQL Server solutions. We have been very impressed with its features and capabilties. We believe it will revolutionize how we create and deploy applications, and look forward to providing commercial and custom solutions and services with Azure.

We're already working on several projects including the merging of the Windows desktop/Microsoft Access/Office with the web. We look forward to sharing more with you in the near future.

What do you think about Azure and cloud computing?

Total Visual SourceBook is the most popular professional source code library for the Microsoft Access/VBA/VB6 community. This huge library of powerful, well tested, and documented VBA/VB6 source code is available for your projects royalty free! Eliminate the drudgery of writing code that already exists. Simply insert our code into your project and run it.

As part of our commitment to quality, we are pleased to announce that we have released a new update for Total Visual SourceBook 2007. This update resolves all known issues since their original release.

The updates are available free of charge to registered owners who were notified via email. If you did not receive instructions, please contact us so we can update your information. 

The FMS Advanced Systems Group has a new video for its Sentinel Visualizer program: An Introduction to Social Network Analysis (SNA). If you are trying to find hidden relationships among people, places, and events, Social Network Analysis can help.

Social Network Analysis is a subset of network theory that finds important relationships and centrality in complex networks. Learn how organizations in the law enforcement, intelligence, defense, finance, and other data intensive fields are using Sentinel Visualizer in their missions.

Here's more information on Sentinel Visualizer and its Link Analysis features.

Total Access Statistics is the world's most popular data analysis program for Microsoft Access. It runs as an Access add-in to let you extend the numerical analysis capabilities of Microsoft Access queries.

A common need among MS Access users and developers is the need to calculate percentiles. We've created a new page providing more details on how to Calculate Percentiles in Microsoft Access with Total Access Statistics. Percentiles can be generated on the data from your table or query, and are provided in three ways:

• A new table with each percentile value as a separate field
• A new table with each percentile value as a separate record
• Updating a field in your table with the percentile value corresponding to the data in your record

Download the Total Access Statistics trial version to see for yourself on your own data.

Total Access Detective is our popular Microsoft Access database, object, and data comparison product. Compare any two databases or two Access objects in one database to pinpoint exactly how they are different. As part of our commitment to quality, we are pleased to announce that we have released new updates for:

• Total Access Detective 2007 (version 12.0)
• Total Access Detective 2003 (version 11.7)
• Total Access Detective 2002 (version 10.7)
• Total Access Detective 2000 (version 9.7)

These updates include performance enhancements, Windows 7 support, improved ADP support, and resolve all known issues since their original release. For more details, visit the Total Access Detective Updates page.

The updates are available free of charge to registered owners who were notified via email. If you did not receive instructions, please contact us so we can update your information.

Total Visual SourceBook 2007, the most popular professional source code library for Microsoft Access, Office and Visual Basic 6 is shipping with an expanded code base and improved code manager. With 194 modules/classes and over 100,000 lines of code, Total Visual SourceBook lets you add our well written, documented, and tested code into your VBA/VB6 projects royalty-free. Includes full support for Access 2007, lots of new code for Outlook 2007, Office 2007, the web, etc. Learn more about Total Visual SourceBook and why so many developers use and learn from our years of experience creating professional quality solutions:

• New Features
• Overview and Screenshots
• Code Categories
• Complete List of Modules and Classes
• Sample Code (Example of Date/Time Calculations)

Professor Kathy Korman Frey at the George Washington University School of Business has kicked off the 2009-2010 HotMommas Case Study Competition. It is a unique project that takes the stories of the women and makes them teachable in a "case study" format, thus providing scalable, global access to role models and virtual mentors. You may recall us mentioning our work on this project not long ago.

If you want to nominate someone (yourself included) for the 2009-2010 competition, go to the HotMommas Facebook page or send an email with their information.

Links

The HotMommas Project

Nomination Form

Why Role Models Matter for Women and Girls

Hot Mommas Project Everyday Revolutionaties

Washington Post article

Here's another resource in our ongoing coverage of query techniques:

Learn how to create queries to find all the records in one table that don't have corresponding records in another table. If you're not familiar with the difference between INNER JOIN, OUTER JOIN, LEFT JOIN and RIGHT JOIN, check out this new paper on these important query feature. It'll save you tons of time trying to code this yourself and will surely give you new ideas on how to better retrieve and analyze your data. The techniques apply to both Microsoft Access and SQL Server queries.