|
|
Microsoft Office Access 2007 Inside Out
John L. Viescas
Jeff Conrad
ISBN 0-7356-2325-2
$49.99 (list price)
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. |
|
|
Building Microsoft Access
Applications
John L. Viescas
ISBN 0-7356-2039-3
$49.99 (list price)
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. |
|
|
Microsoft Office Access 2003
Inside Out
John L. Viescas
ISBN 0-7356-1513-6
$49.99 (list price)
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. |
|
Special Edition Using Access
2002
Roger Jennings
ISBN 0-78972-510-X
$49.99 (list price)
CD included. |
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
Paul Litwin, Ken Getz,
Mike Gunderloy
ISBN 0-7821-4011-4
$99.98 (list price)
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? |
|
Access Cookbook
Paul Litwin, Ken Getz,
Andy Baron
ISBN 0-5960-0084-7
$49.95 (list price)
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. |
|
Microsoft Access 2002 Step-by-Step
Online Training Solutions,
Inc.
ISBN 0-73561-299-4
$29.95 (list price)
Disk 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
John L. Viescas
ISBN 1-57231-934-8
$44.99 (list price)
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! |
|
Microsoft Access 2000 Step-by-Step
Catapult, Inc.
ISBN 1-57231-976-3
$29.95 (list price)
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. |
|
Access 2000 Developers Handbook
Paul Litwin, Ken Getz, Michael Gilbert
ISBN 0-7821-2370-8
$59.99 (list price)
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. |
|
Access 2000 Developers Handbook
Set
Paul Litwin, Ken Getz, Michael Gilbert
ISBN 0-7821-2371-6
$99.99 (list price)
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. |
|
Top
SQL / Database Design
Click on any book cover to enter Amazon.com to find out more. |
|
|
SQL Queries for Mere Mortals,
2nd Edition John
L. Viescas
Michael J. Hernandez
ISBN No. 0-321-44443-4
$49.99 (list price)
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. |
|
|
Database Design for Mere Mortals,
Second Edition Michael
J. Hernandez
ISBN No. 0-201-75284-0
$49.99 (list price) |
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. |
|
Joe Celko's SQL
for Smarties: Advanced SQL Programming
Joe Celko
ISBN No. 1-558-60576-2
$49.95 (list price)
|
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. |
|
Joe Celko's SQL
Puzzles and Answers Joe
Celko
ISBN No. 1-558-60453-7
$31.95 (list price) |
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
Joe Celko
ISBN No. 1558609202
$34.95 (list price)
|
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. |
|
Relational Database Design Clearly
Explained Jan L. Harrington
ISBN No. 0-12326-425-1
$34.95 (list price) |
Another relatively simple and readable
approach to database design. A bit more academic than Mike's book. |
|
Handbook of Relational Database Design
Candace C. Fleming, Barbara Vonhalle
ISBN No. 0-2011-1434-8
$55.95
|
This is an old classic published in
1988. Not for the novice reader. |
|
Top
SQL Server
Click on any book cover to enter Amazon.com to find out more.
|
|
|
Inside
Microsoft SQL Server 2005: T-SQL Programming
Itzik Ben-gan,
Dejan Sarka, and Roger Wolter
ISBN 0735621977
$44.99 (list price)
|
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. |
|
Programming Microsoft SQL Server 2005
Andrew Brust and
Stephen Forte
ISBN 0735619239
$49.99 (list price)
|
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 Mary
Chipman and Andy Baron
ISBN No. 0-67231-944-6
$39.99 (list price) |
This is THE
book to have if you're developing
applications using Microsoft Access 2000
linked to a Microsoft SQL Server
database. |
|
Inside
Microsoft SQL Server 2000 Kalen
Delaney
ISBN 0-73560-998-5
$59.99 (list price)
CD Included |
A thorough review of how to work with SQL
Server 2000, including tuning and management tips. |
|
Hitchhiker's Guide to Visual Basic and
SQL Server William R. Vaughn
ISBN No. 1-57231-848-1
$49.99 (list price)
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. |
|
Top
Visual Basic
Click on any book cover to enter Amazon.com to find out more.
|
|
|
Microsoft Access Visual Basic Step
By Step Evan
Callahan
ISBN No. 1-55615-890-4
$29.99 (list price) |
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. |
|
|
Microsoft
Access 2000 Visual Basic for
Applications Fundamentals Evan
Callahan
ISBN No. 0-73560-592-0
$39.99 (list price) |
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
books in the Access section above. |
 |
Microsoft Visual Basic 6.0 Step-By-Step Michael
Halvorson
ISBN No. 1-57231-809-0
$39.99 (list price) |
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
Ken Getz, Michael Gilbert
ISBN 0-7821-1951-4
$59.99 (list price)
CD included. |
This is the companion book to Access 97
Developers Handbook (Litwin, Getz, Gilbert) listed above. 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
Dan Appleman
ISBN 1-56276-576-0
$49.99 (list price)
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. |
