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

Buy New

or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Buy Used
Used - Like New See details
$18.60 & eligible for FREE Super Saver Shipping on orders over $25. Details

or
Sign in to turn on 1-Click ordering.
 
   
Kindle Edition
 
   
Sell Back Your Copy
For a $8.40 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Access 2007 Bible
 
 
Start reading Access 2007 Bible on your Kindle in under a minute.

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

Access 2007 Bible [Paperback]

Michael R. Groh (Author), Joseph C. Stockman (Author), Gavin Powell (Author), Cary N. Prague (Author), Michael R. Irwin (Author), Jennifer Reardon (Author)
2.8 out of 5 stars  See all reviews (22 customer reviews)

List Price: $49.99
Price: $30.43 & this item ships for FREE with Super Saver Shipping. Details
You Save: $19.56 (39%)
  Special Offers Available
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
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Only 6 left in stock--order soon (more on the way).
Want it delivered Monday, January 30? Choose One-Day Shipping at checkout. Details
Textbook Student FREE Two-Day Shipping for Students. Learn more

Formats

Amazon Price New from Used from
Kindle Edition $27.39  
Paperback $30.43  
Sell Back Your Copy for $8.40
Whether you buy it used on Amazon for $12.74 or somewhere else, you can sell it back through our Book Trade-In Program at the current price of $8.40.
Used Price$12.74
Trade-in Price$8.40
Price after
Trade-in
$4.34

Book Description

0470046732 978-0470046739 January 10, 2007
"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.


Special Offers and Product Promotions

  • Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)

Frequently Bought Together

Access 2007 Bible + Excel 2007 Bible + Excel 2007 Formulas (Mr. Spreadsheet's Bookshelf)
Price For All Three: $81.41

Show availability and shipping details

Buy the selected items together
  • In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Excel 2007 Bible $24.39

    In Stock.
    Ships from and sold by Amazon.com.
    Eligible for FREE Super Saver Shipping on orders over $25. Details

  • Excel 2007 Formulas (Mr. Spreadsheet's Bookshelf) $26.59

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details



Editorial Reviews

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.

About the Author

Michael R. Groh is a well-known author, writer, and consultant specializing in Windows database systems. His company, PC Productivity Solutions, provides information-management applications to companies across the country. Over the last 25 years, Mike has worked with a wide variety of programming languages, operating systems, and computer hardware, ranging from programming a DEC PDP-8A using the Focal interpreted language to building distributed applications under Visual Studio .NET and Microsoft SharePoint.
Mike was one of the first people outside of Microsoft to see Access in action. He was among a select group of journalists and publishers invited to preview the Access 1.0 beta (then called Cirrus) at the 1992 Windows World Conference in Chicago. Since then, Mike has been involved in every Microsoft Access beta program, as an insider and as a journalist and reporter documenting the evolution of this fascinating product.
Mike has authored parts of more than 20 different computer books and is a frequent contributor to computer magazines and journals. Mike has written more than 200 articles and editorials over the last 15 years, mostly for Advisor Media (San Diego, CA). He frequently speaks at computer conferences virtually everywhere in the world, and is technical editor and contributor to periodicals and publications produced by Advisor Media.
Mike holds a master’s degree in Clinical Chemistry from the University of Iowa (Iowa City, IA) and an MBA from Northeastern University (Boston, MA).
Mike can be reached at AccessBible@mikegroh.com. Please prefix the e-mail subject line with “AccessBible:” to get past the spam blocker on this account.

Joseph C. Stockman is an independent consultant, software designer, and author who has been using Microsoft Access since its initial release. He has also developed courseware and taught classes in Access and VBA. Joe developed his first application in Access, and then migrated into Visual Basic and Visual Basic .NET, where he specializes in creating applications for the Windows Mobile platform. He worked for several software companies before forming his consulting business in 2002, where he deals with all types of clients including healthcare, financial, government, manufacturing, and small business. His ability to turn his customers’ wishes into working applications keeps them satisfied. Joe is also writing the fundamentals column for the Advisor Guide to Microsoft Access magazine.

Gavin Powell is a computer consultant and a writer, with over 20 years of IT experience and over 10 titles to his credit. He has worked as a programmer, analyst, data modeler, database administrator, and Unix administrator. Gavin is also a semiprofessional musician, songwriter, and recording engineer, playing multiple instruments and writing prolifically. Gavin can be reached by e-mail at info@oracledbaexpert.com or ezpowell@ezpowell.com.

Cary N. Prague is an internationally best-selling author and lecturer in the database industry. He owns Database Creations, Inc., the world’s largest Microsoft Access add-on company. Their products include a line of financial software; Business! for Microsoft Office, a mid-range accounting system, POSitively Business! Point of Sale software, the Inventory Barcode manager for mobile data collection, and the Check Writer and General Ledger. Database Creations also produces a line of developer tools including the appBuilder, an application generator for Microsoft Access, the EZ Access Developer Tools for building great user interfaces, appWatcher for maintaining code bases among several developers, and Surgical Strike, the only Patch Manager for Microsoft Access.
Cary also owns Database Creations Consulting, LLC., a successful consulting firm specializing in Microsoft Access and SQL Server applications. Local and national clients include many Fortune 100 companies including manufacturers, defense contractors, insurance, health-care, and software industry companies. His client list includes Microsoft, United Technologies, ABB, Smith & Wesson Firearms, Pratt and Whitney Aircraft, ProHealth, OfficeMax, Continental Airlines, and other Fortune 500 companies.
Formerly, he has held numerous management positions in corporate information systems, including Director of Managed Care Reporting for MetraHealth, Director of Corporate Finance and Software Productivity at Travelers Insurance where he was responsible for software support for 35,000 end users, and Manager of Information Systems support for Northeast Utilities.
He is one of the top best-selling authors in the computer database management market, having written over 40 books that have sold over one million copies on software including Microsoft Access, Borland (Ashton-Tate) dBASE, Paradox, R:Base, Framework, and graphics. Cary’s books include 11 books in the Access Bible series (recently number one on the Ingram Bestselling Database Titles list and in the Amazon.com top 100), Access 97 Secrets, dBASE for Windows Handbook, dBASE IV Programming (winner of the Computer Press Association’s Book of the Year award for Best Software Specific Book), and Everyman’s Database Primer Featuring dBASE IV. He recently completed several books for Access 2003 including Weekend Crash Course in Office Access 2003 Programming. Cary recently sold a product line named eTools for Microsoft Access to MightyWords, a division of FatBrain.com and Barnes and Noble.
Cary is certified in Access as a Microsoft Certified Professional and has passed the MOUS test in Access and Word. He is a frequent speaker at seminars and conferences around the country. He is on the exclusive Microsoft Access Insider Advisory Board and makes frequent trips to Microsoft headquarters in Redmond, WA. He has been voted the best speaker by the attendees of several national conferences. Recently, he was a speaker for Microsoft sponsored conferences in New Orleans, Hawaii, Phoenix, Chicago, Toronto, Palm Springs, Boston, and Orlando. He has also spoken at Borland’s Database Conference, Digital Consulting’s Database World, Microsoft’s Developer Days, Computerland’s Technomics Conference, COMDEX, and COMPAQ Computer’s Innovate. He was a contributing editor to Access Advisor magazine and has written for the Microsoft Office Developer’s journal.
He is active in local town politics serving on the South Windsor, Connecticut Board of Education, Parks and Recreation Commission, and the Board of Assessment Appeals.
Cary holds a master’s degree in computer science from Rensselaer Polytechnic Institute, and an M.B.A and Bachelor of Accounting from the University of Connecticut. He is also a Certified Data Processor.

Michael R. Irwin is considered one of the leading authorities on automated database and Internet management systems today. He is a noted worldwide lecturer, a winner of national and international awards, best-selling author, and developer of client/server, Internet, Intranet, and PC-based database management systems.
Michael has extensive database knowledge, gained by working with the Metropolitan Police Department in Washington, D.C. as a developer and analyst for the Information Systems Division for over 20 years and assorted Federal Agencies of the United States Government. Since retiring in June 1992, he runs his own consulting firm, named The Irwin Group, and is principal partner in the company - IT in Asia, LLC, specializing in Internet database integration and emphasizing Client/Server and net solutions. With consulting offices in Cincinnati, Ohio, Bangkok, Thailand, and Manila, Philippines, his companies offer training and development of Internet and database applications. His company has the distinction of being one of the first Microsoft Solution’s Providers (in 1992). His local, national, and international clients include many software companies, manufacturers, government agencies, and international companies.
His range of expertise includes database processing and integration between mainframe, minicomputer, and PC-based database systems, as well as B-2-B and B-2-C integration between back-end databases; he is a leading authority on PC-based databases.
He is one of the top best-selling authors in the computer database management market, having authored numerous database books, with several of them consistently on the best-sellers lists. His books, combined, have sold nearly a million copies worldwide. His most recent works include The OOPs Primer (Borland Press), dBASE 5.5 for Windows Programming (Prentice Hall), Microsoft Access 2002 Bible, Microsoft Access 2002 Bible Gold Edition (co-authored), and Working with the Internet. The Access Bible series have constantly been number one on the Ingram Best-selling Database Titles list and is consistently in the Amazon.com and Buy.com top 10. He has also written several books on customs and cultures of the countries of Asia (including China, Japan, Thailand, and India). Two of his books have won international acclaim. His books are published in over 24 languages worldwide. He has been a contributing editor and author to many well-known magazines and journals.
He is a frequent speaker at seminars and conferences around the world and has been voted the best speaker by the attendees of several international conferences. Michael has developed and markets several add-on software products for the Internet and productivity related applications. Many of his productivity applications can be obtained from several of his Internet sites or on many common download sites. Many of his application and systems are distributed as freeware and careware. He has also developed and distributes several development tools and add-ins for a wide range of developer applications.

Jennifer Reardon is considered a leading developer of custom database applications. She has over ten years’ experience developing client/server and PC-based applications. She has accumulated much of he...


Product Details

  • Paperback: 1416 pages
  • Publisher: Wiley (January 10, 2007)
  • Language: English
  • ISBN-10: 0470046732
  • ISBN-13: 978-0470046739
  • Product Dimensions: 9.2 x 7.4 x 2 inches
  • Shipping Weight: 4.5 pounds (View shipping rates and policies)
  • Average Customer Review: 2.8 out of 5 stars  See all reviews (22 customer reviews)
  • Amazon Best Sellers Rank: #68,598 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

 

Customer Reviews

22 Reviews
5 star:
 (6)
4 star:
 (2)
3 star:
 (3)
2 star:
 (3)
1 star:
 (8)
 
 
 
 
 
Average Customer Review
2.8 out of 5 stars (22 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

23 of 24 people found the following review helpful:
5.0 out of 5 stars Excellent Reference, February 27, 2007
This review is from: Access 2007 Bible (Paperback)
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


10 of 10 people found the following review helpful:
1.0 out of 5 stars A Waste of Time, April 2, 2008
By 
This review is from: Access 2007 Bible (Paperback)
I have used books such as this to teach myself how to use much more complicated software (such as Visual C++ 6) with great success to the point of selling my own software developed with Visual C++. I have dabbled in earlier versions of Access and bought this book to upgrade my skills and get productive quickly with Access 2007. Not a hope! The book is poorly proof read and has many errors. Old versions of text rewritten, presumably to improve clarity, are left in place, thus adding to confusion. The book is just poorly and carelessly written making learning very difficult for someone struggling to understand new concepts. The examples on the CD don't always match the text, don't always work and often add to the difficulty of understanding.

This one goes into the recycling!
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


13 of 14 people found the following review helpful:
3.0 out of 5 stars Mostly accurate but sloppy, May 28, 2007
This review is from: Access 2007 Bible (Paperback)
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews











Only search this product's reviews



Inside This Book (learn more)
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
design view, datasheet view, field list, navigation pane, property sheet, layout view, enterprise platform, page footer, automation server, report design, project properties, report header, split form, tab order, macro name, control layout, macro recorder, refresh interval, regular cab, query name, navigation options, import errors, blank database, cascade delete, replication options
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Microsoft Access, Access Auto Auctions, Access Building Blocks, More Advanced Access Techniques, Services Web, Print Preview, Visual Basic, Microsoft Office, Database Tools, Form View, External Data, Declare Function, Integrating Access, Page Header, Presenting Data, End Function, Private Sub, Social Security, Access Options, Object-Oriented Programming, Upsizing Wizard, Exit Function, Close Set, Using the Windows, Northwind Traders
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Search Inside This Book:

What Other Items Do Customers Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 

Your tags: Add your first tag
 

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums



So You'd Like to...



Look for Similar Items by Category


Look for Similar Items by Subject