Access 97 Macro & VBA Handbook (Paperback)

~ (Author) "A database is a collection of records and files..." (more)
Key Phrases: default navigation buttons, macro flow diagram, lookup combo box, End Sub, Visual Basic, Customer Orders (more...)

Editorial Reviews

Product Description

Improve your database productivity with this task-oriented guide to creating timesaving Access macros. See how Visual Basic for Applications (VBA) makes it easier than ever to write and record macros, create Wizards, and design VBA links to other Office Suite products--even if you have no prior programming experience. The companion CD contains all code from the book, as well as shareware and evaluation copies of Access add-ins.

From the Back Cover

Access 97 Macro & VBA Handbook is a comprehensive guide to using macro and VBA programming to create custom database applications with Microsoft's Access 97. Building on your basic knowledge of Access, this book takes you to the next level. Master the skills you'll need to both automate complex processes and design and deliver applications that meet user's exacting requirements.

Microsoft Office & VBA Developer Magazine: March 1998 issue
"If you've been considering taking the leap from Access user to Access programmer, you can use the wide, sturdy bridge built by Susann Novalis... The book provides rich instruction... Novalis displays a real talent for making complex concepts appear simple."

Product Details

• Paperback: 1074 pages
• Publisher: Sybex (February 15, 1997)
• Language: English
• ISBN-10: 0782119778
• ISBN-13: 978-0782119770
• Product Dimensions: 9 x 7.6 x 2.2 inches
• Shipping Weight: 3.8 pounds
• Average Customer Review: 3.2 out of 5 stars  See all reviews (17 customer reviews)
• Amazon.com Sales Rank: #911,414 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

22 of 22 people found the following review helpful:

3.0 out of 5 stars Not as good as it could have been, July 13, 1999

By A Customer

When I flipped through the book in the store, it looked pretty good, better than the other book I looked at. (Access 97 Power Programming) Unfortunately, once I got down to using it, it left a lot to be desired. The main thing I was hoping for was a good, in depth, lesson on DAO. The examples are about on par with the ones in the online help, ie. they cover the trivial case, but don't really help with more typical cases. Also, as mentioned by someone else, there are far to many typos, especially in the examples. I didn't come close to trying every example, but there were several that didn't work as printed. Finally, why were the tables and appendices put on the CD instead of in the book where they belong? For the first day I had the book, I couldn't look at any of the tables, since my computer at work doesn't have a CD-ROM drive. All in all, it's not a bad book, but I can't recommend it at its full retail price. By the time bookstores are blowing it out cheap, it'll be 3 versions out of date, so there's really no reason not to buy something else.

13 of 14 people found the following review helpful:

2.0 out of 5 stars Frustration! - good intentions, but looks hurried-to-print, March 4, 1999

By A Customer

I read and enjoyed Novalis' earlier Access book on Macros; the only one written specifically on that subject. Once past the first 90-100 pages, she hit a stride of good detail and useful specifics. I expected the same from this Access 97 book. I was wrong. Too often, pages go by without specific examples (especially in macros section). It really breaks down in the VBA section; there are lots of sample code, but virtually no detailed explanation of the statements -- her code samples are completely devoid of line-by-line (or section-by-section) documentation that in real life you would hope a programmer to include, especially for learning purposes. Unfortunately, it's as though Novalis rushed the book into print. It still has useful information, but seems to lack the clarity of purpose, the specifics targeted for learning purposes, and the tied-together presentation of subject matter found in her earlier book. She still includes quite a bit of information, but it is a struggle to find it, and then to really learn from it.

7 of 7 people found the following review helpful:

1.0 out of 5 stars Can You Spell U-S-E-L-E-S-S; How About B-O-R-I-N-G?, June 1, 1999

By A Customer

I wish I would have read the reviews here (particularly the one about a wasted tree) before I shelled out my money to buy this (God I hate to use the word) book. The authors writing style is boring and tedious. The author has not included enough quality code examples, and instead, has opted to include countless screen images that do little more than take up page space.