SharePoint 2013 – Building an Access app
SharePoint Server 2013 offers following two methods of creating end-to-end business solutions that are webbased. Both the methods require purchase of MS SharePoint Server Enterprise Client Access Licenses (also called CALs).
Access Web Database
You cannot create these using Access 2013. You can view & edit a web database that has been previously created by making use of Access 2010 as well as SharePoint Server 2010. You can also use Access 2010 to republish it to SharePoint Server 2013.
Data that is held in Access tables is smoothly moved to MS SharePoint lists, and forms & reports are created in form of webpages. You cannot convert a web database straight away to an Access web app. However, you can always convert a web database to Access web app. This can be done by importing the data available in web database straight into a new Access app. Further, you need to re-create the user interface as well as the business logic.
These basically are SharePoint apps and so can be deployed easily to the SharePoint Store. While you make use of the browser to view & edit data; you can use Access 2013 for designing the Access app. Data & Access objects for every single Access app gets saved in its own SQL Server 2012 database. The same is never saved in SharePoint lists. Such SQLintegrated approach considerably improves the performance, scalability and manageability of the business solution.