Celeste Robinson & Alan Simpson 
Mastering Access 2002, Premium Edition 

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-depthcoverage of the entire range of Access functionality, from basic toadvanced. Special attention to new features makes the transitionfrom an earlier version quick and painless, and 200 pages of bonusmacro material teaches you ways to customize and automate Access tomake 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 Pivot Tables and Pivot Charts* 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 Officeapplications* 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 arenot included as part of e Book file.

Table of Content

Introduction.PART I: AN OVERVIEW OF ACCESS.Chapter 1: Getting Started and Getting Around.Chapter 2: Understanding Databases.Chapter 3: Access in an Evening.Chapter 4: About Access, Office, Windows, and the Internet.PART II: CREATING A DATABASE PROJECT.Chapter 5: Creating a Database.Chapter 6: Creating Access Tables.Chapter 7: Linking, Importing, and Exporting Data.Chapter 8: Adding, Editing, and Viewing Data.Chapter 9: Sorting, Searching, Filtering, and Printing.Chapter 10: Querying Your Tables.Chapter 11: Creating Forms with Form Wizards.Chapter 12: Creating Reports with Report Wizards.Chapter 13: Creating Custom Forms and Reports.Chapter 14: Creating Data Access Pages.Chapter 15: Creating Charts and Pivot Tables.PART III: DATABASE TUNING AND ADMINISTRATION.Chapter 16: Personalizing Access.Chapter 17: Speeding Up Your Database.Chapter 18: Administering Your Database.Chapter 19: Networking and Security.PART IV: BUILDING A CUSTOM APPLICATION.Chapter 20: Creating a Custom Application.Chapter 21: Using Macros to Create Custom Actions.Chapter 22: Creating Custom Switchboards.Chapter 23: Creating Custom Dialog Boxes.Chapter 24: Creating Custom Toolbars.Chapter 25: Creating Custom Menus.PART V: REFINING A CUSTOM APPLICATION.Chapter 26: Introducing Visual Basic.Chapter 27: Creating Custom Error Messages.Chapter 28: Interacting with Other Programs.Chapter 29: Pulling It All Together.Chapter 30: Working with Projects.PART VI: MACRO PROGRAMMING FROM INDUSTRY EXPERT SUSANNNOVALIS.Chapter 31: Macro Basics.Chapter 32: Dealing with Errors in Macros.Chapter 33: Navigation with Macros.Chapter 34: Data Maintenance with Macros.Chapter 35: Working with Groups of Records Using Macros.PART VII: APPENDICES.Appendix A: Checking Your Hardware.Appendix B: About the CD-ROM.Appendix C: Installing and Using Fulfill 2002.Index.

About the author

Celeste Robinson has worked as a systems engineer, smallbusiness consultant, technical trainer, and database developer in acomputing career that spans more than 20 years. She has co-authored(with Alan Simpson) Mastering Access 97, Mastering Word Perfect Office 2000, and Mastering Access 2000, allfrom Sybex.Alan Simpson is a software consultant, best-sellingauthor, and teacher, who has been active in the computer industryfor over two decades. His books include dozens of popularly, critically, and technically acclaimed titles.