Professional Access 2000 Programming [Paperback]

Ian Blackburn (Author), Felipe Martins (Author), Steven K. Thompson (Author)

Book Description

Series: Programmer to Programmer | Publication Date: August 2000

Access 2000 is the database of choice for many small to medium businesses. Using Access in conjunction with VBA, VB or ASP it is possible to develop sophisticated systems for storing and manipulating business data. Office 2000 and Access 2000 offer many new features that can be used with VB to create great user interfaces and applications. This book concentrates on the issues involved with this type of development, and shows how to create database-driven internet and intranet applications with Access as the underlying datastore.

Editorial Reviews

From the Publisher

Professional Access 2000 Programming takes the intermediate Access developer to a professional level by providing a thorough guide to developing VB, VBA and ASP applications that use Access 2000. Beginning with an introduction to Access and building an Access Application, the book then moves on to coverage of scalable solutions (demonstrated in a case study), and the new MSDE engine and Data Access Pages. Development with ADO and DAO are introduced, including building queries and stored procedures. Real-world tutorials demonstrate the interaction with other Office Applications and the greater interoperability with ASP. This book will provide everything a developer needs to build professional custom database applications.

About the Author

Felipe Martins is an MCSD and MCT who has been programming with Office products and VB for many years, building applications in the manufacturing, healthcare, and aerospace industries. He currently works as a Senior Solutions Developer for ImagiNET Resources Corp., a leading edge business solutions provider.

Product Details

• Paperback: 866 pages
• Publisher: Peer Information Inc.; 1 edition (August 2000)
• Language: English
• ISBN-10: 1861004087
• ISBN-13: 978-1861004086
• Product Dimensions: 9.1 x 7.1 x 2 inches
• Shipping Weight: 2.9 pounds
• Average Customer Review: 5.0 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #2,671,015 in Books (See Top 100 in Books)

More About the Author

My name is Scott Hanselman. I work out of my home office for Microsoft as a Principal Program Manager, aiming to spread good information about developing software, usually on the Microsoft stack. Before this I was the Chief Architect at Corillian Corporation, now a part of Checkfree, for 6+ years. I was also involved in a few Microsoft Developer things for many years like the MVP and RD programs and I'll speak about computers (and other passions) whenever someone will listen. I've written a bunch of books with a bunch of cool people over the last 20 years.

Before Corillian and Microsoft I worked as a Principal Consultant at a local Microsoft Solution Provider called STEP Technology, speaking, writing, consulting, and very much not getting rich during Web 1.0. Even earlier, I worked at a Car Parts Data Warehouse called Chrome Data, and before that I had a small company that specialized in internationalization and thunking. I've also been an Adjunct Professor at OIT, teaching C#. On the side, I created the first PalmPilot Diabetes Management System in 1998 and sold it to a healthcare company five years later. It's now in limbo, but I'm trying to get it released as Open Source.

What else would you like to know?

Customer Reviews

Most Helpful Customer Reviews

56 of 56 people found the following review helpful:

5.0 out of 5 stars Professional Access 2000 Programming, August 18, 2000

By 

"cmjreview" - See all my reviews

This review is from: Professional Access 2000 Programming (Paperback)

Professional Access 2000 Programming is a combination of a training book to heighten your programming skills, and a reference work that will give you a complete overview of Access 2000 and it's related programming environment. It's written in the traditional Wrox style that is so easy to read and usable for developers.

One thing I do miss, is the usual Wrox opening statement where it is described whom the book is written for and if any previous programming skills are assumed. It's not until chapter 3 that you find out VB or VBA programming experience is assumed to make use of the chapter. Don't start on this book without any knowledge of VBA, since it is used in most of the coding examples. If you don't know VBA check out the following books: ISBN 0782123244, ISBN 1861001762 and ISBN 0735605920. An understanding of ADO would also improve on the usability of the book.

To make use of the books fullest potential, have a design plan of your database next to it and make notes or check for errors in your design when you go through the chapters. This helped me to improve on the design of my database.

Not essential, but it would have been nice if the sample code used in the book had been made available to the reader. At one place in the book the author even writes that the sample code is available from Wrox' website, but as of today it is not.

This book has given me the skills and confidence to start working on client/server solutions and integrating SQL server. It breaks down the entire complexity surrounding Access 2000 and database development to sizeable blocks and tools that I can piece together according to programming and design goals. A must have for any Access programmer on his way to become a true professional.

26 of 26 people found the following review helpful:

5.0 out of 5 stars Want to Expand Past macros?, December 17, 2000

By 

Chris Cowlbeck (Ardmore, OK USA) - See all my reviews

This review is from: Professional Access 2000 Programming (Paperback)

I've created basic database structures and applications for about five years and pledged never to go past writing macros, because I didn't want to be forced to learn VBA. I run a realty and mortgage office and just couldn't spare the time. Now that Outlook and the Office suite is becoming more familiar with my crew and now that we've joined a WAN and some B2B data sharing, the basic stuff just didn't fill the bill. I've bought quite a few books on Access recently (not to mention dozens from the past few years) and have found this one to be one of the best in its presentation and content.

It gave me some real insight on how I should be considering networking and upsizing. I answered more questions I had after spending 12 hours with the book, than I had spent searching the net or reading the other books for several months. I even read though the code and understood it, and contrary to the warnings the presentation still flowed well. I still know little VBA and am now going back to get a Wrox book on Beginnng Access 2000 VBA.

Concise, very detailed, stuffed full of info and reference. I'm a Wrox fan now.

18 of 18 people found the following review helpful:

5.0 out of 5 stars Wrox Wins Again!, August 18, 2000

By 

Christopher Gonzales (Mineola, NY United States) - See all my reviews

This review is from: Professional Access 2000 Programming (Paperback)

I've been consulting for over 5 years with Access in all it's iterations except 1.0 and I must say that this is the best book on intermediate topics that I have found. There is no "fluff" like in books from other publishers (especially Queue in my opinion). This book is concise with real world examples for real world issues. When I first opened this book and read a bit I realized this book was written by consultants/developers who have gotten there hands dirty and not "feel good" academics who have never written a line of code for a company. Keep this one handy if you're the Access guru at your firm.