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.