Product Description

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

Product Details

• Amazon Sales Rank: #1254488 in Books
• Published on: 1999-07-13
• Original language: English
• Number of items: 1
• Binding: Hardcover
• 1402 pages

From the Back Cover
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

• 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

About the Author
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.

Celeste Robinson has worked as a systems engineer, small business consultant, technical trainer, and database developer in a computing career that spans more than twenty years.
Simpson and Robinson worked together on Mastering Access 97, Mastering Paradox 7, and Mastering WordPerfect Office 2000, all from Sybex.

Customer Reviews

Good book for beginners to Access, but not advanced users
The book serves as a solid reference for beginners to Access or relational databases, but anyone looking for more advanced topics, such as VBA or package-and-deploy should find another source. I do agree with the previous reviewer that more "hand on" examples would have been great.

Great , BUT
Great reference book. Not much in the way of examples! The CD-rom is short on examples. I am a hands on type of guy, walk me through it once and I get it right away, tell me about it five times and I may still not have it right! Cd does come with a database called Fulfill. Fulfill has a lot of great examples, but it is rarely mentioned in the text, although it is covered in Appendix C