Category Archives: Books

List of books recommended by John Viescas Consulting.

Effective SQL

      Comments Off on Effective SQL

Effective SQL John L. Viescas, Douglas Steele, Ben Clothier ISBN No. 0-134-57889-9 . This advanced book teaches you 61 ways to write Effective SQL. The chapters cover everything from an overview of database design to dealing with hierarchical data. Available NOW!

Microsoft Office Access 2010 Inside Out

      Comments Off on Microsoft Office Access 2010 Inside Out

Microsoft Office Access 2010 Inside Out Jeff Conrad John L. Viescas ISBN 0-7356-2685-5 CD included Microsoft has extended the features introduced in Access 2007 by enhancing the macro facility and giving you the ability to design forms and reports that can be directly ported to a Microsoft SharePoint web server.This comprehensive book, updated thoroughly by my “partner in crime,” Jeff… Read more »

Microsoft Office Access 2007 Inside Out

      Comments Off on Microsoft Office Access 2007 Inside Out

Microsoft Office Access 2007 Inside Out John L. ViescasJeff ConradISBN 0-7356-2325-2CD included Microsoft has completely redesigned the user interface for all Microsoft Office products! Even if you’re an expert using Access, you need this book to learn how to work in this new edition of the world’s most popular desktop database. The book is also chock-full of details about the… Read more »

Microsoft Access 2003 Inside Out

      1 Comment on Microsoft Access 2003 Inside Out

Microsoft Office Access 2003 Inside Out John L. ViescasISBN 0-7356-1513-6CD included. When Microsoft Press says "Inside Out," they mean it! This book covers how to build Desktop (mdb) applications, how to create Project (adp) applications, automating your application with Visual Basic, using Access on the Web, and much more. The CD is chock-full of sample code and includes three fully-functioning… Read more »

Building Microsoft Access Applications

      1 Comment on Building Microsoft Access Applications

Building Microsoft Access Applications John L. ViescasISBN 0-7356-2039-3CD included You can find lots of Access books that give you neat tips and tricks to make your applications more robust, but none that give you a complete application with all the features built-in and a thorough guide to how the application works.Building Microsoft Access Applications includes four, count ’em four, complete… Read more »

Microsoft Access Visual Basic Step By Step

      Comments Off on Microsoft Access Visual Basic Step By Step

Microsoft Access  Visual Basic Step By Step Evan CallahanISBN No. 1-55615-890-4 If you’ve never programmed before and want to dig into the world of Visual Basic in Access, this is the place to start. Although written in 1996, this book still applies to current versions of Microsoft Access.

Inside Microsoft SQL Server 2005: T-SQL Programming

      Comments Off on Inside Microsoft SQL Server 2005: T-SQL Programming

Inside Microsoft SQL Server 2005: T-SQL Programming Itzik Ben-gan, Dejan Sarka, and Roger WolterISBN 0735621977 This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)—one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on language features and how they are interpreted… Read more »

SQL Queries for Mere Mortals, 4th Edition

      Comments Off on SQL Queries for Mere Mortals, 4th Edition

SQL Queries for Mere Mortals, 4th Edition John L. ViescasISBN No. 978-0134858333 Anyone who has to use a database system that supports SQL can use this book. As a beginning database user who has just discovered that the data you need is fetched using SQL, this book will teach you all the basics and more. For an expert user who… Read more »

Special Edition Using Access 2002

      Comments Off on Special Edition Using Access 2002

Special Edition Using Access 2002 Roger JenningsISBN 0-78972-510-X Sorry, but there is no 2002 edition of Running. I highly recommend Roger’s book as a good foundation for Intermediate users. This is a far better buy than the Microsoft Access 2002 Inside Out book (not written by me).

Access 2002 Developers Handbook Set

      Comments Off on Access 2002 Developers Handbook Set

Paul Litwin, Ken Getz, Mike GunderloyISBN 0-7821-4011-4CDs included Just like their previous editions, this is the book to own if you’re serious about developing advanced applications using Microsoft Access. Where else can you buy 30+ years of collective developer experience for under $100?

Access Cookbook

      Comments Off on Access Cookbook

Access Cookbook Paul Litwin, Ken Getz, Andy BaronISBN 0-5960-0084-7CD included This is a great little (OK, so it’s 720 pages) book that contains “answers” to many common tricky development tasks. The section on how to use the new Printers collection is particularly cool! The book is organized by type of task: queries, forms, reports, code, API calls, etc.

Microsoft Access 2002 Step-by-Step

      Comments Off on Microsoft Access 2002 Step-by-Step

Microsoft Access 2002 Step-by-Step Online Training Solutions, Inc.ISBN 0-73561-299-4Disk included If you’re a rank beginner, start with this book. This is the 2002 version of the popular beginner tutorial.

Running Microsoft Access 2000

      Comments Off on Running Microsoft Access 2000

Running Microsoft Access 2000 John L. ViescasISBN 1-57231-934-8CD included This edition of the book includes a new chapter on “Publishing Your Data on the Web.” I cover using both FrontPage and the new Data Access Pages facility to create web pages using “live” data from Microsoft Access 2000. You’ll also find a new section on the ground-breaking Client/Server facility as well… Read more »

Database Design for Mere Mortals, Third Edition

      Comments Off on Database Design for Mere Mortals, Third Edition

Database Design for Mere Mortals, Third Edition Michael J. Hernandez ISBN No. 978-0321884497 An astonishing fresh approach to the ‘nasty’ task of relational database design. Mike uses a straightforward, no-nonsense technique that doesn’t get bogged down in incomprehensible mathematical rules or scientific jargon. Anyone who has anything to do with creating applications using a database product should buy this book… Read more »

Joe Celko’s SQL for Smarties: Advanced SQL Programming

      Comments Off on Joe Celko’s SQL for Smarties: Advanced SQL Programming

Joe Celko’s SQL for Smarties: Advanced SQL Programming Joe Celko ISBN No. 1-558-60576-2 After you have moved beyond SQL for Mere Mortals, Joe Celko is the unquestioned expert to go to for advanced techniques. Be forewarned that the problems he presents are brain-twisters, and the solutions might not work in all “relational” database systems. Like Mere Mortals, all the solutions… Read more »

Joe Celko’s SQL Puzzles and Answers

      Comments Off on Joe Celko’s SQL Puzzles and Answers

Joe Celko’s SQL Puzzles and Answers Joe CelkoISBN No. 1-558-60453-7 Similar to SQL for Smarties, this book presents even more complex problems, a problem-solving approach, and the final solution. More of a “cookbook” and less of a “tutorial” than Smarties.

Joe Celko’s Trees and Hierarchies in SQL for Smarties

      Comments Off on Joe Celko’s Trees and Hierarchies in SQL for Smarties

Joe Celko’s Trees and Hierarchies in SQL for Smarties Joe CelkoISBN No. 1558609202 The next step beyond SQL for Smarties Joe Celko’s Trees and Hierarchies in SQL is an intermediate to advanced-level practitioners guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies… Read more »

Relational Database Design Clearly Explained

      Comments Off on Relational Database Design Clearly Explained

Relational Database Design Clearly Explained Jan L. HarringtonISBN No. 0-12326-425-1 Another relatively simple and readable approach to database design. It’s a bit more academic than Mike’s book.

Handbook of Relational Database Design

      Comments Off on Handbook of Relational Database Design

Handbook of Relational Database Design Candace C. Fleming, Barbara VonhalleISBN No. 0-2011-1434-8 This is an old classic published in 1989. It’s not for the novice reader.

Programming Microsoft SQL Server 2005

      Comments Off on Programming Microsoft SQL Server 2005

Programming Microsoft SQL Server 2005 Andrew Brust and Stephen ForteISBN 0735619239 This book covers the basics of developing customized database applications with Microsoft SQL Server 2005, and it includes code samples and real-world, expert insight.

Microsoft Access Developer’s Guide to SQL Server

      Comments Off on Microsoft Access Developer’s Guide to SQL Server

Microsoft Access Developer’s Guide to SQL Server Mary Chipman and Andy BaronISBN No. 0-67231-944-6 This is THE book to have if you’re developing applications using Microsoft Access 2000 linked to a Microsoft SQL Server database.

Hitchhiker’s Guide to Visual Basic and SQL Server

      Comments Off on Hitchhiker’s Guide to Visual Basic and SQL Server

Hitchhiker’s Guide to Visual Basic and SQL Server William R. VaughnISBN No. 1-57231-848-1CD included Lots of good info in an easy-to-read style. Some folks have found its tone not serious enough. Just skip the bad Hitchhiker jokes.

Inside Microsoft SQL Server 2000

      Comments Off on Inside Microsoft SQL Server 2000

Inside Microsoft SQL Server 2000 Kalen DelaneyISBN 0-73560-998-5 A thorough review of how to work with SQL Server 2000, including tuning and management tips.

Microsoft Access 2000 Visual Basic for Applications Fundamentals

      Comments Off on Microsoft Access 2000 Visual Basic for Applications Fundamentals

Microsoft Access 2000 Visual Basic for Applications Fundamentals Evan CallahanISBN No. 0-73560-592-0 Hit a brick wall writing macros? This book may be just the ticket to get you into using Visual Basic in Access with little pain. This book is excellent for rank beginners. If you’ve already had some programming experience, choose one of the more advanced Access or Visual Basic books I’ve… Read more »

Microsoft Visual Basic 6.0 Step-By-Step

      Comments Off on Microsoft Visual Basic 6.0 Step-By-Step

Microsoft Visual Basic 6.0 Step-By-Step Michael HalvorsonISBN No. 1-57231-809-0 Arguably the best book on Visual Basic for a rank beginner.  If you’re already familiar with programming, the simple exercises will most probably bore you.

VBA Developers Handbook

      Comments Off on VBA Developers Handbook

VBA Developers Handbook Ken Getz, Michael GilbertISBN 0-7821-1951-4CD included This is the companion book to Access 97 Developers Handbook (Litwin, Getz, Gilbert). It’s an advanced book chock-full of good ideas and examples. You can also get both books as a set: Access 97 Developers Set, ISBN 0-7821-2207-8.

Dan Appleman’s Developing COM/ ActiveX Components with Visual Basic 6

      Comments Off on Dan Appleman’s Developing COM/ ActiveX Components with Visual Basic 6

Dan Appleman’s Developing COM/ ActiveX Components with Visual Basic 6 Dan ApplemanISBN 1-56276-576-0CD included If you want to do really advanced tasks with Visual Basic 6, this is a good place to look. This book is for very advanced developers and is not for the faint-of-heart. Dan is one of the highly-recognized experts in interfacing Visual Basic and the Windows API.