With a completion time of 75+ hours, this book features extensive step-by-step instructions combined with numerous screen illustrations to enable users to learn by doing. Solid end-of-chapter materials provide a strong reinforcement tool for learning. Case profiles show the reader the real world applications of the material they have covered while case projects emphasize the practical applications of the skills they have learned. Special sections with Internet, Caution, Notes and software TIPS provide helpful insights and enrichment information. SCANS competencies are clearly identified as well.

What Alison's book offers over most or all of the other books on the market is that Alison is able to take a highly technical topic and present it in a manner that is easy to comprehend. It is a book that the reader will often want to read from cover to cover, but it can also act as an excellent reference. The CD includes all source code from the book, sample databases, and complete applications.

A completely revised edition of the highly successful "Mastering Access 97", this book is designed to introduce beginners to intelligent database design and use. The CD-ROM contains the database used as an example throughout the book and a blank version for the reader to customize. Cover Title

Master the Power of Access 2000--Including Its Most Advanced Features This specially expanded edition of Mastering Access is the most complete Access book available anywhere. Written by two Access experts, Mastering Access 2000 Premium Edition teaches you everything you need to know to get the most out of this powerful business tool. Inside, you'll find in-depth coverage of Web publishing, subdatasheet views, macro development, improved SQL Server integration, and scores of other features that will improve your productivity at home and in the office-wherever and however you use Access. Become an Access 2000 master: * Create a database that meets your precise needs * Design effective and easy-to-use forms * Drill down into information to gather pertinent facts * Import and export data * Examine data using subdatasheet views * Create PivotTables * 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: * Record and run macros * Maintain data with macros * Handle complex macro navigation * Use macros to work with groups of records * Spot and correct macro errors * Use Access as SQL Server's front end * Use Access as the core of a database-driven Web site * Manage replication and conflict resolution * Use VB to get the most out of Access

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.

Microsoft Office 2007 is a major upgrade from the last version of Office; Access will also be greatly revised. Alison Balter is the name that Access developers will trust to guide them through Access 2007's new features. She has the rare ability to take complex topics and explain them clearly, as shown by the success of her ten previous books on Access. Balter is known for providing real-world solutions to specific Access development problems. She also is known for her ability to back up her practical examples with just enough underlying theory to give the reader a good overall understanding of Access. In short, this book will provide beginning and intermediate Access developers with everything that they need to know to design and build Access 2007 applications. It should also appeal to DBAs and power users who want or need to get started building custom Access apps. This latest book in her Mastering Access series will not disappoint her many fans who anxiously await each new version, and should win her new fans as well.