Easy custom database applications
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 and scalable than ever, and you can easily share your applications with colleagues.
Do things quickly with Tell Me
You'll notice a text box on the ribbon in Access 2016 that says Tell me what you want to do. This is a text field where you can enter words and phrases related to what you want to do next and quickly get to features you want to use or actions you want to perform. You can also choose to get help related to what you're looking for.
New themes for the Access program
There are now two Office themes that you can apply to the Access program: Colorful and White. To access these themes, go to File > Options > General, and then click the drop down menu next to Office Theme.
Export linked data source information to Excel
Have you ever wanted to get a nice list of all the linked data sources from your Access database application into Excel? If you are working on a complex Access application, for example, that includes links to many different data sources, it can be helpful to have a nice list of all the various data sources and their types. This exported list can be especially helpful if you are working on an Access application you did not originally design. Now with Access 2016, you'll find this task much easier using new functionality built into the Linked Table Manager dialog.
Templates get a modern look and feel
If you want to organize and manage your data with Access but you'd like some help getting started with designing the database, try using a desktop database template. In Access 2016, five of the most popular database templates have been redesigned to have a more modern look and feel.
Larger Show Table dialog
We've listened to customer feedback about the Show Table dialog. In Access 2016, the default height of the Show Table dialog has been increased so you can easily see more table and query names in your database.
Access web app features coming to SharePoint on-premise customers
With the upcoming release of SharePoint 2016, customers using SharePoint 2016 with Access Services within their organizations will see additional features and take advantage of service improvements.