Professional Access 2000 Programming (Programmer to programmer) - Softcover

Martins, Felipe; Salguero, Dennis; Shelby, Kevin; Blackburn, Ian; Dewson, Robin; Hanselman, Scott; Hatfield, Hope

Softcover

ISBN 10: 1861004087 ISBN 13: 9781861004086

Publisher: WROX Press Ltd, 2000

Synopsis

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.

About this title

Review

Mug shots of the 16 authors appear on the front cover and a fascinating cross-section of the programming community they look. From bearded arm waving to bespectacled seriousness, all life is here, as indeed is inside Professional Access 2000 Programming, with practically everything you will ever want to know about programming Microsoft's Access 2000.

An overview chapter sets the scene and describes the major differences between this and earlier versions, including a brief comparison of the Jet, MSDE and SQL Server (7.0 not the most recent 2000) database engines. The first chapters cover developing applications from scratch, including a definition of application types and the suitability of Access for their development. Then there's Visual Basic for Applications and Access Objects and database querying with the Query Expression Builder, SQL, DAO (Data Access Objects) and ADO (AxtiveX Data Objects). That's just the first four chapters: there are another 14 and eight appendices that launch into many areas including COM add-ins, security, replication, data on the Internet and creating a help system. Integration with other Microsoft applications gets a chapter too; programmers can add greater functionality to Access applications by calling on Word, Excel and Outlook.

This book is highly opinionated in places (there is an impassioned cry for eliminating error message boxes from your applications) and is occasionally written in the first person though there is no indication of who among the 16 authors wrote which bit. However, a relaxed, approachable and informative tone is maintained fairly evenly throughout, a feat in itself.

Technologies, techniques and methodologies come thick and fast in this excellent book. If you want to know more about programming in Access, look no further. --Mark Whitehorn

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.

Edition details

• Publisher: WROX Press Ltd
• Publication date: 2000
• ISBN 10: 1861004087
• ISBN 13: 9781861004086
• Binding: Paperback
• Language: English
• Number of pages: 886