Nov 15

Total Access Analyzer Product Review

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

Geoff Hollander of Northwest Database Services and the Portland Access User Group wrote a review of our Total Access Analyzer product. He provides a nice discussion of how it finds ways to improve his Access applications:

"I always thought that I was thorough about going through an application and cleaning up loose ends, but Total Access Analyzer proved: I was wrong and I probably won't call another application complete until Total Access Analyzer gives it the OK."

He also suggests how the documentation it generates and its reports are a business opportunity:

"Selling a documentation package generated by Total Access Analyzer for your application is a great way to add a training-free, trouble-free and reasonably priced profit center to the work you are already performing!….Total Access Analyzer is a solid product that any Access developer should have in their toolbox; and one that will pay for itself in short order."

Read the complete review

Nov 09

Microsoft Access Append Query Examples and SQL Syntax

We've enhanced our Microsoft Access Query Help Center with a new paper describing Microsoft Access Append (Insert) Queries, and how to use them to add multiple records or a single record to a table.


We also discuss why rather than using a Make Table query, it's preferable to use an existing table, empty it, then fill it with an Append query.

Oct 13

The HotMommas Project Case Study Competition Website Update

HotMommas ProjectOur long time client Kathy Korman Frey, George Washington University School of Business professor and GWU Entrepreneur in Residence, has engaged the FMS Professional Solutions Group again to update her HotMommas Project case study competition website and create another brand new website. Professor Frey has amassed the world's largest public domain collection of women's case studies, and created an environment where these women can share their experiences and challenges of creating and running companies along with juggling family and other commitments in life.

This effort is almost complete and we'll be unveiling the revamped case study competition website as well as the new "sister" site next month. Stay tuned!

Sep 22

Email Collaboration using Microsoft Outlook and Exchange from a Database Perspective

One of the challenges most organizations face is how to coordinate communications and tasks among team members and external contacts. With multiple people and clients/projects, emails fly in many directions. People with vital information may be unreachable while customers may be providing information to someone in your organization while others who need that information are oblivious. When someone leaves a team or organization, much of their information is lost.

Microsoft OutlookOver the years, we've helped several clients better manage their emails and treat them like a database. We've built solutions that work with Exchange and Outlook to automatically classify contacts, tag emails, and store the information in a Microsoft SQL Server database. The data is presented through a Microsoft Outlook add-in showing all communications with a contact's firm when you create or respond to an email. The data can also be displayed in the Facebook like interface to make it easy for everyone on your team to know what's going on.

There's no longer a need to look in someone else's Inbox since information is immediately shared between everyone who needs to know (even before the recipient opens their message). Searching for messages is quick and easy, and corporate document retention policies can be enforced.

To learn more about this and other innovative activities of our Professional Solutions Group, please contact our consulting team.

Sep 22

Extend Your Microsoft Access Applications Over the Internet with RemoteApp and Total Access Startup

Our paper on Using Terminal Services and RemoteApp to Extend Your Microsoft Access and other Windows Applications Over the Internet is updated. There's more information on implementing this plus how Total Access Startup can manage this through user profiles to let every user have a unique experience.

Our Professional Solutions Group has helped organizations run Microsoft Access application over the web and can even help you use host RemoteApp instances for your users. Contact our consulting team for more information.