Access 2010 Programmer's Reference 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 Access 2010 Programmer's Reference on your Kindle in under a minute.

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

Access 2010 Programmer's Reference [Paperback]

Teresa Hennig , Rob Cooper , Geoffrey L. Griffith , Jerry Dennison
5.0 out of 5 stars  See all reviews (2 customer reviews)
List Price: CDN$ 53.99
Price: CDN$ 27.00 & FREE Shipping. Details
You Save: CDN$ 26.99 (50%)
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 3 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Thursday, April 24? Choose One-Day Shipping at checkout.

Formats

Amazon Price New from Used from
Kindle Edition CDN $25.65  
Paperback CDN $27.00  
Save Up to 50% on "For Dummies" Books
Lighthearted but not lightweight, For Dummies books are great references not only for tackling new subjects but also for brushing up on subjects with which you're already familiar. Get results while saving up to 50%. See more.

Book Description

Aug. 9 2010 0470591668 978-0470591666
A comprehensive guide to programming for Access 2010 and 2007

Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements.

With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic.

Access 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications.

Coverage Includes:

  • Introduction to Microsoft Access 2010
  • New Features
  • Upgrading and Converting to Access 2010
  • Macros in Access 2010
  • Using the VBA Editor
  • VBA Basics
  • Using VBA in Access
  • Creating Classes in VBA
  • Extending VBA with APIs
  • Working with the Windows Registry
  • Using DAO to Access Data
  • Using ADO to Access Data
  • Using SQL with VBA
  • Using VBA to Enhance Forms
  • Enhancing Reports with VBA
  • Customizing the Ribbon
  • Customizing the Office Backstage
  • Working with Office 2010
  • Working with SharePoint
  • Working with .NET
  • Building Client-Server Applications with Access
  • The Access 2010 Templates
  • Access Runtime Deployment
  • Database Security
  • Access 2010 Security Features

Frequently Bought Together

Customers buy this book with Access 2010 Bible CDN$ 30.00

Access 2010 Programmer's Reference + Access 2010 Bible
Price For Both: CDN$ 57.00

Show availability and shipping details

  • This item: Access 2010 Programmer's Reference

    In Stock.
    Ships from and sold by Amazon.ca.
    FREE Shipping. Details

  • Access 2010 Bible

    In Stock.
    Ships from and sold by Amazon.ca.
    FREE Shipping. Details


Customers Who Bought This Item Also Bought


Product Details


Product Description

From the Back Cover

Build robust database applications with Access 2010

Microsoft Access 2010 offers a rich set of features and design tools for storing, analyzing, and viewing data, along with the inherent ability to connect to a large variety of data sources. With this book, you'll discover the benefits of using the newest features to build small- to medium-scale database applications, integrate with other programs, create Web applications, and upgrade existing solutions.

Access 2010 Programmer's Reference:

  • Shows you how to program VBA and macros for Access, including use of error handling, best practices, and helpful tips

  • Provides code examples that demonstrate how to enhance and extend the functionality of Access applications

  • Shows when, why, and how to use DAO and ADO in VBA

  • Demonstrates how to build Access applications that leverage SharePoint®, SQL Server®, Excel®, XML, and other sources

  • Discusses deployment considerations, such as working with mixed platforms and versions, 64-bit Office, Access Runtime, Access and database security, and upgrading and conversions

Wrox Programmer's References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.

wrox.com Programmer Forums

Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.

Code Downloads

Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More

Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

About the Author

Teresa Hennig is a Microsoft Access MVP, and is President of the Seattle Access Group and the Pacific Northwest Access Developer Group. Her company, Data Dynamics NW, has been creating Access solutions since 1997.

Rob Cooper is a senior test lead at Microsoft. During the Access 2010 release, he led the team that worked on exciting new features such as the Macro Designer, Navigation Control, and Web Browser Control.

Geoffrey Griffith has more than 13 years experience with Access. He began his Access life working in Access 2.0 and eventually worked on the Microsoft Access Team for the Access 2007 release.

Jerry Dennison is a Microsoft Access MVP and has been developing custom and commercial Access applications since 1991. He is the owner of TradeIt! Software Support Services, an Access-based barter management solution.


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

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most helpful customer reviews
5.0 out of 5 stars A must have for any Access programmer. Feb. 11 2013
By Andy
Format:Paperback|Verified Purchase
I am an Access programmer and refer back to this book weekly. I use this to build new applications and to reference.
Was this review helpful to you?
5.0 out of 5 stars Great Resource Sept. 9 2010
Format:Paperback
This book is a great resource - explanation of ribbons is easy to understand. A worthy purchase.
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.2 out of 5 stars  24 reviews
57 of 60 people found the following review helpful
3.0 out of 5 stars Index is not adequate for a reference book Sept. 26 2011
By quietstorm - Published on Amazon.com
Format:Paperback|Verified Purchase
It's not a bad book. I read the entire book even though I was disappointed early on (see my gripe about the index later in the review). To be brutally honest there are some classics out there that are better, and I am using some of them. But they are getting dated and I wanted to learn some new things and particularly get a good feel for the new version of Access 2010.

The style of sample code and follow-along examples is different from book to book. I prefer verbose and well-illustrated examples. The examples in this book are not quite to my liking, but some of you may find you prefer it. I won't try to explain further because if you've read a number of books you already know how examples and sample code are handled quite differently. I should mention the style of examples in this book varys a bit from chapter to chapter.

This book is the product of several/many authors and contributors; different authors wrote different chapters. Some of the chapters deliver advanced concepts in a terse style. Some of you will have to reread things carefully before moving on. Again, some of you may prefer this. In my case, I'd rather have more illuminating explanations.

There no good "war stories" or anecdotes about crazy bugs or situations they've encountered and had to work through. By contrast, in the famous Access 2002 Developers Handbook (which you should all have or get right now) the authors are willing to share gripes about things like misspelled property names and weird wildcard conventions or the like.

If you're like me, these tales from the trenches and even a little humor really bring a book to life, and the closest this book gets is rah rah coverage of "new and exciting" features in Access 2010. This book could be brought to life by giving us some stories and some dirt.

I believe these guys have access to Microsoft sources they rely on. I believe this affects their coverage and they are reluctant to criticize and eager to cheerlead. But I want and need honest information about quirks and problems, and this book does not have it. An example is crashing the database and temporarily corrupting it if you write/edit too much VBA code in debug mode. If you Google "access crashes when opening vba" you will get the idea. It turns out you have to decompile the database (requires executing a command from the command prompt!). Until you learn this solution your database is hosed, which is horrifying if you just did some inspired and hard work since your last backup (you do have a backup I hope). And the experts recommend not editing VBA outside of design mode until this problem is addressed in a bug fix. Will you find anything about this in this book? No.

Another example is the quirky prompt to save design changes when you didn't make any. It happens when you open a form using the new navigation system (successor to switchboard) and then filter records. It also happens when you use the new "Allow Value List Edits" feature, and it probably happens in other situations. The author of the chapter on Forms mentions a fix in passing but expanded coverage of this would have been welcome. This quirk ruined my experience with the new Navigation Menu interface (the new replacement for the switchboard, not the navigator on the side which we all use extensively). I filter records a lot; if I opened a form from the new navigation interface and filtered, I get this incredibly annoying prompt asking if I want to save design changes. Not something you'd want your users to see, so I had to stop using that feature.

Something that some of you may need to be aware of: This book deals with relatively advanced topics like Class object programming, Windows API, and Windows registry, and it covers them before it deals with topics many of you may want to read about...like forms and reports. And the coverage of these is terse, meaning you have to pay attention and understand each sentence or paragraph before moving on or you will get lost. I didn't mind too much and I understand why they did it, but this coverage may cause some of you to lose interest. And I'd describe the coverage as advanced but shallow (too brief and limited). This was doubtless to limit the already formidable length, but it detracts nonetheless. I would have done away with some of the chapters and expanded others. The chapters are written by different people with different styles. The chapter (near the end) on SQL Server interfacing is really good.

My big gripe is that several times I have tried to look up something in the index and not found it.

Example? "Option Group" is not even in the index of this book! So I looked under "Controls" and not only did not find option group as a subheading there, but was shocked to find very little on controls either! This is supposed to be a programmer's REFERENCE book!

Another example? Filtering. There is almost nothing in the index. Probably because there is not much in the book about it. If you had no other sources, you'd think filtering is of minor importance. I can assure you, and so will others, that is far from the case. (And Microsoft has done a LOT of work improving and perfecting this functionality.)

One more example? Split form. They covered this nicely but did not have this in the index, not even as a sub heading under forms. I had to flip through lots of pages to find what I had remembered them covering.

My issues with the index is the main reason for giving the book three stars. It has happened to me several times. I should point out the index is long but on 3 or 4 occasions I could not find much if anything on a topic I was interested in. I just gave you 3 examples but it happened several more times. I bet this comment will annoy the hell out of whoever did the index, but I'm being honest. If they went to the trouble to make it 20 pages, they may as well add ten or twenty more pages next edition and get ALL the references to topics that exist in the book. Why? If you're like me, you often vaguely remember reading about something that you later realize may be useful and you want to find it without flipping endlessly. An exhaustively complete index is ESSENTIAL for bringing the book to life as a programmer's reference.

Actually though, I consider this book more of an advanced overview than a programmer's reference (I have to point out again that "Programmer's Reference" is the title of the book). I spent a couple weeks of my life reading it, learned some things, and now it will sit on the shelf. It will not be my go-to reference book. I hope the index will work when I try again, but it will not be my first source to try.

Like I said I read it all. But five stars like all these other reviews...sorry I can't do it.To end on a positive note, some of the side highlight notes are interesting and I have learned some new things from the book. One of the best things in the book comes at the VERY end, the very last appendix. Its called "Tips and Tricks." I almost missed it. Its buried behind endless awful coverage of DAO and object model stuff, etc. It would be a shame to miss this very good section.
32 of 33 people found the following review helpful
5.0 out of 5 stars Another winner for Hennig, et al Sept. 14 2010
By Laurin M. Linson - Published on Amazon.com
Format:Paperback
Access 2010 Programmer's Reference is a well-written, well-thought-out, and very helpful book. It's another winner for the team of authors who wrote it.

Not only are the technical details of Access programming in-depth, complete and accurate, and exceptionally well-explained, the features and functions of Access that they are used to implement or supplement are thoroughly explained, too -- just so your memory will be refreshed on those with which you are already familiar and you can learn the ones that are new to this release of the Access product.

I have used Access since its Version 1.0, lead an Access user group, and have been honored by being recognized as a Microsoft Most Valuable Professional for the product. But I wouldn't willingly start an Access 2010 project that I knew would involve code without having this book close at hand. I'm happy to let these extremely knowledgeable authors "do some heavy lifting" for me in identifying new functions and features, and investing the time and energy to determine and document exactly how those functions and features actually work.

Larry Linson
Microsoft Office Access MVP
16 of 17 people found the following review helpful
5.0 out of 5 stars Great book for beginners and seasoned developers May 21 2011
By Luiz C. C. Rocha - Published on Amazon.com
Format:Paperback
This is a very well written book.

At the same time, it's comprehensive and straight to the point: it covers almost all the possible topics about Access development, and on each topic it shows what is important to know, it does not waste reader's time. It explains why features are built this or that way, instead of only listing what the features are. In other words, it's a BOOK, not a MANUAL.

Whether you are a beginner or a seasoned Access developer (new to Access 2010), you will find this book to be very valuable.
9 of 9 people found the following review helpful
5.0 out of 5 stars Another Great Tool for Learning Microsoft Access May 4 2011
By Patrick Headley - Published on Amazon.com
Format:Paperback
As an experienced Access programmer I have read various parts of the Access 2010 Programmer's Reference. As with the Access 2007 Programmer's Reference, this book is easy to read and well organized. There is a significant amount of knowledge contained in its pages. Beginners through advanced users will find this book informative and helpful.
10 of 11 people found the following review helpful
5.0 out of 5 stars Clear instructions, good examples, great tips, and valuable techniques Sept. 25 2010
By Crystal - Published on Amazon.com
Format:Paperback
The depth of knowledge contained in the "Access 2010 Programmers Reference" is impressive - and so is the writing and readability. Detail is balanced well: good foundation if the concept is new and thorough enough to unveil the nuts & bolts. I recommend this book to anyone who needs a top reference for Access 2010 that is enjoyable to read.

This well-written tome flows like a novel with an index worthy of an encyclopedia. It exposes the power of Access in a style that is easy to read. 2010 brings an new way of looking at things ... this book provides understanding and critical perspectives that are necessary for effective database design.

Clear instructions, good examples, great tips, and valuable techniques make this an important book for developers who have built applications in Access for years to those of you who are beginning to wet your toes with Access.

While the text is generally easy to follow, there are sections that I had to read a few times to comprehend, such as the subtleties of BrowseTo. Some of the screen shots were also too small for me to read without getting a magnifier ... which I have <smile>

Overall, the "Access 2010 Programmers Reference" met my high expectations (since the 2007 version is outstanding). I give it the top rating. Thank you Rob, Geoff, Jerry, Teresa :), and others who contributed ... Ben, Doug, Albert, Armen, Jeff, Garry, Steve, Larry, Dane, and more. You gave me knowledge and inspired ideas that will empower me to build more challenging applications. My book will get tattered though ... already has worn and marked-up pages ;)

Warm Regards,
Crystal

*
(: have an awesome day :)
*
Search Customer Reviews
Only search this product's reviews
ARRAY(0xad0e39c0)

Look for similar items by category


Feedback