Editing Microsoft Access (section)

=== Access Services and Web database ===
{{See also|Web form|}}

[[ASP.NET]] [[web form]]s can query a Microsoft Access database, retrieve records and display them on the browser.<ref>{{cite web|title=Create ASP.NET Web Forms to Use a Microsoft Access Database|url=https://www.aspfree.com/c/a/asp-net/create-asp-net-web-forms-to-use-a-microsoft-access-database/|access-date=June 13, 2017}}</ref>

[[SharePoint]] Server 2010 via Access Services allows for Access 2010 databases to be published to SharePoint, thus enabling multiple users to interact with the database application from any standards-compliant Web browser. Access Web databases published to SharePoint Server can use standard objects such as tables, queries, forms, macros, and reports. Access Services stores those objects in SharePoint.<ref>{{cite web|url=http://msdn.microsoft.com/en-us/library/ff402351.aspx|title=Creating Web Databases with Access 2010 and Access Services|publisher=Msdn.microsoft.com|date=July 22, 2009|access-date=April 24, 2013}}</ref>

Access 2013 offers the ability to publish Access web solutions on SharePoint 2013. Rather than using SharePoint lists as its data source, Access 2013 uses an actual SQL Server database hosted by SharePoint or SQL Azure.<ref>{{Cite web|url=https://access-templates.com/tutorial/microsoft-access-2013-web-applications-and-examples.html|title=Microsoft Access 2013 Web Applications and Examples|website=access-templates.com|access-date=September 4, 2017}}</ref> This offers a true relational database with referential integrity, scalability, maintainability, and extensibility compared to the SharePoint views Access 2010 used. The macro language is enhanced to support more sophisticated programming logic and database level automation.<ref name="New in Access for developers"/>