Feb 27

The Hot Mommas Project Website Update

HotMommas Web SiteLongtime client Kathy Korman Frey, George Washington University School of Business professor and GWU Entrepreneur in Residence, has engaged the FMS Professional Solutions Group to enhance her HotMommas Project website.

The site is the world's largest collection of public case studies for entrepreneurial women. It is a community where women can learn from the experiences of other women addressing their businesses, family and personal challenges.

Visual Studio
The revamped website is built on Visual Studio .NET, SQL Server with a modern, dynamic interface incorporating our technical and graphic artist resources.

Contact us if we can help you with a similar solution.

Feb 24

Microsoft Access Free Book Offer with FMS Product Suites

Access 2010 Programmer's Reference (Wrox Programmer to Programmer)

by Teresa Hennig, Rob Cooper, Geoffrey Griffith, and Jerry Dennison

Written by our long-time friends who are Microsoft MVPs and members of the Microsoft Access development team, Teresa Hennig, Rob Cooper, Geoffrey Griffith and Jerry Dennison wrote Microsoft Access 2010 Programmer's Reference, which also applies to Microsoft Access 2007.

Thanks to a special arrangement with the authors and their publisher, Wrox, we are pleased to offer a limited quantity of this book for FREE to purchasers of any of our Access product suites. A $45 value.

Simply purchase one of these suites:

and click here to add it to your cart, or mention this offer when ordering.

Terms and Conditions plus more information

Feb 23

FMS Participates with Virginia Governor’s Declaration of 2012 as the Year of the Entrepreneur

Yesterday, FMS President Luke Chung was invited by the governor’s office to participate in his proclamation of 2012 as the Year of the Entrepreneur. Luke stood behind Governor Bob McDonnell and Lieutenant Governor Bill Bolling during the press conference and participated in a day-long event supporting entrepreneurship, small businesses, and job creation.

Commerce Secretary James Cheng led the events. Participants were able to hear from successful Virginia business founders and learn from each other through a luncheon and Entrepreneurial Town Hall. Examples of agricultural, technology, manufacturing, and craft businesses showed the diversity of Virginia firms offering products and services for in-state, national and international customers. It was also interesting to trace the roots of the founding of Virginia in 1607 as a high-risk entrepreneurial enterprise that eventually led to success after many failures.

All parties recognized the value and responsibility of seasoned entrepreneurs helping newer entrepreneurs, and how fundamental this was to the success of our state and nation. Activities will occur around the commonwealth over the year where government representatives and entrepreneurs share their ideas, experiences, and resources. Already recognized as one of the most business friendly states in the country with one of the lowest unemployment rates, Virginia continues to foster business success in a bipartisan manner.

Noteworthy was the inclusion of Education Secretary Laura Fornash in the activities stressing the importance of public education as part of a healthy business climate. This includes having great K-12 education and the many higher education institutions across Virginia. Those institutions attract bright students from outside Virginia, create entrepreneurial opportunities around them, and give us the ability to keep them in Virginia for life. FMS and Luke Chung are honored to be a part of this initiative.

For more information visit:

Feb 16

Linked In Communities for the Microsoft Access, Azure, SQL Server and Visual Studio .NET Communities

LinkedInLinkedIn offers many opportunities for professionals to interact with each other. There are many groups available for the Microsoft Access, Azure, SQL Server, and Visual Studio .NET communities. Here are some of the vibrant groups we’ve discovered:

Microsoft Access, Excel and VBA

Microsoft AzureMicrosoft Azure and SQL Server


Visual Studio .NET

Feb 13

Transposing Data in Microsoft Access Tables and Data Normalization

Microsoft AccessMicrosoft SQL ServerData normalization is fundamental to database design. Properly normalized data makes it easy to support an application over time and simplifies the querying, displaying, and reporting features of an application. 

Unfortunately, we don’t always receive or have normalized data. Tables that require adding fields as the data changes over time are particularly problematic and violate the basic premise of database design where adding records is free, but adding fields is expensive:

Here are some updated resources detailing the value of data normalization, including a sample database and VBA code to transpose and normalize your existing data.

These and other related papers are part of our developer centers:

Hope these help you create more scalable, maintainable, and analyzable databases.

For advanced data analysis, check out our Total Access Statistics add-in product.

Feb 09

Free Preview of Total Access Analyzer for Microsoft Access 2010 Database Documentation

Microsoft Access 2010Microsoft Access Database DocumentationMicrosoft Access Database DocumentationMicrosoft Access Documenter

The Microsoft Access 2010 version of Total Access Analyzer is close to shipping and we are pleased to offer a FREE preview for you to try it.

Total Access Analyzer is the most popular Microsoft Access add-in and the winner of every Best Microsoft Access Add-in award ever. With Total Access Analyzer, you can truly understand what's going on in your database. Generate comprehensive documentation of all your database objects, get detailed table and field lists, module code printouts, form and report blueprints, and much more. Get detailed cross-references for how objects are linked to each other so you know exactly where each table, query, form, report, macro and module procedure is used. The Application Flow, Data Flow, and Object Flow Diagrams show how code and objects flow across your entire application. Over 300 professional quality and customizable reports are available.

Almost 300 types of issues are uncovered to pinpoint errors, suggest design improvement, and recommend performance tips. Find unused objects, missing field references, unused code and many other things that should be fixed before you deploy your applications. Many of the tips are recommended Best Practices for Access development, so you'll learn how the pros improve their design and development techniques.

We've added many new features to support Access 2010, generate more useful documentation, identify more errors, and suggest more design improvements and best practices. We've also improved the user experience with the ability to open a cross-referenced item in design mode while viewing the information, previewing multiple reports at once, and adding color to all reports. Here is a description of new features.

Take this opportunity to learn what Total Access Analyzer can do for you. See how it documents your databases and identifies errors and opportunities for improving them at the object and code levels. Discover why so many Access users and professionals rely on the program to deliver and create more robust solutions.

The preview version is available for immediate download and is fully functional. It expires on March 15, 2012.