Beginning Access 2007 VBA and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading Beginning Access 2007 VBA on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Beginning Access 2007 VBA [Paperback]

Denise M. Gosnell

List Price: CDN$ 43.99
Price: CDN$ 27.58 & FREE Shipping. Details
You Save: CDN$ 16.41 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Tuesday, July 29? Choose One-Day Shipping at checkout.

Formats

Amazon Price New from Used from
Kindle Edition CDN $26.20  
Paperback CDN $27.58  
Join Amazon Student in Canada


Book Description

April 30 2007 0470046848 978-0470046845 1
This book provides you with the tools and techniques you’ll need in order to build more sophisticated solutions. After walking through the features of Access 2007 VBA, you’ll learn all about object-oriented programming and ADO. You’ll then progress to advanced VBA concepts such as working with external DLLs and using automation to control external programs. Plus, two comprehensive case studies presents you with the hands-on experience in building real-world solutions using the concepts covered in the book.

Customers Who Bought This Item Also Bought


Product Details


Product Description

From the Back Cover

If you want to take your Access databases to a more robust level of functionality, then this is the book for you. It provides the tools and techniques you'll need in order to build more sophisticated solutions. You'll find plenty of source code and fully developed sample applications to guide you along the way.

After walking through the features of Access 2007 VBA, you'll learn all about object-oriented programming and ADO. You'll then progress to advanced VBA concepts such as working with external DLLs and using automation to control external programs. And with the help of two comprehensive case studies, you'll gain hands-on experience in building real-world solutions using the concepts covered in the book.

From creating custom objects and reports programmatically to integrating Access with web services and SQL Server, this hands-on guide gets you started quickly.

What you will learn from this book

  • Techniques for using ActiveX® Data Objects (ADO) to retrieve and update data
  • Steps for building reports and web content from the database

  • How to develop SQL Server solutions with Access projects

  • Tips for fine-tuning and distributing your application

  • Ways to import, link, and export data to and from external data sources

  • How to send emails programmatically from your database

  • How to create interactive forms, export data to HTML, enhance security, and much more

Who this book is for

This book is for the Access 2007 user who is just getting started in creating their own applications as well as the programmer who is new to Access development. No prior experience with VBA is required.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured tutorial format that will guide you through all the techniques involved.

About the Author

Denise Gosnell is a software patent attorney and technology consultant with Gosnell & Associates, Inc., which she founded in 2005. Denise has a unique background in both technology and law, and presently uses her deep technical and legal expertise to counsel hi-tech clients on intellectual property and technical matters. Denise was recognized in February 2005 with the Indianapolis Business Journal award: “Top 40 Under 40,” which recognizes the top up-and-coming professionals under the age of 40 in the city of Indianapolis each year. She also appeared on the Inside Indiana Business with Gerry Dick television show in March 2005 to discuss hi-tech issues facing the business world.
Denise has over 12 years of experience in creating software applications, ranging from standalone and client-server to enterprise-wide applications. Denise has worked for leading software companies such as Microsoft and EDS, and has earned a worldwide reputation for her technology expertise. She received a bachelor of arts degree in Computer Science–Business (summa cum laude) from Anderson University, where she currently serves as an adjunct professor for the Computer Science Department. Denise obtained a doctor of jurisprudence degree from Indiana University School of Law in Indianapolis.
Denise has authored and coauthored seven other software development books to date, covering topics such as database development, Access, Visual Basic .NET, and web services. Most recently, Denise authored Professional Development with Web APIs (Wiley 2005) and Beginning Access 2003 VBA (Wiley 2004). Denise was a featured technology speaker at the Microsoft European Professional Developer’s Conference in December 2001 and has on numerous occasions assisted Microsoft’s Training and Certification group in creating new exams for their MCSD and MCSE certifications.

Inside This Book (Learn More)
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 2.0 out of 5 stars  6 reviews
8 of 9 people found the following review helpful
1.0 out of 5 stars Most of the codes in the book do not work Dec 19 2008
By openmind - Published on Amazon.com
Format:Paperback|Verified Purchase
It is absolutely unforgivable for this book to be published given that most of the examples in the book do not work. The public should demand its money.
1 of 1 people found the following review helpful
1.0 out of 5 stars I want my money back. Nov. 4 2011
By Amazon Customer - Published on Amazon.com
Format:Kindle Edition|Verified Purchase
I bought this book because it purported to contain information on how to use web services with Access 2007 VBA. However, the section on Using Data From Web Services talks about how this was done with Access 2003 not Access 2007.

I just wasted my money and I'm putting this review here because I hope anyone else interested in how to consume web services in Access 2007 VBA will see it an avoid buying this book.

Warning!!! This book tells you absolutely nothing about how to use web services with Access 2007 VBA even though the Table of Contents and the Index plainly give the impression that it does.
7 of 10 people found the following review helpful
1.0 out of 5 stars Bad Code for Connecting Access to SQL May 20 2008
By M. Daly - Published on Amazon.com
Format:Paperback
I bought this book to review VBA and learn how to connect Access to Microsoft SQL Server. The code for connecting Access to SQL is wrong, and there is no trouble shooting guide. I'm ready to throw this book away, and start over.
0 of 1 people found the following review helpful
4.0 out of 5 stars Access2007 VBA very helpful Oct. 14 2009
By Kevin Rice - Published on Amazon.com
Format:Paperback|Verified Purchase
Very well- written book, in friendly style. Minor criticism is too much advanced topic matter (custom class definitions, etc) with some of the basics skipped over. Very helpful to this beginner though, very useful.
0 of 2 people found the following review helpful
4.0 out of 5 stars Most of the codes in this book work for me Aug. 7 2009
By Ronald Gould - Published on Amazon.com
Format:Paperback
I think it is a very good book for the people has some experience in the object oriented programming. The most of the codes are working for me especially chapter 13 Case Study. I hope I can find the codes for chapter 14 from internet.

Look for similar items by category


Feedback