Product Description

How Far Can You Go with Access 2002?
The answer depends on your knowledge of VBA programming. If you really want to get the most out of Access, the Access 2002 VBA Handbook is essential reading. If you are an experienced user of Access, you get the step–by–step instruction you need to be dramatically more productive. And if you are a more experienced developer, you get the advanced VBA programming skills you need to build the Access applications your users require. Coverage includes
∗ Running queries to find specific records
∗ Automating complex and time–consuming procedures
∗ Importing data from existing data sources
∗ Synchronizing forms and tables
∗ Understanding the ADO and DAO models
∗ Understanding the essentials of Visual Basic for Applications (VBA)
∗ Customizing the Access user interface
∗ Creating procedures to change Access′s default error–handling processes
∗ Accessing data using OLE DB and ODBC
∗ Creating VBA procedures for navigating a database or project
∗ Writing VBA procedures using object properties and methods
∗ Creating relationships between forms
∗ Executing commands using SQL statements in VBA code
∗ Using ActiveX controls in your VBA procedures

Product Details

• Amazon Sales Rank: #305392 in Books
• Published on: 2001-10-15
• Original language: English
• Number of items: 1
• Binding: Paperback
• 880 pages

From the Back Cover
How Far Can You Go with Access 2002?
The answer depends on your knowledge of VBA programming. If you really want to get the most out of Access, the Access 2002 VBA Handbook is essential reading. If you are an experienced user of Access, you get the step–by–step instruction you need to be dramatically more productive. And if you are a more experienced developer, you get the advanced VBA programming skills you need to build the Access applications your users require. Coverage includes

• Running queries to find specific records
• Automating complex and time–consuming procedures
• Importing data from existing data sources
• Synchronizing forms and tables
• Understanding the ADO and DAO models
• Understanding the essentials of Visual Basic for Applications (VBA)
• Customizing the Access user interface
• Creating procedures to change Access′s default error–handling processes
• Accessing data using OLE DB and ODBC
• Creating VBA procedures for navigating a database or project
• Writing VBA procedures using object properties and methods
• Creating relationships between forms
• Executing commands using SQL statements in VBA code
• Using ActiveX controls in your VBA procedures

About the Author
Susann Novalis, Ph.D., is a Professor of Mathematics and Associate Dean of the College of Science and Engineering at San Francisco State University. She is the author of Access 2000 VBA Handbook and Access 97 Macro & VBA Handbook, both from Sybex. She has also published articles in Access Visual Basic Advisor and Internet Advisor. Dana Jones is a consultant with MCW Technologies, a Microsoft Solution Provider, and has written for SmartAccess.

Customer Reviews

Great intro into VBA and ADO for non programmers
An excellent buy, this book has enabled me to customise my previous access databases so that even the most technically challanged of my colleagues can use them.

This book is aimed at those, like me, who have experience of Access but have very little knowledge of programming bar a few Excel macros.
I would not recommend it for absolute novices to Access as the basics of table, query, form and report design and interaction is not covered.

The book is well written and meets the demands of its target audience. The information is well organised with plenty of examples for practice throughout the book.

The topics covered that I found most useful were:
Object methods and properties, what they are and how to set them programmatically.
Definitive information on the VBA programming environment and object browser in access.
The introduction to ADO and ADOX structures and use of recordsets.
Use of variables and public procedures to create faster and reusable code.
Comprehensive Error handling, helps get rid of those cryptic default error messages.

The only negative I can think of is that it takes to chapter 10 before you really get into creating code that you can use. But as there is so much useful info for reference in the earlier chapters it isn't worth taking half a star off the rating.

Experienced programmers with knowledge of ADO may find this book a little too basic and should maybe plunge straight into the Access 2002 Developers Handbook.