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:
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.
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 email@example.com if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.
Related Access courses
You may like
You can highlight values in fields or records in Microsoft Access reports using conditional formatting. Certain conditions must be met in order for the formatting to be applied …
You can create calculated fields in select queries in Microsoft Access in the QBE (Query by Example) grid. You'll need to learn a few syntax rules and then you can create simple to more complex calculations.
You may also like
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.
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.
The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function (as well as HLOOKUP and INDEX / MATCH functions). It has a new set of arguments and is available in Excel 2021 and 365. It allows you to look up a value from an array in a range or table and return one or more results. One of the primary benefits of XLOOKUP is that it can look up from columns to the left in a data set and return a range.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | firstname.lastname@example.org