Mastering Access 2000 [With *]

By Celeste Robinson and Alan Simpson

Book Overview

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

• Format: Hardcover
• Language: English
• ISBN: 0782123260
• ISBN13: 9780782123265
• Release Date: May 1999
• Publisher: Sybex
• Length: 1402 Pages
• Weight: 5.72 lbs.
• Dimensions: 3.1" x 7.7" x 9.3"

Customer Reviews

Instructor in a CAN..er... A book!!!

I bought this book thinking it would soon bore me with it's text and I would put it away in my bookshelf. Boy, was I wrong, I could not put the book down. I had no experience with Access until I read page after page of instruction and exercises that get to the point and don't scare you off with accesive technical jargon. No VBA needed, I went as far as building an entire application without the use of VBA. Chapter 3 in the book is probably the best for a begginer, it teaches you step by step the Access interface and how to use it in building an Access database. Screenshots galore! Alot of screenshots that keep you in tune of what the author is talking about, it is like an instructor is there showing you the concepts and excercises. This book made me interested in Access development so I bought another great title: Alison Balter's "Mastering Microsoft Access 2000 Development" ISBN:0672314843 for more advanced topics. Mastering Access 2000 is a great beginner book to have and keep highly recommend it to anyone wanting to learn Access.

Mastering Access 2000

I had Mastering Access 97 and got my basics there, but got Mastering 2000 to see if any changes. These are the best books to start Access programming on a beginning level. I do not think I could ever grasp SQL on my own. This shows you how to let the program do all that for you with wizards and examples.

Good for beginers of Access, but...

This is a gr8 book for beginers of Access and/or Database devlopment. It takes you through all the steps of desgining and using a database. However, at times this book treats you as if you are a BEGINNER TO WINDOWS...so you might feal offended by the often appearences of instructions on how to create shortcuts, or customize a toolbar. If you're already familiar with the basics of Access, you might want to consider another book, or the second half of this book wil only come in usefull.

Mastering Access 2000

Great for beginner to advanced users who expect to capitalize on built-in management tools and some macro development. If you are developer or advanced user and expect to utilize VBA, this isn't the starting or ending place. Great intermediate users desk reference for shortcuts and built-in tools.

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