Access 2007 Bible (Paperback)

~ Michael R. Groh (Author), Joseph C. Stockman (Author), (Author), (Author), (Author), Jennifer Reardon (Author)
Key Phrases: design view, datasheet view, field list, Microsoft Access, Access Auto Auctions, Access Building Blocks (more...)

Editorial Reviews

Product Description

"I recommend this book for anyone who wants a strong foundation in Access."
—Jeff Lenamon, CIBC World Markets

Updated edition with exciting new Access 2007 features!

Harness the power of Access 2007 with the expert guidance in this comprehensive reference. Beginners will appreciate the thorough attention to database fundamentals and terminology. Experienced users can jump right into Access 2007 enhancements like the all-new user interface and wider use of XML and Web services. Each of the book's six parts thoroughly focuses on key elements in a logical sequence, so you have what you need, when you need it. Designed as both a reference and a tutorial, Access 2007 Bible is a powerful tool for developers needing to make the most of the new features in Access 2007.

• Build Access tables using good relational database techniques
• Construct efficient databases using a five-step design method
• Design efficient data-entry and data display forms
• Utilize the improved Access report designer
• Use Visual Basic(r) for Applications and the VBA Editor to automate applications
• Build and customize Access 2007 ribbons
• Seamlessly exchange Access data with SharePoint(r)
• Employ advanced techniques such as the Windows(r) API and object-oriented programming
• Add security and use data replication in your Access applications

What's on the CD-ROM?

Follow the examples in the book chapter by chapter using the bonus materials on the CD-ROM. You'll find separate Microsoft Access database files for each chapter and other working files, including

• All the examples and databases used in the book, including database files, images, data files in various formats, and icon files used in the book's examples
• A complete sample application file, including queries, reports, objects, and modules, that you can use as a reference

See the CD-ROM appendix for details and complete system requirements.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

From the Back Cover

"I recommend this book for anyone who wants a strong foundation in Access."
—Jeff Lenamon, CIBC World Markets

Updated edition with exciting new Access 2007 features!

Harness the power of Access 2007 with the expert guidance in this comprehensive reference. Beginners will appreciate the thorough attention to database fundamentals and terminology. Experienced users can jump right into Access 2007 enhancements like the all-new user interface and wider use of XML and Web services. Each of the book's six parts thoroughly focuses on key elements in a logical sequence, so you have what you need, when you need it. Designed as both a reference and a tutorial, Access 2007 Bible is a powerful tool for developers needing to make the most of the new features in Access 2007.

• Build Access tables using good relational database techniques
• Construct efficient databases using a five-step design method
• Design efficient data-entry and data display forms
• Utilize the improved Access report designer
• Use Visual Basic® for Applications and the VBA Editor to automate applications
• Build and customize Access 2007 ribbons
• Seamlessly exchange Access data with SharePoint®
• Employ advanced techniques such as the Windows® API and object-oriented programming
• Add security and use data replication in your Access applications

What's on the CD-ROM?

Follow the examples in the book chapter by chapter using the bonus materials on the CD-ROM. You'll find separate Microsoft Access database files for each chapter and other working files, including

• All the examples and databases used in the book, including database files, images, data files in various formats, and icon files used in the book's examples
• A complete sample application file, including queries, reports, objects, and modules, that you can use as a reference

See the CD-ROM appendix for details and complete system requirements.

See all Editorial Reviews

Product Details

• Paperback: 1416 pages
• Publisher: Wiley (January 10, 2007)
• Language: English
• ISBN-10: 0470046732
• ISBN-13: 978-0470046739
• Product Dimensions: 9.1 x 7.2 x 2.1 inches
• Shipping Weight: 4.5 pounds (View shipping rates and policies)
• Average Customer Review: 2.7 out of 5 stars  See all reviews (15 customer reviews)
• Amazon.com Sales Rank: #32,309 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

20 of 21 people found the following review helpful:

5.0 out of 5 stars Excellent Reference, February 27, 2007

By	Michael Alexander (Frisco, Texas) - See all my reviews

This is an excellent reference that really accelerated rated my learning of Access 2007. The authors do a very good job explaining general database management techniques and explaining every nook and cranny of the new version of Access. I found lots of useful tips and tricks that I was able to implement immediately.

Beginners will probably find the terminology a bit overwhelming, so for true novices who haven't had any exposure to Access, I'd recommend an entry level book like Access 2007 for Dummies before trying to tackle this book.

Those with some Access experience will get the most benefit out of this book, as it covers the essential topics: Advance queries, UserForms, VBA, ADO, working with SQL servers, and integrating with other office applications.

12 of 12 people found the following review helpful:

3.0 out of 5 stars Mostly accurate but sloppy, May 28, 2007

By	Gail Flowers - See all my reviews (REAL NAME)

The authors clearly understand Access but I suspect they rushed the book to print, given the number of typos, outdated facts, and instances where information is repeated in a disorganized way. Probably fine as a reference for experienced users but not recommended for someone trying to learn.

10 of 11 people found the following review helpful:

1.0 out of 5 stars Summary Review of Access 2007 Books, March 22, 2008

By	Read to live "LLT" (Toronto, ON Canada) - See all my reviews

This is the summary review of four Access 2007 books:
"Special Edition: Using Access 2007" (Special)
"Access 2007 Bible" (Bible)
"The missing Manual of Access 2007" (Manual)
"Access 2007 for dummies" (Dummies)

In sum, the special edition is the best. Buy the special edition. Even you are a fresh beginner on Access.

(My story? Well, I read the dummies first. Then looked at Manual, doesn't like it. So I got the bible. Still unsatisfied. Finally, I got the special edition.)I know some basics on Access 2003 and only use Access when Excel is not enough to handle my data. I started with "Access 2007 for dummies" and finished it in a couple of hours. Then I turned to "Access 2007 Bible" and "The missing Manual", the manual is the worst one and the bible just provides basics, well, maybe a bit more than, that the dummies book already covers.

The special edition provides more examples and detailed explanation on: Query, Forms, Reports, Pivot table.Not sure about the VBA part.

I also like very much the reader-friendly layout and enjoy its "what is in real world" sections at the end of several chapters.

This book also provides a good summary of basic database concepts like normalized, the importance of index, joints. The summary is very helpful especially you are a beginner.

The cover of the special edition claims that the special edition is the only Access book you need. Well, maybe not the only one, but if you have the special edition, you definitely don't need the Access 2007 Bible, The missing manual and the dummies book.