Access® 2010 Bible

Part IV. Professional Database Development

IN THIS PART

• Chapter 24

  Optimizing Access Applications

• Chapter 25

  Advanced Data Access with VBA

• Chapter 26

  Bulletproofing Access Applications

• Chapter 27

  Using the Windows Application Programming Interface

• Chapter 28

  Object-Oriented Programming with VBA

• Chapter 29

  Customizing Access Ribbons

• Chapter 30

  Using Access Macros

• Chapter 31

  Distributing Access Applications

The chapters in this part cover issues that concern professional database developers, including "bulletproofing" Access databases, enhancing the user interface with toolbars and menus, and using some advanced programming techniques such as the Windows Application Programming Interface (API).

This part builds on the information provided in earlier chapters. In this part, you'll find answers to many questions and problems facing Access developers, such as identifying a user as the user logs on to an application, exploiting object-oriented programming with the VBA language, and using advanced data-management techniques with ActiveX Data Objects (ADOs).

Some developers will never use many of the capabilities described in this part. However, far too often, even advanced developers overlook the capabilities provided by a system like Microsoft Access simply because they're too busy or too involved in other work to truly learn what Access is capable of. This part takes you on a tour of some of the high-end features provided by Microsoft Access so that you'll know they're there, and you'll have a blueprint ...