Mastering Access 2002

Celeste Robinson · Alan Simpson

Jul 2006 · John Wiley & Sons

About this ebook

Master Everything Access 2002 Has to Offer

Reap the benefits of the latest release of Microsoft Access with Mastering Access 2002 Premium Edition. Get clelear, in-depth coverage of the entire range of Access functionality, from basic to advanced. Special attention to new features makes the transition from an earlier version quick and painless, and 200 pages of bonus macro material teaches you ways to customize and automate Access to make it work for you.

Establish Key Skills

• Create a database that meets your precise needs
• Design easy-to-use forms with effective visual elements
• Expand and collapse views to bring in supporting details
• Import and export data, including XML
• Examine data using subdatasheet views
• Summarize, analyze, and trend data with PivotTables and PivotCharts
• Filter data and create reports
• Publish Access data to a Web server
• Personalize Access menus and toolbars
• Keep your data secure
• Take advantage of improved integration with other Office applications
• Create custom error messages

Then Tackle These Cutting-Edge Topics

• Recording and running macros
• Maintaining data with macros
• Handling complex macro navigation
• Using macros to work with groups of records
• Identifying and correcting macro errors
• Using Access as SQL Server's front end
• Using Access as the core of a database-driven Web site
• Managing replication and conflict resolution
• Using Visual Basic to get the most out of Access

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

About the author

Celeste Robinson has worked as a systems engineer, small business consultant, technical trainer, and database developer in a computing career that spans more than 20 years. She has co-authored (with Alan Simpson) Mastering Access 97, Mastering WordPerfect Office 2000, and Mastering Access 2000, all from Sybex.

Alan Simpson is a software consultant, best-selling author, and teacher, who has been active in the computer industry for over two decades. His books include dozens of popularly, critically, and technically acclaimed titles.