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 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 email@example.com if you'd like to arrange custom onsite training or an online course 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 quickly replace blank cells in Excel with zeros, dashes or other number or text values (0, -, N/A, Null or other text). It’s useful to fill blank cells with a number, symbol or value if you want to use the data set as the source for a pivot table or use other data analysis tools.
You can convert pounds to kilograms (lb to kg) or kilograms to pounds using formulas with operators or functions in Excel.
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.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | firstname.lastname@example.org