Buy Used
£0.01
+ £2.80 UK delivery
Used: Very Good | Details
Sold by SNaylerBooks
Condition: Used: Very Good
Comment: Orders shipped daily from the UK. All international orders sent via airmail. Professional seller. Enquiries responded to daily.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Beginning Access 97 VBA Programming Paperback – 1 Sep 1997


See all formats and editions Hide other formats and editions
Amazon Price New from Used from
Paperback
"Please retry"
£0.01


Product details

  • Paperback: 640 pages
  • Publisher: WROX Press Ltd; Pap/Cdr edition (1 Sept. 1997)
  • Language: English
  • ISBN-10: 1861000863
  • ISBN-13: 978-1861000866
  • Product Dimensions: 23.6 x 18.6 x 4.2 cm
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (37 customer reviews)
  • Amazon Bestsellers Rank: 1,654,391 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

Synopsis

Access 97 is the database of choice for the home and small business user. While its intuitive interface makes data storage and manipulation incredibly simple, you really need its underlying language, Visual Basic for Applications (VBA), to make the most use of its features. VBA is the language that unites the whole Office 97 suite, allowing users to exploit the power of each Office application within their environment of choice. VBA allows you to automate and secure your database, so your end-users need never know what goes on underneath. Its simple style allows even complete novices to programming to achieve impressive results with very little effort. This book provides comprehensive coverage of this subject.

About the Author

Robert Smith is a graduate of Oxford University who has been working for Anthony Coook Associates since 1994. He has been developing with Access since its first release in 1992. About half of his time is psent developing with Access and SQL Server anf the remainder is spent on consultancy in client/server design and development issues.

David Sussman
David gained experience in BASIC, Pascal, COBOL and OCCAM, before joining a UNIX system house where he stayed for 4 years, becoming the chief UNIX/C guru. For the last 3 years he has been working for a Microsoft Solution Provider, specializing in Access, VB and SQL Server, as well as playing extensively with every Beta product that comes his way.

Customer Reviews

4.3 out of 5 stars

Most Helpful Customer Reviews

2 of 2 people found the following review helpful By A Customer on 23 July 1999
Format: Paperback
I had taken a five day class in Access by Executrain and had been working for a few months both before and after that in Access. I was creating some nice databases at work but needed to do more. I bought this book to learn how to use VBA and make more dynamic databases.
This book was everything I had hoped for and more. It is an excellent tutorial and has a perfect match between the book and the sample files on the disk. I tried to learn Access with the "Access 97 Bible" but it had a terrible tutorial and the sample files did not even resemble the book. This book is a must for anyone who wants to create complex, full-feature datbases with great functionality. I have only completed the first six and a half chapters and have learned so much. The text is clear, easy to read, and very well ordered. Despite not having programed basic since my PCjr it was a great reintroduction to programming. It starts off very basic and does not leave you behind.
I could not recommend this book more highly for anyone wanting to program VBA in Access 97.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By A Customer on 15 Dec. 1997
Format: Paperback
This is a great book on programming Access from below the covers... using VBA. Although the book says its "Beginning" don't rely on that. This is a great intermediate book, with lots of stuff for the beginners thrown in. Thus, the intermediate programmer must wade through the usual "this is a program" stuff, but it's a trip well worth the time, because the authors provide many unknown secrets to VBA programming with Access. As a VB programmer, using Access VBA can be extremely frustrating because of the things you can't do. The authors solve many of those little things that can hang you up in Access. For example, this book has taught me to link single forms... rather than using sub-forms. It has also taught me to throw away many other commonly accepted "Access'isms". I wished they had covered how to build menus. No one seems to cover the whole kludgy story. Why does Access/VBA make this such a difficult task... compared to VB5? The book is laid out well, with lots of code examples. I hope they come out with an "Intermediate" or "Advanced" version. The author, David Sussman, also teaches a class at ZDU online which uses this book. This is another great book from Wrox press, a publisher that does a great job at covering programming topics indepth. The authors are Scotch, yet thankfully manage to spell "color" without the "u". They also deliver their lessons with a sense of humor.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By A Customer on 19 July 2000
Format: Paperback
This book helped me where all the others failed. I was looking for some help with VBA programming in Access. This was the only place I found what I needed, and I had looked in 6-8 other Access books before getting to this one. The examples provided were excellent, and supplied with all the underlying code. This helped to learn-by -example, and actually follow what the code was doing. I will be looking for more Wrox books when I need help with future projects.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By A Customer on 5 Jun. 1999
Format: Paperback
As you know by now, most programming books fall into one of two categories: expert references, or trivial introductions. Wrox books usually fall somewhere in between. As an result, these books usually create some controversy over who should read them. If you have had any programming experience, either in class or self-taught, you should do fine. It does NOT cover relational database design, nor does it teach SQL.
This book covers most of the basics: responding to events, building forms, using form modules, using code modules, programming reports, creating classes, etc. While it does these things well, it also has many errors that can trip up novice programmers. In one chapter, some sample code uses the "IsMissing" function with optional date parameters. This function only works with variant data types. Chapter 16's OLE example ("Communicating with Other Applications") simply cannot run as listed. You have to make some serious code changes in order for it to work as advertised. These oversights made me feel like the authors did not test all of their examples first. If the rest of the book were not excellent, this book would have received a 3-star rating.
Unlike most other Wrox books, this one includes an accompanying CD-ROM. I found it to be indispensable to completing the in-chapter examples and the end-of-chapter problems. It dovetailed nicely with the text, allowing me to move rapidly through the material.
This book is also a good launching point for developing more complex VB programming skills. It is a good buy, but make sure that you visit the errata pages on Wrox' web site while you work your way through this one.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
demonstrate, (in the very first chapter), that there are situations in database management that can only be solved with programming.
Although I majored (many years ago) in Computer Science in college, I am relatively new to Access and Access VBA programming. (I came to Access after 3-4 years of doing dBASE.) Naturally, my boss threw me in to a fairly significant project that required me to get "real smart" real fast with Access; which is what led me to this book.
This is a good "nuts and bolts" type programming book. Nuggets of programming wisdom are scattered throughout. You get the feeling, as you work your way thru the book, that the authors have payed their dues - they know (intimately) of what they speak. (The occassional smattering of British wit and humor is also refreshing.)
The only shortcoming I find with this book is minimal coverage of data normalization and database design issues. (Most of this is glossed over in the first chapter.) However, since entire textbooks are written on this subject, this is a "sin" that can be forgiven. (I suspect the authors intentionally chose to avoid a long chapter or two on normalization precisely because this is a "Beginning" book and they didn't want to get their readers bogged down in - and bored with - all the thorny details of database design theory.)
All-in-all, this is an excellent book. Spend time digging deep into this book and you will learn and grow as a programmer. There are other [good] Access programming books out there, but if you're going to be doing serious Access development work, (and you care about the quality of the code you write), you could do a lot worse than to buy this book.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews



Feedback