Books | Viescas Consulting Inc.

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 Conrad, has all the details you need to become an expert using this new version.

Posted in Books, Microsoft Access | Comment

Microsoft Office Access 2007 Inside Out

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.

Posted in Books, Microsoft Access | Comment

Microsoft Access 2003 Inside Out

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.

Posted in Books, Microsoft Access | Comment

Building Microsoft Access Applications

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).

Posted in Books, Microsoft Access | Comment

Special Edition Using Access 2002

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	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).

Posted in Books, Microsoft Access | Comment

Access 2002 Developers Handbook Set

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	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?

Posted in Books, Microsoft Access | Comment

Access Cookbook

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	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.

Posted in Books, Microsoft Access | Comment

Microsoft Access 2002 Step-by-Step

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	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.

Posted in Books, Microsoft Access | Comment

Running Microsoft Access 2000

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!

Posted in Books, Microsoft Access | Comment

Microsoft Access 2000 Step-by-Step

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	Microsoft Access 2000 Step-by-Step Catapult, Inc. ISBN 1-57231-976-3 Disk included
	If you’re a rank beginner, start with this book. Its step-by-step approach gives you an easy introduction to the world of working with Microsoft Access 2000.

Posted in Books, Microsoft Access | Comment

Access 2000 Developers Handbook

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	Access 2000 Developers Handbook Paul Litwin, Ken Getz, Michael Gilbert ISBN 0-7821-2370-8 CD included
	This is the advanced book to own for Microsoft Access 2000. This is volume 1 of a 2 volume set! This volume covers desktop applications only. See below for the 2-volume set to get all the info you need about client-server and distributing applications.

Posted in Books, Microsoft Access | Comment

Access 2000 Developers Handbook Set

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	Access 2000 Developers Handbook Set Paul Litwin, Ken Getz, Michael Gilbert ISBN 0-7821-2371-6 CDs included
	Every serious Access 2000 developer should own this 2-volume set. Not for the faint-of-heart, this 2,864 pages give you everything you need to know about developing Access 2000 applications.

Posted in Books, Microsoft Access | Comment

SQL Queries for Mere Mortals, 2nd Edition

SQL Queries for Mere Mortals, 2nd Edition
John L. Viescas
Michael J. Hernandez
ISBN No. 0-321-44443-4
CD Included with sample databases

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 second edition has been thoroughly revised, with new chapters on UPDATE, INSERT, and DELETE. The sample databases are provided as SQL scripts, SQL Server 2000 databases, Microsoft Access 2000 databases, and MySQL databases and scripts.

Posted in Books, SQL / Database Design | Comment

Database Design for Mere Mortals, Second Edition

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.

Posted in Books, SQL / Database Design | Comment

Joe Celko’s SQL for Smarties: Advanced SQL Programming

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	*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.

Posted in Books, SQL / Database Design | Comment

Joe Celko’s SQL Puzzles and Answers

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	*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.

Posted in Books, SQL / Database Design | Comment

Joe Celko’s Trees and Hierarchies in SQL for Smarties

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.

Posted in Books, SQL / Database Design | Comment

Relational Database Design Clearly Explained

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	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.

Posted in Books, SQL / Database Design | Comment

Handbook of Relational Database Design

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	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.

Posted in Books, SQL / Database Design | Comment

Inside Microsoft SQL Server 2005: T-SQL Programming

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.

Posted in Books, SQL Server | Comment

Programming Microsoft SQL Server 2005

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	*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.

Posted in Books, SQL Server | Comment

Microsoft Access Developer’s Guide to SQL Server

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	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.

Posted in Books, SQL Server | Comment

Hitchhiker’s Guide to Visual Basic and SQL Server

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	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.

Posted in Books, SQL Server | Comment

Inside Microsoft SQL Server 2000

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	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.

Posted in Books, SQL Server | Comment

Microsoft Access Visual Basic Step By Step

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	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.

Posted in Books, Visual Basic | Comment

Microsoft Access 2000 Visual Basic for Applications Fundamentals

<br /> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/viescaconsulinc" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	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.

Posted in Books, Visual Basic | Comment

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.

Posted in Books, Visual Basic | Comment

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.

Posted in Books, Visual Basic | 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.

Posted in Books, Visual Basic | Comment