Access 2010

By Jason Brooks  |  Posted 2009-11-18 Print this article Print



Users who prize Access as a tool for roughing out database-backed applications will find a handful of welcome improvements in the 2010 version of Office.

I began putting Access through its paces by selecting one of the template applications offered up from the tool's start page. The first thing I noticed about the new database app I created was an information bar across the top of its interface, alerting me of blocked active content.

By now, macro-blocking has become a very familiar part of Office applications, and the experience that the Office team has accrued while dodging malware writers really shows in the interfaces around trust management. For example, I was pleased to find that clicking for more information on the blocked-content notice did not call forth a dialog box with tough-to-relocate information. Rather, I was sent to the Backstage area for Access-the landing page for meta-document operations and information-where I could read what Access had to say about the active content and then decide whether to enable the content, knowing exactly where to find that information when I was ready to act on it.

I opted to mark the database as a trusted document, which cleared the way for the active content. I noticed, however, that when I e-mailed the database to myself for testing on a different machine, the trusted status did not carry over to the second machine. I had to mark the document as trusted again. I also could have configured a trusted location and ferried the database from one machine to the other through that trusted channel. This document trust scheme appears in other components across Office.

The application template I'd selected was for a project management application, with tables and interface forms for users and tasks, among other things. I was interested to see that both the user and task components of the template were available for easy use in other applications in the form of Application Parts, available under the Create tab of the Access ribbon.

Access 2010 now supports triggers-database operations that can be scripted to occur, for instance, when records are inserted into a database. In Access, this feature is called Data Macros. Along similar lines, I was pleased to see that Access now supports calculated fields, derived from other fields in a record.

Executive Editor Jason Brooks can be reached at


As Editor in Chief of eWEEK Labs, Jason Brooks manages the Labs team and is responsible for eWEEK's print edition. Brooks joined eWEEK in 1999, and has covered wireless networking, office productivity suites, mobile devices, Windows, virtualization, and desktops and notebooks. JasonÔÇÖs coverage is currently focused on Linux and Unix operating systems, open-source software and licensing, cloud computing and Software as a Service. Follow Jason on Twitter at jasonbrooks, or reach him by email at

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel