... but I've been running on overdrive for the last month or so, with no vacation or slow down in sight. When I finally sit down to unwind, it's already past midnight and I'm a walking zombie. Sigh. At least I've been able to follow up on the comments...

Another addition to Access 2007 is a new version of the old Field List dialog/toolbar. Besides retaining the old functionality of adding fields based on the record souce, the new task pane adds a couple of new features. For starters, you can now see...

Another misconception that I read is regarding the new Ribbon interface: some people apparently are expecting the tabs on the ribbon to change completly as the context changes. This is very untrue: each of the tabs in the ribbon are pretty much fixed...

Another new feature for datasheets in the Totals Row. At the bottom of any datasheet view, one can opt to show a row that will do a number of canned aggregation formulas applied to each column, independently. You can see it in action here , where the...

I've heard this one already from multiple people, so it's worth dispelling it: ADPs are not gone from Access. Here's how to create one: Boot Access; Click on the "Blank Database" button in the middle of the screen (under the "New Blank Database...