| and Resources | 
| and Resources |
| Using Access 97/ Using Access 2000 by Roger Jennings Que Books | From one of the venerable database and VB authors. An excellent bridge for the late beginner to intermediate user covering all the ins and outs of using this ever more powerful software including effective design of various types of databases, migration from one version to another, automation with other MS Office products, ASP pages etc. |
| Access 2 Developer's Guide by Roger Jennings SAM's Publishing | If you can find it at a used book store, still a great guide to many of the development issues in Access for the Intermediate to Advanced user. Provides loads of DAO and VBA examples including creation of SQL Notepads, dynamic graphing with MS graph. |
| Access Developer's Handbook by Litwin, Getz, Reddick et. al. Sybex Publishing |
Specific versions are available for every
version of Access. This book is often considered the major Access developer's guide, for intermediate to advanced users. Includes ton's of visual basic code, covering DAO and many useful windows api's. Pick up updates to the book's at MCW's website |
| Access 97 Power Programming by F. Scott Baker Que Books |
Scott Baker goes into depth on many advanced Access development issues covering lots of Windows APIs. Issues coved include topics such as how to manage logging off users in a multi-user environment when you need to maintain the database. |
| Microsoft Access 95 (2) How-To by Ken Getz et. al Waite Group Press |
Another book that your local book store may not stock. However its a very practical manual of how-to's for many common development issues for Microsoft Access. Look for the similar book for Access 2 (There is no Access 97 or Access 2000 version of this book so buy the Access 95 edition for 32 bit solutions.) |
|
SQL Server |
|
| Professional SQL Server 7.0 Programming Robert Vieira Wrox Press |
This is provides a comprehensive overview of working with SQL Server 7 and T-SQL. The author also covers advanced strategies and examples to optimize and hone your application. The book covers in depth issues on general db design, data retrieval and manipulation in a way most Access developers have not had occasion to consider in the past. The writer is familiar with Access and discusses issues related to transition where appropriate. |
| Beginning Visual Basic - SQL Server 7 Thearon Willis Wrox Press |
Written for the VB Programmer, this book is an excellent resource that discusses a broad frame work for and provides examples of application development with SQL Server, including lots of ADO, data retrieval strategies, N-Tier objects etc. |
|
Visual Basic & VBA Books | |
| Visual Basic-Win 32 API by Dan Appleman ZD Press | All MSŪ does in helping you work with Windows APIs is publish the VB declarations. But if you want to do any serious work in VB or Access, Dan Appleman's book is indispensable for most API calls. If you're beginning to think of developing Active X control's get a copy of Dan's Developing Active X components with Visual Basic 5. Dan also publishes many Active X controls through his company Desaware |
| VBA Developer's Handbook by Ken Getz, Mike Gilbert Sybex | Want to learn how to write your code in objects and classes, making it more readable and reusable? That among many other topics including tree sorting algorithms, and a whole host of API uses and other code is covered by the venerable Access guru. |
| Visual Basic Programmer's Journal | Not an Access Publication, but probably the best mag out there for intermediate to advanced VBA developers. We don't know how many times we've searched for a back issue which covered something we were having to deal with now. |
| Smart Access | For the beginner to the advanced developer, this monthly magazine usually has a few tidbits that you will use either now or in the future. Check out a few of their past articles at their web site. |