Category Archives: Access 2016

What’s new in MS Access 2016…not too much

Microsoft did not bite off any major changes between Access 2013 and 2016. Nothing major changed (like the move from Web Databases to Web Apps from 2010 to 2013) and there are mostly just some enhancements and more robust design options.  Here are some of the features outlines by Microsoft:

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.

tellme msaccess2016

Can’t find a button? Click inside the Tell Me box (it’s the box at the top, with the light bulb). Type a button or command, like “filter”, and you’ll see all of your filter-related options listed for you.

Keep in mind that the the Tell Me box is not available in the ribbon when designing Access web apps.

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 MS 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.

export to excel

Open the Linked Table Manager dialog by clicking External Data > Linked Table Manager. Select the linked data sources you want to list and then click Export to Excel.

Once again, please note that this feature is not available when designing Access Web Apps.  Are you seeing a trend here?

Larger 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.

larger table view

To view the Show Table dialog in queries, click Create > Query Design. The Show Table dialog opens by default. You can also open this dialog in queries by clicking Design > Show Table. To view the Show Table dialog in the Relationships window, click Database Tools > Relationships. The Show Table dialog opens by default. You can also open this dialog in the Relationship window by clicking Design > Show Table.

Once again, please note that the Relationships window is not available in Access web apps.

New visual themes and templates for the Access program

As mentioned a lot of the improvements to Access 2013 come to aesthetics.  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.

assets database template

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. To try these templates out yourself, go to File > New, and then search for any of these:

  • Desktop Assets
  • Desktop Contacts
  • Desktop Events
  • Desktop Students
  • Desktop Tasks

Each of these templates includes a new Getting Started form with links to articles, videos, and other community resources.

Posted in Access 2016 | Tagged , , , | Leave a comment