Robert Smith

John Colby

Martin Reid

Dave Sussman

Ian Blackburn

Mark Horner

Paul Turley

Helmut Watson

What is this book about? Access 2002 is the core database application within the OfficeXP suite. Using VBA (Visual Basic for Applications), the user cancreate his or her own programs in what is essentially a subset ofthe Visual Basic programming language. Using VBA with Access is a tremendously powerful technique, asit allows you to create great user interfaces (like forms orreports) as a front end to actual data storage and manipulationwithin the database itself. What does this book cover? This book is a revision of the best-selling Beginning Access2000 VBA, reworked to provide a rich tutorial to programmingAccess 2002 with VBA. New material covers the enhanced options inAccess 2002 for publishing data to the Web, handling XML,integrating with SQL Server Desktop Engine, and so on. Who is this book for? This book is for the Access user who already has a knowledge ofdatabases and the basic objects of an Access database, and who nowwants to learn how to program with VBA. No prior knowledge ofprogramming is required.

Beginning Access 2002 VBA

Susan Sales Harkins

SQL: Access to SQL Server is more than just a comprehensive reference tool for Access developers. You'll also find efficient SQL solutions for common Access problems and tasks, as well as helpful hints and warnings about what to avoid. Learning Jet SQL is an important step from just using Access to developing with Access. In addition to learning Jet SQL, readers will embark on a journey into the world of SQL Server 2000. The journey starts when you learn how to install SQL Server and ends with an introduction to XML and ASP. Along the way, using Access Data Projects, you'll see features new to SQL Server 2000, including functions that return tables, instead of triggers and gotchas with upsizing. The authors highlight not only the enormous opportunities awaiting you as an Access developer, but also the potential challenges and pitfalls you may face as you move from Access to SQL Server 2000.

Access to SQL Server

Martin Reid

Books

Your next favorite book is out there