Start up or Shut up! is a LIVE radio show Monday afternoon from 2-3pm on the Big Talker 1580 AM hosted by Mark Bucher & Tom Gregg.
One of the nicest features to add to an address data entry screen is to automatically fill the city and state fields when a zip code is entered. In conjunction with the US Postal Service, FMS offers the Total Zip Code Database which gives you the entire list of valid zip codes and their corresponding city and state names. Both the primary and secondary city names are provided. Speed up data entry, eliminate typos, and clean up existing data with Total Zip Code Database. We also include the list of common city names the USPS doesn’t like with their corresponding corrections. The database is provided on an annual subscription basis with an initial list and 11 monthly updates.
In addition to the information provided by the USPS, the Total Zip Code Database also includes geospatial coordinates (latitude and longitude) for each zip code. We also provide a list of countries and states to simplify lookups, and module code and sample form to add this to your applications. The data is provided in a Microsoft Access MDB and ASCII files.
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:
- Event Management
- Logistics Management
- Non-Profit Organizations
- Small Businesses
Let us bring this expertise to help you use data to make better decisions.
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.
But rows and columns can hide valuable patterns. What happens when you take data out of a database and visualize it as a network? Now you can see important connections, centrality, trends, movement over time, and many other key indicators.
I participated on this panel at the Microsoft TechEd Conference to explore the different reasons and approaches for migrating applications to Microsoft SQL Server. In addition to moving the data to SQL Server, ideas are presented for transforming applications to offer additional features while maintaining budgets. (43 minutes)
Watch this video from my panel discussion at the Microsoft TechEd Conference. Hear me share my experiences at FMS with fiver other developers, and different ways we’ve survived over our careers. Entitled The World Turned Upside Down: Development Strategies for Lean Times, the video is 51 minutes.
Over the years, I have had an ongoing discussion about how Microsoft Access best fits in an organization's database strategy. Similar to how some Excel files evolve beyond the capabilities of a spreadsheet and move to Access, some Access applications grow beyond the features of Access. Recently, I was interviewed by Microsoft’s Architect Evangelist Dr. Zhiming Xue on dealing with Access Database based solutions and the challenges of migrating them to SQL Server. Watch the 22 minute video and read more about Migrating Microsoft Access Databases to SQL Server. Let me know what you think.
FMS has offered Access to SQL Server “upsizing” (aka conversion or migration) services for a number of years. We have been working with Microsoft to help customers convert their database applications from Access-based systems to (most typically) SQL Server and ASP.NET websites and web applications. We are one of the few companies in the world who are recognized by Microsoft as being experts at Access to SQL Server migration (see our whitepaper and partner link at the bottom of that page on the Microsoft website).
To kick off 2009, we are offering special rates on these services. Please contact us or give us a call at 703-356-4700 to find out how we can help your organization take the next step.
FMS is excited to announce the launch of The HotMommas Project, a case study competition and social networking website for businesswomen and entrepreneurs. FMS developed this Microsoft ASP.NET and SQL Server based website for a GWU business school professor in Washington, DC. The HotMommas Project just announced their judging panel and the group is generating quite a buzz. Check it out, and we encourage you to tell anyone who may be interested to sign up and enter the competition.