Longtime 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.
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.
Data 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.
Our 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!
The purpose of the SQL UNION query is to combine the results of two or more queries into a single result set. The list contains all the rows belonging to all the queries in the union. This applies to queries in SQL Server or Microsoft Access. A common question is whether to use the UNION or UNION ALL syntax.
The main difference between UNION ALL and UNION is that, UNION only selects distinct values and sorts the results, while UNION ALL selects all values (including duplicates) without sorting. Read our revised paper on UNION versus UNION ALL SQL Syntax to learn more about the differences, see some examples, and understand why you would use one versus the other.
For more tips and using queries, visit our Microsoft Access Query Help Center.