Access 2007 Bible

( 8 )


Thorough beginning-to-advanced coverage has made this the book users and developers need to succeed with this leading database system Revised and updated to cover the substantial changes to Access 2007, including the dramatically different interface and easier interactivity with Excel Shows database novices and pros alike how to store, organize, view, analyze, and share data through custom database solutions that interact with Web and enterprise data sources Includes a valuable CD-ROM with examples and databases ...

See more details below
Paperback (BK&CD-ROM)
$37.15 price
(Save 25%)$49.99 List Price
Other sellers (Paperback)
  • All (28) from $1.99   
  • New (7) from $25.88   
  • Used (21) from $1.99   


Thorough beginning-to-advanced coverage has made this the book users and developers need to succeed with this leading database system Revised and updated to cover the substantial changes to Access 2007, including the dramatically different interface and easier interactivity with Excel Shows database novices and pros alike how to store, organize, view, analyze, and share data through custom database solutions that interact with Web and enterprise data sources Includes a valuable CD-ROM with examples and databases from the book as well as trial software

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
Making the most of Access 2007 means mastering its built-in features, extending them programmatically, and integrating your databases with your broader environment. Access 2007 Bible covers all that and more. You could start as a beginner, grow into an enterprise developer, and still find great value here.

The authors teach everything through an extensive example application that links theory and technique with business problem solving. Using it, you learn all the basics in nine chapters: from designing databases to navigating Access 2007's revamped interface to creating reports.

The authors next turn to VBA, linking concepts to useful techniques such as creating functions to calculate taxes. There's an up-to-the-minute section on integration, from basic data import/export to leveraging SharePoint team sites. You'll find practical insight into database optimization, bulletproofing, security, distribution, even using Access alongside SQL Server. This isn't just a tour of Access: It's a tour de force. Bill Camarda, from the February 2007 Read Only

Read More Show Less

Product Details

  • ISBN-13: 9780470046739
  • Publisher: Wiley
  • Publication date: 1/3/2007
  • Series: Bible Series, #361
  • Edition description: BK&CD-ROM
  • Edition number: 1
  • Pages: 1416
  • Sales rank: 1,445,922
  • Product dimensions: 7.30 (w) x 9.20 (h) x 2.00 (d)

Meet the Author

Michael R. Groh is a well-known author, writer, andconsultant specializing in Windows database systems. His company,PC Productivity Solutions, provides information-managementapplications to companies across the country. Over the last 25years, Mike has worked with a wide variety of programminglanguages, operating systems, and computer hardware, ranging fromprogramming a DEC PDP-8A using the Focal interpreted language tobuilding distributed applications under Visual Studio .NET andMicrosoft SharePoint.
Mike was one of the first people outside of Microsoft to see Accessin action. He was among a select group of journalists andpublishers invited to preview the Access 1.0 beta (then calledCirrus) at the 1992 Windows World Conference in Chicago. Sincethen, Mike has been involved in every Microsoft Access betaprogram, as an insider and as a journalist and reporter documentingthe evolution of this fascinating product.
Mike has authored parts of more than 20 different computer booksand is a frequent contributor to computer magazines and journals.Mike has written more than 200 articles and editorials over thelast 15 years, mostly for Advisor Media (San Diego, CA). Hefrequently speaks at computer conferences virtually everywhere inthe world, and is technical editor and contributor to periodicalsand publications produced by Advisor Media.
Mike holds a master’s degree in Clinical Chemistry from theUniversity of Iowa (Iowa City, IA) and an MBA from NortheasternUniversity (Boston, MA).
Mike can be reached at Please prefix thee-mail subject line with “AccessBible:” to get past thespam blocker on this account.

Joseph C. Stockman is an independent consultant, softwaredesigner, and author who has been using Microsoft Access since itsinitial release. He has also developed courseware and taughtclasses in Access and VBA. Joe developed his first application inAccess, and then migrated into Visual Basic and Visual Basic .NET,where he specializes in creating applications for the WindowsMobile platform. He worked for several software companies beforeforming his consulting business in 2002, where he deals with alltypes of clients including healthcare, financial, government,manufacturing, and small business. His ability to turn hiscustomers’ wishes into working applications keeps themsatisfied. Joe is also writing the fundamentals column for theAdvisor Guide to Microsoft Access magazine.

Gavin Powell is a computer consultant and a writer, withover 20 years of IT experience and over 10 titles to his credit. Hehas worked as a programmer, analyst, data modeler, databaseadministrator, and Unix administrator. Gavin is also asemiprofessional musician, songwriter, and recording engineer,playing multiple instruments and writing prolifically. Gavin can bereached by e-mail at

Cary N. Prague is an internationally best-selling authorand 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! forMicrosoft Office, a mid-range accounting system, POSitivelyBusiness! Point of Sale software, the Inventory Barcode manager formobile data collection, and the Check Writer and General Ledger.Database Creations also produces a line of developer toolsincluding the appBuilder, an application generator for MicrosoftAccess, the EZ Access Developer Tools for building great userinterfaces, appWatcher for maintaining code bases among severaldevelopers, and Surgical Strike, the only Patch Manager forMicrosoft Access.
Cary also owns Database Creations Consulting, LLC., a successfulconsulting firm specializing in Microsoft Access and SQL Serverapplications. Local and national clients include many Fortune 100companies including manufacturers, defense contractors, insurance,health-care, and software industry companies. His client listincludes Microsoft, United Technologies, ABB, Smith & WessonFirearms, Pratt and Whitney Aircraft, ProHealth, OfficeMax,Continental Airlines, and other Fortune 500 companies.
Formerly, he has held numerous management positions in corporateinformation systems, including Director of Managed Care Reportingfor MetraHealth, Director of Corporate Finance and SoftwareProductivity at Travelers Insurance where he was responsible forsoftware support for 35,000 end users, and Manager of InformationSystems support for Northeast Utilities.
He is one of the top best-selling authors in the computer databasemanagement market, having written over 40 books that have sold overone 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 Bibleseries (recently number one on the Ingram Bestselling DatabaseTitles list and in the top 100), Access 97Secrets, dBASE for Windows Handbook, dBASE IVProgramming (winner of the Computer Press Association’sBook of the Year award for Best Software Specific Book), andEveryman’s Database Primer Featuring dBASE IV. Herecently completed several books for Access 2003 includingWeekend Crash Course in Office Access 2003 Programming. Caryrecently sold a product line named eTools for Microsoft Access toMightyWords, a division of and Barnes and Noble.
Cary is certified in Access as a Microsoft Certified Professionaland has passed the MOUS test in Access and Word. He is a frequentspeaker at seminars and conferences around the country. He is onthe exclusive Microsoft Access Insider Advisory Board and makesfrequent trips to Microsoft headquarters in Redmond, WA. He hasbeen voted the best speaker by the attendees of several nationalconferences. Recently, he was a speaker for Microsoft sponsoredconferences in New Orleans, Hawaii, Phoenix, Chicago, Toronto, PalmSprings, Boston, and Orlando. He has also spoken at Borland’sDatabase Conference, Digital Consulting’s Database World,Microsoft’s Developer Days, Computerland’s TechnomicsConference, COMDEX, and COMPAQ Computer’s Innovate. He was acontributing editor to Access Advisor magazine and haswritten for the Microsoft Office Developer’sjournal.
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 fromRensselaer Polytechnic Institute, and an M.B.A and Bachelor ofAccounting from the University of Connecticut. He is also aCertified Data Processor.

Michael R. Irwin is considered one of the leadingauthorities on automated database and Internet management systemstoday. He is a noted worldwide lecturer, a winner of national andinternational awards, best-selling author, and developer ofclient/server, Internet, Intranet, and PC-based database managementsystems.
Michael has extensive database knowledge, gained by working withthe Metropolitan Police Department in Washington, D.C. as adeveloper and analyst for the Information Systems Division for over20 years and assorted Federal Agencies of the United StatesGovernment. Since retiring in June 1992, he runs his own consultingfirm, named The Irwin Group, and is principal partner in thecompany - IT in Asia, LLC, specializing in Internet databaseintegration and emphasizing Client/Server and net solutions. Withconsulting offices in Cincinnati, Ohio, Bangkok, Thailand, andManila, Philippines, his companies offer training and developmentof Internet and database applications. His company has thedistinction of being one of the first Microsoft Solution’sProviders (in 1992). His local, national, and international clientsinclude many software companies, manufacturers, governmentagencies, and international companies.
His range of expertise includes database processing and integrationbetween mainframe, minicomputer, and PC-based database systems, aswell as B-2-B and B-2-C integration between back-end databases; heis a leading authority on PC-based databases.
He is one of the top best-selling authors in the computer databasemanagement market, having authored numerous database books, withseveral of them consistently on the best-sellers lists. His books,combined, have sold nearly a million copies worldwide. His mostrecent works include The OOPs Primer (Borland Press),dBASE 5.5 for Windows Programming (Prentice Hall),Microsoft Access 2002 Bible, Microsoft Access 2002 BibleGold Edition (co-authored), and Working with theInternet. The Access Bible series have constantly beennumber one on the Ingram Best-selling Database Titles list and isconsistently in the and top 10. He has alsowritten several books on customs and cultures of the countries ofAsia (including China, Japan, Thailand, and India). Two of hisbooks have won international acclaim. His books are published inover 24 languages worldwide. He has been a contributing editor andauthor to many well-known magazines and journals.
He is a frequent speaker at seminars and conferences around theworld and has been voted the best speaker by the attendees ofseveral international conferences. Michael has developed andmarkets several add-on software products for the Internet andproductivity related applications. Many of his productivityapplications can be obtained from several of his Internet sites oron many common download sites. Many of his application and systemsare distributed as freeware and careware. He has also developed anddistributes several development tools and add-ins for a wide rangeof developer applications.

Jennifer Reardon is considered a leading developer ofcustom database applications. She has over ten years’experience developing client/server and PC-based applications. Shehas accumulated much of her application development experienceworking as lead developer for Database Creations. She has partneredwith Cary Prague developing applications for many Fortune 500companies.
Her most significant projects include a spare parts inventorycontrol system for Pratt & Whitney’s F22 program, anengineering specifications system for ABB-Combustion Engineering,and an emergency event tracking system for the State ofConnecticut. She was also the lead developer of many of theDatabase Creations add-on software products including Business,Yes! I Can Run My Business, Check Writer, and the User InterfaceConstruction Kit.
She has co-authored Access 2003 Bible, Access 2002Bible, and Access 2000 Weekend Crash Course. She hasalso written chapters in other books on subjects including DataAccess Pages, the Microsoft Database Engine, the VBA programmingenvironment, creating help systems, and using Microsoft Office 2000Developer. She has authored chapters in Microsoft Access 97Bible and Access 97 Secrets.
Jennifer owns her own consulting firm, Advanced Software Concepts,providing custom applications to both the public and privatesectors. She specializes in developing client information systemsfor state-managed and privately-held healthcare organizations. Shehas also developed a job costing and project management system foran international construction company. Her corporate experienceincludes seven years with The Travelers where she was an AssociateSoftware Engineer serving on numerous mission-criticalclient/server software development projects using Easel, C, SQLServer, and DB2. She has contributed several chapters for books ondBase and Microsoft Access.
Jennifer holds a Bachelor of Science degree from the University ofMassachusetts.

Read More Show Less

Table of Contents



Part I: Access Building Blocks.

Chapter 1: An Introduction to Database Development.

Chapter 2: Creating Access Tables.

Chapter 3: Designing Bulletproof Databases.

Chapter 4: Selecting Data with Queries.

Chapter 5: Using Operators and Expressions in Access.

Chapter 6: Working with Datasheet View.

Chapter 7: Creating Basic Access Forms.

Chapter 8: Working with Data on Access Forms.

Chapter 9: Presenting Data with Access Reports.

Part II: Programming Microsoft Access.

Chapter 10: VBA Programming Fundamentals.

Chapter 11: Mastering VBA Data Types and Procedures.

Chapter 12: Understanding the Access Event Model.

Chapter 13: Using Expressions in Queries and VBA Code.

Chapter 14: Accessing Data with VBA Code.

Chapter 15: Using the VBA Debugging Tools.

Part III: More Advanced Access Techniques.

Chapter 16: Working with External Data.

Chapter 17: Importing and Exporting Data.

Chapter 18: Advanced Access Query Techniques.

Chapter 19: Advanced Access Form Techniques.

Chapter 20: Advanced Access Report Techniques.

Chapter 21: Building Multiuser Applications.

Chapter 22: Integrating Access with Other Applications.

Chapter 23: Integrating Access with SharePoint.

Chapter 24: Using ActiveX Controls.

Chapter 25: Handling Errors and Exceptions.

Part IV: Professional Database Development.

Chapter 26: Optimizing Access Applications.

Chapter 27: Advanced Data Access with VBA.

Chapter 28: Bulletproofing Access Applications.

Chapter 29: Securing Access Applications.

Chapter 30: Using the Windows API.

Chapter 31: Using the Access Replication Features.

Chapter 32: Object-Oriented Programming with VBA.

Chapter 33: Reusing VBA Code with Libraries.

Chapter 34: Customizing Access Ribbons.

Chapter 35: Distributing Access Applications.

Chapter 36: Using Access Macros.

Part V: Access as an Enterprise Platform.

Chapter 37: Using XML in Access 2007.

Chapter 38: SharePoint as a Data Source.

Chapter 39: Client/Server Concepts.

Chapter 40: SQL Server as an Access Companion.

Chapter 41: Upsizing Access Databases to SQL Server.

Part VI: Appendixes.

Appendix A: Access 2007 Specifications.

Appendix B: What’s on the CD-ROM.

Appendix C: What’s New in Access 2007.


Wiley Publishing, Inc. End-User License Agreement.

Read More Show Less

Customer Reviews

Average Rating 2.5
( 8 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 8 Customer Reviews
  • Anonymous

    Posted March 30, 2009

    How can I make Access work for me?

    Good book to look up questions about how to format reports, build sub-reports, and other questions that stump you when you are working with Access. This is not a book I would use if I was a first-time Access user, but it is a good reference when you encounter problems.

    3 out of 3 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted October 6, 2007

    Access 2007 Bible

    This book was disappointing. Most of the code samples are poorly written and full of errors. If the code examples worked I would rate this book higher, but only for a beginner. The book only scratched the surface and leaves you wanting for more information to complete a project.

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 10, 2010

    Wish I Could Return It

    I haven't done any Access development work in about 5 years and now am faced with having to build a fairly robust database application. I picked this book up thinking it would help me make the transition from the earlier version of Access I'm familiar with and to refresh my skills. What a huge mistake I made in buying this book. The CD doesn't match the book and there is no way to download a corrected set of examples. The book jumps back and forth between the database used on the CD (Access Auto Traders) and old MS Trade Wind database. Examples in the book do not match those on the CD. The printing is very small and and faint and difficult to read. I do not doubt the knowledge, skills, and research of the authors but this book appears to have been hastily written, not properly proofread, and certainly not tested on real readers. I've now made it through the first 5 chapters and am throwing it in the recycle bin and purchasing a different book. I only wish I had read reviews on this site and others before wasting my hard earned money. I won't make that mistake again.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted July 16, 2010

    No text was provided for this review.

  • Anonymous

    Posted April 21, 2010

    No text was provided for this review.

  • Anonymous

    Posted June 22, 2009

    No text was provided for this review.

  • Anonymous

    Posted August 16, 2010

    No text was provided for this review.

  • Anonymous

    Posted April 18, 2010

    No text was provided for this review.

Sort by: Showing all of 8 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)