Rick Dobson wrote lots of articles for Smart Access including

 

Accessing Subforms

Migrating Access (and Outlook Data) to SQL Server

Eventful Formatting for Access Forms

Conditional Formats on Access Forms

Consolidating Outlook Contact Data

Sending E-mail with Access

Manipulating Outlook Data from Access

Visual Basic .NET Development

Creating SQL Server Tables with Access Projects

Programming Pivot Tables for Access Forms

Packaging Access 2003 Solutions

An Access Explorer for SQL Server Tables