Using Microsoft Access 2000 (Using...)

Rating:
Summary: Highly Recommended
Review: This book contains excellent material and practical examples. As a consultant, I got this book for myself to use as a reference.

After being ask about a good book on Access 2000, I showed my copy to two customers who both had recently purchased Office 2000 Premium. After looking over my copy, both went out and purchased this book on their own and are extremely satisfied with the content.

Rating:
Summary: Attempt to make presentation "hip" fails badly.
Review: This book is one of the now "must" tomes that seems to be filled with unnecessary and "hip" sentences to make the size and warrant the price. I found it entirely impossible to understand, and think the authors got lost in their verbosity.

Rating:
Summary: This is a very nice book.
Review: This book is one of the now "must" tomes that seems to be filled with unnecessary and "hip" sentences to make the size and warrant the price. I found it entirely impossible to understand, and think the authors got lost in their verbosity.

Rating:
Summary: This is a very nice book.
Review: This is a very nice book; it isn't too basic and it isn't too advanced either. The organization of the chapters could be a little better. For example, the book covers "Creating Tables and Queries" in chapters 5 and 6, but it doesn't discuss "Defining and Working with Relationships" until chapter 11.However, it has an interesting approach for explaining Inner-Joins and Outer-Joins by using two circles that overlap. This approach leaves no doubt about how inner-joins and outer-joins work.

Another interesting example the book uses is "Creating an Input Box for User-Requested Criteria": You create the parameter query; next, you build a custom dialog box; then you create the macros to run the parameter query and to close the dialog form; next, link the macros to the dialog form, and finally you edit the query criteria to get the form's parameters. This book will show you how.
If you don't want to use macros, simply convert them to VBA and attach them to the On-click event of the buttons on the Dialog box.
My favorite example is in the "Advanced Form Techniques" chapter, a technique to enter repetitive data, zip codes, addresses, etc: You create a Select Unique query base on the table that contains your address fields; next, on your data-entry form create a List Box based on the query; next attach VBA code to the Double-click event of the List Box. When you double click an item in the List Box, Access will populate all other fields with data specified in your VBA code. This book will show you how.
Similar other examples in this book will make this book worth the purchase. Plus you'll like the tips and additional Sidebar information.
I bought this book last year, I use it often; I came back to this page looking for a new edition. I would give this book five stars, but this book has room for improvement, therefore I give it four stars.