Books

Mastering VBA for Microsoft Office 2016

Posted March 8, 2017 By jviescas

Mastering VBA for Microsoft Office 2016
Evan Callahan
ISBN No. 0-73560-592-0
Very good modern book covering the fundamentals of VBA in all Office apps.

Effective SQL

Posted April 29, 2016 By jviescas
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

Posted April 26, 2011 By Mike
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 Conrad, has all the details you need to become an expert using this new version.
Be the first to comment

Microsoft Office Access 2007 Inside Out

Posted April 26, 2011 By Mike

Microsoft Office Access 2007 Inside Out
John L. Viescas
Jeff Conrad
ISBN 0-7356-2325-2
CD 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 new features, including multi-value and attachment fields, Layout view for forms and reports, enhanced interface with Microsoft SharePoint Services, and much more.
Be the first to comment

Microsoft Access 2003 Inside Out

Posted April 25, 2011 By Mike

Microsoft Office Access 2003 Inside Out
John L. Viescas
ISBN 0-7356-1513-6
CD 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 applications.

Note: If you are running Microsoft Access 2000 (version 9), but have purchased Microsoft Office Access 2003 Inside Out, you will not be able to open any of the sample databases because they are all in 2002/2003 format. Go to my Links page to download a copy the sample databases that I converted back to Access 2000 format.

1 Comment. Join the Conversation

Building Microsoft Access Applications

Posted April 25, 2011 By Mike

Building Microsoft Access Applications
John L. Viescas
ISBN 0-7356-2039-3
CD 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 and working applications, and the chapters walk you through the table design and all the code that makes the applications work. The applications included in the book and on the CD are Membership Tracking, Inventory Management, Customer Support, and Registration Management. This was a fun set of applications to build, and it’s a testimony to the power of Access that I built all four in less than a year (with a little help from my son).
1 Comment. Join the Conversation

Microsoft Access Visual Basic Step By Step

Posted April 22, 2011 By Mike

Microsoft Access  Visual Basic Step By Step
Evan Callahan
ISBN 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.
Be the first to comment

Inside Microsoft SQL Server 2005: T-SQL Programming
Itzik Ben-gan, Dejan Sarka, and Roger Wolter
ISBN 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 and processed by the SQL Server execution engine. You’ll get in-depth coverage of the sophisticated uses of T-SQL, including triggers, user-defined functions, exception handling, and more.
Be the first to comment

SQL Queries for Mere Mortals, 2nd Edition

Posted April 22, 2011 By Mike
SQL Queries for Mere Mortals, 3nd Edition
John L. Viescas
Michael J. Hernandez
ISBN No. 0-321-99247-4
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 is suddenly faced with solving complex problems or integrating multiple systems that support SQL, this book provides insights into leveraging the complex abilities of the SQL database language.

This third edition has been thoroughly revised, with three new “advanced” chapters on “NOT” and “AND” Problems, Condition Testing, and Unlinked and “Driver” Tables. The sample databases are provided as SQL scripts, SQL Server 2012 databases, Microsoft Access 2007 databases, and MySQL databases and scripts. You can download the sample files from: http://www.informit.com/store/sql-queries-for-mere-mortals-a-hands-on-guide-to-data-9780321992475.

Be the first to comment

Special Edition Using Access 2002

Posted April 21, 2011 By Mike

Special Edition Using Access 2002
Roger Jennings
ISBN 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).
Be the first to comment

Access 2002 Developers Handbook Set

Posted April 20, 2011 By Mike

Paul Litwin, Ken Getz, Mike Gunderloy
ISBN 0-7821-4011-4
CDs 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?
Be the first to comment

Access Cookbook

Posted April 18, 2011 By Mike

Access Cookbook
Paul Litwin, Ken Getz, Andy Baron
ISBN 0-5960-0084-7
CD 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.
Be the first to comment

Microsoft Access 2002 Step-by-Step

Posted April 17, 2011 By Mike

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

Running Microsoft Access 2000

Posted April 16, 2011 By Mike

Running Microsoft Access 2000
John L. Viescas
ISBN 1-57231-934-8
CD 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 as major updates to all the classics – Tables, Queries, Forms, Reports, Macros, and Visual Basic. Although advertised at 940 pages, the book actually tops out at well over 1,000!
Be the first to comment

Database Design for Mere Mortals, Second Edition
Michael J. Hernandez
ISBN No. 0-201-75284-0
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 and read it cover to cover. For novice readers, it will save hours of frustration trying to build something without a workable design. Even the most advanced database developers will find a new way to look at database design methodology — and perhaps find many of Mike’s ideas useful to make the task more interesting and palatable for others on their project teams.

The Second Edition has many new topics and has several major sections rewritten based on reader feedback.

Be the first to comment

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 adhere to the adopted ANSI-SQL standard.
Be the first to comment

Joe Celko’s SQL Puzzles and Answers

Posted April 10, 2011 By Mike

Joe Celko’s SQL Puzzles and Answers
Joe Celko
ISBN 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.
Be the first to comment

Joe Celko’s Trees and Hierarchies in SQL for Smarties
Joe Celko
ISBN 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 and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more.

Be the first to comment

Relational Database Design Clearly Explained

Posted April 6, 2011 By Mike

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

Handbook of Relational Database Design

Posted April 5, 2011 By Mike

Handbook of Relational Database Design
Candace C. Fleming, Barbara Vonhalle
ISBN No. 0-2011-1434-8
This is an old classic published in 1988. It’s not for the novice reader.
Be the first to comment

Programming Microsoft SQL Server 2005

Posted April 4, 2011 By Mike

Programming Microsoft SQL Server 2005
Andrew Brust and Stephen Forte
ISBN 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.
Be the first to comment

Microsoft Access Developer’s Guide to SQL Server
Mary Chipman and Andy Baron
ISBN 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.
Be the first to comment

Hitchhiker’s Guide to Visual Basic and SQL Server
William R. Vaughn
ISBN No. 1-57231-848-1
CD 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.
Be the first to comment

Inside Microsoft SQL Server 2000

Posted April 2, 2011 By Mike

Inside Microsoft SQL Server 2000
Kalen Delaney
ISBN 0-73560-998-5
A thorough review of how to work with SQL Server 2000, including tuning and management tips.
Be the first to comment

Microsoft Access 2000 Visual Basic for Applications Fundamentals
Evan Callahan
ISBN 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 recommended instead.
Be the first to comment

Microsoft Visual Basic 6.0 Step-By-Step

Posted April 1, 2011 By Mike
Microsoft Visual Basic 6.0 Step-By-Step Microsoft Visual Basic 6.0 Step-By-Step
Michael Halvorson
ISBN 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.
Be the first to comment

VBA Developers Handbook

Posted April 1, 2011 By Mike
VBA Developers Handbook VBA Developers Handbook
Ken Getz, Michael Gilbert
ISBN 0-7821-1951-4
CD 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.
Be the first to comment
Dan Appleman's Developing COM/ ActiveX Components with Visual Basic 6 Dan Appleman’s Developing COM/ ActiveX Components with Visual Basic 6
Dan Appleman
ISBN 1-56276-576-0
CD 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.
Be the first to comment