How This Book is Organized

Part One of this book, Creating an Access Application, covers the basics—creating tables, forms, and other database objects as part of an application, with chapters on creating a database (including tables and relationships), forms, controls, queries, PivotTables and PivotCharts, reports, and modules.

Part Two, Modifying, Updating, and Maintaining Access Applications, covers the techniques you need to use over the course of an application’s life cycle, including reworking applications created by non-developers, moving old data into a new database, and upgrading to a new Office version.

Part Three, Working with Other Office Components (and More), deals with using Automation code to exchange data among Office components, and even a few non-Office programs, with separate chapters for exchanging data with Word, Outlook, and Excel, and a chapter for communicating with non-Office applications, including Symantec WinFax. If you need to write Access data to Word letters or Excel worksheets, you can go right to the relevant chapter.