Product Description

Want to get the most out of Access? Then you need to know VBA.

Access 2000 is here, and never has the power of Access depended so much on VBA programming. This makes the Access 2000 VBA Handbook essential reading if you want to use Microsoft′s popular database product to its full advantage. If you′re an Access user, you′ll benefit from step–by–step coverage of VBA basics that will simplify your work. If you′re a developer, you′ll master the high–end techniques introduced in the latest release–so you can stay on top of your job.

You′ll learn how to:
∗ Create databases and projects
∗ View and print reports
∗ Run queries to find specific records
∗ Automate complex and time–consuming procedures
∗ Synchronize forms and tables
∗ Understand the ADO and DAO models
∗ Customize the user interface
∗ Access data using OLE DB and ODBC
∗ Create VBA procedures for navigating a database or project
∗ Use object properties and methods to write VBA procedures
∗ Create relationships between forms
∗ Execute commands using SQL statements in VBA code
∗ Use ActiveX controls in your VBA procedures

Product Details

• Amazon Sales Rank: #215910 in Books
• Published on: 1999-07-22
• Original language: English
• Number of items: 1
• Binding: Paperback
• 845 pages

From the Back Cover
Want to get the most out of Access? Then you need to know VBA.

Access 2000 is here, and never has the power of Access depended so much on VBA programming. This makes the Access 2000 VBA Handbook essential reading if you want to use Microsoft′s popular database product to its full advantage. If you′re an Access user, you′ll benefit from step–by–step coverage of VBA basics that will simplify your work. If you′re a developer, you′ll master the high–end techniques introduced in the latest release–so you can stay on top of your job.

You′ll learn how to:

• Create databases and projects
• View and print reports
• Run queries to find specific records
• Automate complex and time–consuming procedures
• Synchronize forms and tables
• Understand the ADO and DAO models
• Customize the user interface
• Access data using OLE DB and ODBC
• Create VBA procedures for navigating a database or project
• Use object properties and methods to write VBA procedures
• Create relationships between forms
• Execute commands using SQL statements in VBA code
• Use 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 97 Macro & VBA Handbook and Automating Microsoft Access with Macros, both from Sybex. Her work has also appeared in Access Visual Basic Advisor and Internet Advisor magazines.

Customer Reviews

Worth every penny!
This book, like Susann Novalis' previous book on the subject, is excellent. She understands the things you need to know. There is enough attention to detail to ensure important points are not missed. The layout is easy to follow and it's easy to find what you want. Most importantly, the content is accurate and great care has been taken to ensure every sentence can be clearly understood.

I have read this book cover to cover, and like her previous book its the first reference book on the subject I turn to. Well done, Susann. I wish all reference books on programming were written as informatively and clearly as this one.

A comment
Let us give this book a chance. I think the author had a very good reason of reviewing and revising the original manuscript of the book before it was published. I suggest to the person that initially commented on the book to write his/her own book and let the public comment if he/she is adept in the subject matter.

An awful book
Having purchased the Access developers handbooks (1 and 2) in the Sybex series, I needed to reinforce my understanding of VBA. I did not need pages and pages on the database wizard, there seems to be no structure and little understanding on the Authors part. A very poor publication and I would not recommend it to anyone.