Skip to main content


Access 2010 Bible

Michael R. Groh

ISBN: 978-0-470-47534-8 May 2010 1392 Pages


The expert guidance you need to get the most out of Access 2010

Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology. If you're familiar with earlier versions, you can jump right into Access 2010 enhancements such as the new Access user interface and wider use of XML and Web services.

  • Takes you under the hood of Microsoft Access 2010, the database application included with Microsoft Office 2010
  • Explores the latest enhancements, such as a new user interface and wider use of XML and Web services; also, how to exchange data with Word, Excel, PowerPoint, and other Office apps
  • Covers how to create tables, manipulate datasheets, and work with multiple tables
  • Explains the seven database objects and how to use a seven-step design method to build a database tailored to your needs
  • Shows you how to build forms, use Visual Basic and the VBA Editor, automate query parameters, create functions and subroutines, use XML to create data access pages, and more
  • Includes a CD with all source code from the book and working examples, plus bonus shareware, freeware, trial, demo and evaluation programs that work with or enhance Microsoft Office

You’ll want to keep this soup-to-nuts Access reference close at hand!

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

Buy Set of 4 Items

This item: Access 2010 Bible

PowerPoint 2010 Bible

(Paperback $39.99)

Word 2010 Bible

(Paperback $39.99)

Excel 2010 Bible

(Paperback $44.99)

Original Price:$174.96

Purchased Together:$149.99

save $24.97

Acknowledgments xxxiii

Introduction xxxv

Part I: Access Building Blocks 1

Chapter 1: An Introduction to Database Development 3

Chapter 2: Creating Access Tables 25

Chapter 3: Designing Bulletproof Databases 91

Chapter 4: Selecting Data with Queries 129

Chapter 5: Using Operators and Expressions in Access 171

Chapter 6: Working with Datasheet View 215

Chapter 7: Creating Basic Access Forms 251

Chapter 8: Working with Data on Access Forms 289

Chapter 9: Presenting Data with Access Reports 319

Part II: Programming Microsoft Access 375

Chapter 10: VBA Programming Fundamentals 377

Chapter 11: Mastering VBA Data Types and Procedures 417

Chapter 12: The Access Event Model 451

Chapter 13: Accessing Data with VBA Code 473

Chapter 14: Debugging Your Access Applications 523

Chapter 15: Using Access Data Macros 551

Part III: More-Advanced Access Techniques 577

Chapter 16: Working with External Data 579

Chapter 17: Importing and Exporting Data 609

Chapter 18: Advanced Access Query Techniques 637

Chapter 19: Advanced Access Form Techniques 679

Chapter 20: Advanced Access Report Techniques 709

Chapter 21: Building Multiuser Applications 751

Chapter 22: Integrating Access with Other Applications 789

Chapter 23: Handling Errors and Exceptions 819

Part IV: Professional Database Development 839

Chapter 24: Optimizing Access Applications 841

Chapter 25: Advanced Data Access with VBA 881

Chapter 26: Bulletproofing Access Applications 897

Chapter 27: Using the Windows Application Programming Interface 939

Chapter 28: Object-Oriented Programming with VBA 969

Chapter 29: Customizing Access Ribbons 1009

Chapter 30: Using Access Macros 1049

Chapter 31: Distributing Access Applications 1083

Part V: Access and Windows SharePoint Services 1101

Chapter 32: Understanding Windows SharePoint Services 1103

Chapter 33: Integrating Access with SharePoint 1117

Chapter 34: Understanding Access Services 1135

Chapter 35: Deploying Access Applications to SharePoint 1145

Part VI: Access as an Enterprise Platform 1181

Chapter 36: Client/Server Concepts 1183

Chapter 37: SQL Server as an Access Companion 1199

Chapter 38: Upsizing Access Databases to SQL Server 1223

Part VII: Appendixes 1243

Appendix A: Access 2010 Specifications 1245

Appendix B: What’s New in Access 2010 1253

Appendix C: What’s on the CD-ROM 1267

Index 1271

ChapterPageDetailsDatePrint Run
3Errata in text
When in Design View for a Table, you will notice a data type selection called Calculated. This data type was introduced with the release of Access 2010. With Calculated type fields, you can build mathematical operations, textual evaluations, or any other calculation directly into your table.

This data type is widely considered to be a horrible addition to the available data types in Access Tables.

Tables, by their very nature, are designed to store raw data. The job of performing calculations is traditionally left to Queries or VBA code. This allows for the separation of the data layer and analysis layer. This separation data and analysis is one of the strengths of Access. It allows for transparency and confidence in data integrity. When you look at the data in an Access Table, you can be sure that the it is in it's purest, most raw form.

The introduction of the Calculated data type completely goes against this paradigm. With a Calculated field, you are locking in a calculation that could be wrong, that could be changed over time, or that could cause errors in later analysis.

We highly recommend you stay away from Calculated fields.