Access is now much more than a way to create desktop databases. It’s an easy-to-use tool for quickly creating browser-based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure than ever, and you can easily share your applications with colleagues.
App templates. Easily get started by creating a custom app or get inspired by a collection of new and professionally designed app templates.
Table templates. Know what you would like to track with your custom app? Simply start typing it in the “Add tables” textbox and then choose from relevant tables to quickly define fields, relationships, and rules between them. You will have a new app running in minutes!
*Access Services is required, sold separately as part of select Office 365, SharePoint Online, and SharePoint Server 2013 offers.
The "App experience". Never again worry about users getting "lost in the data" with apps that automatically keep an attractive, easy-to-use interface and consistent user experience. Access deals with the code that creates this professional look and feel.
Related items control. Users can take a peek at additional relevant information in the database without changing screens, so they have the right context when reviewing or entering information.
Autocomplete control. Entering data is now much easier and less error-prone for app users with drop downs and recommendations made upon beginning to type in data. Lookups allow for drawing relationships between records in different tables.
Apps for SharePoint deployment. With Access Services and SharePoint Online or On-Prem SharePoint Server 2013, Access apps can now be easily managed and monitored through a company SharePoint site in a browser. This enables multi-user accessibility and the permissions control expected from SharePoint along with visibility on app usage.
Data stored in SQL. The back end has been moved to SQL Server and Microsoft Azure SQL Database to allow for added reliability, robust security, scalability and long-term manageability. Access applications now leverage standard SQL syntax and a true mission-critical back end, whether deployed on-premises or in the cloud.