For advice on this product or for a quote, please
to request a call back.
Microsoft Office Access 2016 provides a powerful set of tools that allow you to quickly start tracking, reporting and sharing information. Access can work with many data sources, including Microsoft SQL Server and allows you to rapidly create attractive and functional desktop and web-based database applications without requiring deep technical knowledge. Access also includes a suite of prebuilt applications in the form of templates that you can use to get started quickly. Access 2016 includes the ability to build browser-based database apps that can be hosted on a SharePoint server or an Office 365 site.
Do things quickly with Tell Me
New themes for the Access program
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.
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
If you are working on a complex Access application, 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.
- Build an app - build a polished, browser-based database app that runs through SharePoint server or Office 365.
- Add table templates - quickly add tables to your app using pre-designed table templates. With table templates you can easily build a truly relational database.
- External data - import data from Access desktop databases, Microsoft Excel files, ODBC data sources, text files and SharePoint lists.
- Navigation automatically created - you don't need to build any UI elements - and all apps have a similar navigation structure so it's easier to learn and switch between apps.
- Built-in Action Bar - easily add, edit, save or delete items and add additional buttons with custom macros.
- More easily create views - easily add new controls to views without modifying your layouts - drag-and-drop and the other controls move out of the way.
- Callouts for setting properties - easily change an element's settings via callouts located next to the element.
- Related items control - list and summarise data from a related table or query. Click an item to open a detail view for that item.
- AutoComplete control - the AutoComplete Control looks up data from a related table. Think of a combo box that works more like an instant search box.
- Drill-through links - drill-through links let you quickly view details about a related item. Access apps handle the behind-the-scenes logic to make sure the right data is displayed.
- Permissions improvements - Get more control over who can modify your app. SharePoint now comes with for 3 default permissions levels - Designer, Author, and Reader.
- Package and distribute apps - Access apps can be saved as package files and then added to your Corporate Catalog or the Office Store.
Computer and processor
1 gigahertz (GHz) or faster x86-bit or x64-bit processor with SSE2 instruction set
2 GB RAM
3.0 GB available disk space
1280 x 800 screen resolution
Graphics hardware acceleration requires a DirectX 10 graphics card.
Windows 10, Windows 8.1, Windows 8, Windows 7 Service Pack 1, Windows 10 Server, Windows Server 2012 R2, Windows Server 2012, or Windows Server 2008 R2
For the best experience, use the latest version of any operating system.
The current or immediately previous version of Internet Explorer, Safari, Chrome, Firefox, or Microsoft Edge.
.NET 3.5 required. Some features may require .NET 4.0 or 4.5 CLR to also be installed.
A touch-enabled device is required to use any multi-touch functionality. But, all features and functionality are always available by using a keyboard, mouse, or other standard or accessible input device. Note that touch features are optimized for use with Windows 8, Windows 8.1 or Windows 10
OneNote 2016 and Access 2016:
•Internet functionality requires an Internet connection. Fees may apply
•Instant Search functionality requires Windows Search 4.0.