Through a partnership with VisualSP, we bring you a series of videos that provide step-by-step instruction in a variety of practical SharePoint tasks. Want more? Let us know what you need to know about in the comments section below or by writing to SharePoint Pro Editor Deb Donston-Miller.
Microsoft Access 2013 ships with the ability to create easy-to-manage, robust applications on top of SharePoint (both Office 365 and on-premises SharePoint 2013). The management and modification for this type of app takes place using Access 2013, but the app itself is then launched to SharePoint. End users need only a browser to interact with this type of app no matter where they are physically located since the app runs within SharePoint.
These types of apps in the past have suffered from poor adoption due to the lack of a solid back-end system that protects the data integrity. For that reason, Access 2013 Web apps data is stored completely in SQL databases, guaranteeing the scalability and data integrity that SQL has been known for.
The possibilities are endless for the type of app you can create using Access 2013 to host on SharePoint. Following are just a few example scenarios of the types of apps:
- Issue tracking
- Project management
- Contact management
- Asset tracking
The following video demonstrates the creation of an Access 2013 Web app from scratch:
Asif is a SharePoint Trainer and Consultant. He is a SharePoint Server MVP and a Microsoft Certified Trainer (MCT). He is the author of the publications “SharePoint 2013 First Look for Power Users“, “Beginning SharePoint Designer 2010”, “Real World SharePoint 2010” and “Professional SharePoint Designer 2007.“ Over the years, Asif has provided SharePoint consulting and training to many large clients, including: Department of Defense, NASA, Hersheys, Toshiba, State Farm, Federal Home Loan Bank and the U.S. Army.