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 1 Yonge Street, Suite 1801 (Toronto Star Building), 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 onsite training or an online course 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

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.

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