Microsoft Access 2013 New Features Overview

Applies to: Microsoft Access 2013 for Windows

If you're considering upgrading to Microsoft Access 2013 before attending a training course or arranging custom training, check out this list of some of the new features in Access 2013.

Interested in another version? Check out the following:

Microsoft Access 2016 New Features Overview

Microsoft Access 2010 New Features Overview

Microsoft Access 2007 New Features Overview.

Looking for Microsoft Access training courses?

VIEW MORE COURSES AND DATES >

The following are some of the key new features available in Microsoft Access 2013.

New Look and Feel

In Access 2013, the interface has a new look and feel, particularly related to animated actions of the mouse and interactions with the Ribbon.

Navigating using the Action Bar

There are now new navigation tools including an Action Bar and you can can customize the Action Bar.

Built-in Searching and Filtering

Access provides a list view which always shows the search box with a list of records. You don't need to write code to make it easy for users to search. Users can simply  click on a record to view the details. You don't need to create a search form with code behind it.

Easily Hide Tables

In Access 2013, when you add a table, a new tab appears and you have the option to hide it.

Create Lookups Easily

The lookup interface has been improved and makes it easy to build foreign keys. In older versions, lookup fields required several steps in the lookup wizard to set up the lookup. This wizard is now a single step and the descriptions are easier to follow so that a user who never has heard of things like "foreign key constraint" and "normal form" can  create lookups.

Related Lookup Behaviour

If a record has a lookup field on it, it can be displayed as a hyperlink which can be used to pop open a form showing the details of the related record. There are also related item controls which makes it every easy to drill through information. No programming is required.

Pop-up Properties Window

In Access 2013, you can now enter properties in a pop-up window rather than searching for properties.

Enhanced Theme Options

There are new theme options in Access 2013 to improve formatting and get a consistent look and feel.

New Templates

Several new templates have been added in 2013 including templates for tables.

Deploy Databases on the Web with Web Apps

Access 2013 now allows you to build a web app database. You can add and edit data in a web app database, share it and publish a desktop database to the web.

If you set up a subscription account, it's fairly simple and inexpensive to deploy a web application (rather than setting up your own web server).

SQL Server Backend

SQL (Structured Query Language) is in the background. SQL Server is now on the backend which will allow for easy upsizing of databases. Both desktop Access applications and web applications use the same SQL Server backend and achieve consistency this way. You can also use SQL Server Reporting Services, Excel or any other tools that supports connecting to SQL.

ADDITIONAL RESOURCES

Microsoft Access 2013 Maximum Limits and Specifications

Related

Microsoft Access Overview, Features and Benefits

How to Convert a Microsoft Access Report to PDF (3 Ways)

10 Techniques for Designing Forms in Microsoft Access

Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.

Microsoft Excel training courses in Toronto. with instructor creating a virtual graph.

LIve or virtual classroom training

Register now for a public scheduled course or contact us to discuss custom live classroom or virtual classroom training.

Related Access courses

Microsoft Access: Introduction

Microsoft Access: Intermediate / Advanced

Microsoft Access: Introduction to Macros and the Macro Designer

Microsoft Access: Introduction to VBA (Visual Basic for Applications)

VIEW ALL COURSES >

 

You may like

You may also like

How to Combine First and Last Name in Excel (5 Ways)

How to Combine First and Last Name in Excel (5 Ways)

You can combine first and last name in Excel in several ways – using the CONCATENATE operator, the CONCATENATE function, the CONCAT function, the TEXTJOIN function or Flash Fill. These functions are often used to combine text in cells but you can also combine text with spaces, commas, dashes or another character. It's common to combine first and last names that appear in two columns into one new column. Some functions are only available in newer versions of Excel but the CONCATENATE operator and function are available in all versions.

How to Insert Multiple Columns in Excel (4 Fast Ways with Shortcuts)

How to Insert Multiple Columns in Excel (4 Fast Ways with Shortcuts)

You can quickly insert multiple columns in Excel using a drop-down menu, keyboard shortcuts or the Home tab in the Ribbon. The key to inserting multiple columns at once, rather than one by one, is to select the number of columns you want to insert first and then insert columns. Excel will insert the same number of columns you selected.

How to Fade a Picture or Part of a Picture in PowerPoint (Using a Gradient)

How to Fade a Picture or Part of a Picture in PowerPoint (Using a Gradient)

You can fade a picture in PowerPoint by drawing a rectangle shape on top of the picture and then filling the rectangle with a gradient from opaque to transparent. This technique is often used to fade an image into the background of a slide. Since the rectangle is placed on top of the image and then text may be placed on top of the rectangle, you may need to reorder the objects.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca

Pin It on Pinterest