Microsoft Access 2010 New Features Overview

Applies to: Microsoft Access 2010 for Windows

If you're using Microsoft Access 2010, you may want to check out this list of some of the new features in 2010 before attending a training course.

For 2016 or 2013, check out the following:

Microsoft Access 2016 New Features Overview

Microsoft Access 2013 New Features Overview

Since many new features were first added in 2007, you may want to check out the Microsoft Access 2007 version overview.

Looking for Microsoft Access training courses?


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

Redesigned Macro Designer

Access 2010 features a completely redesigned Macro Designer that is significantly different from 2007 and previous versions. There is a new clean interface and actions and program flow appear in the redesigned window. Events can be embedded on forms and macros can be saved with a form or other object as opposed to a stand-alone macro object.

New Data Macros

Data macros provide a new way to implement "triggers" in any Access 2010 database.

Data macros can trigger when an event occurs such as a change in a field in a table. Access could then automatically enter a data modified in a date modified field based on the change.

Design Consistency using Themes

Microsoft Office themes are available in Access 2010 to make designing forms and reports easier and more consistent. Themes appear in both reports and forms in Design View.

Database and Application Part Templates

Access 2010 includes a number of new database templates. There are also new templates for application parts such as templates for tables or forms.

Add Fields as Groups

In Access 2010, the Data Type gallery in the Add Field task pane and contains the common field types. You can now add certain groups of fields, called Quick Start selections, as a collection rather than adding one field at a time.

In the Add Field task pane, you can add your own fields to the list of fields. You can save selected fields as user-defined data types. When saving fields for later use, you can categorize them under any section within the Add Fields task pane.

Conditional Formatting in Reports

Access 2010 has a new style for conditional formatting within reports. To use or change the conditional formatting rules in a report, open the report in Design View, click on the Format tab on the Ribbon and then select the Conditional Formatting. Enter or edit rules as required.

Expression and Query Builder use Intellisense

Intellisense in the Expression and Query Builder helps complete the field names and other items you start to enter. This reduces the chances of error when working with queries and expressions as well as the time spent looking up the spelling of field names in large databases.

Web-ready Database Formats

If you have access to a SharePoint site with Access Services configured, you can create a web database using Access 2010. Web databases are often created from Web templates. Users who have accounts on a SharePoint site can use a Access web database in a web browser. Note that some desktop database features do not translate to the Web.


Microsoft Access 2010 Maximum Limits and Specifications


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

Custom training

Register now for a scheduled course or contact us at for more information about any of our courses or to discuss custom training options (virtual classroom or live classroom).

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)



You may like

You may also like

How to Replace Zeros (0) with Blanks in Excel

How to Replace Zeros (0) with Blanks in Excel

There are several strategies to replace zero values (0) with blanks in Excel. If you want to replace zero values in cells with blanks, you can use the Replace command or write a formula to return blanks. However, if you simply want to display blanks instead of zeros, you have two formatting options – create a custom number format or a conditional format.

What is Power Query in Excel?

What is Power Query in Excel?

Power Query in Excel is a powerful data transformation tool that allows you to import data from many different sources and then extract, clean, and transform the data. You will then be able to load the data into Excel or Power BI and perform further data analysis. With Power Query (also known as Get & Transform), you can set up a query once and then refresh it when new data is added. Power Query can import and clean millions of rows of data.

How to Freeze Rows in Excel (One or Multiple Rows)

How to Freeze Rows in Excel (One or Multiple Rows)

You can freeze one or more rows in an Excel worksheet using the Freeze Panes command. If you freeze rows containing headings, the headings will appear when you scroll down. You can freeze columns as well so when you scroll to the right columns will be frozen.

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 | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 |

Pin It on Pinterest