Microsoft Visual Studio LightSwitch for Microsoft Access, SQL Server, and Visual Studio .NET Database Developers
The Visual Studio team has introduced a development platform called LightSwitch which simplifies the creation of database applications in Visual Studio. This rapid application development environment lets you create solutions that can be easily deployed on Windows or Mac platforms from a public web site or Intranet.
We’ve been using LightSwitch for the past year and find it to be ideal for a particular class of SQL Server based solutions. Here our first article providing an overview of the benefits and limitations of the LightSwitch platform for the Microsoft Access community. The paper includes:
- Sample screens
- The Visual Studio .NET Platform
- Working with SQL Server and SQL Azure
- Rapid Application Development
- Silverlight Dependency and Limitations
- Supporting Windows, Mac, and Web Browsers
- Future Support of HTML5
- How Microsoft Access Applications can Evolve into LightSwitch
If you’re interested in learning more about our help developing custom solutions based on LightSwitch, visit our LightSwitch Consulting page.
TechEd is Microsoft's premier conference for IT professionals and developers. The sold-out conference took place in Orlando, Florida last week.
If you didn't attend, you can still watch many of the videos from the conference, including the keynotes and other highlights from each day. Visit the TechEd web site and click the "On Demand" tab to learn about the latest in Microsoft technology.
The announcements this year are stunning with huge advances in Azure, Visual Studio .NET, SkyDrive, LightSwitch, Virtual Machines, and more.
When designing an application and its tables, it’s very important to capture the time dimension and determine how data should be stored with the expectation that it will change over time. While there’s a natural tendency to keep data normalized so that the same information is stored in only one place, the time dimension also needs to be considered.
- What Needs to be Preserved Over Time?
- Making Sure Data Normalization Doesn’t Lose Historical Data
- Shadow Tables
For more details, read our paper: Microsoft Access Database Architecture: Taking Time into Account and Shadow Tables
Additional papers and resources in our Microsoft Access Developer and VBA Programming Help Center
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.