Chapter 19. Extending Access Using VBA

In the past few days, you’ve learned the basics of programming within Access. Today you’ll learn how to put that knowledge to use with ActiveX Data Objects and Command Bars. Then we’ll finish the subject of programming Access with a catch-all section of other considerations.

Today You Will Learn

In this lesson, you will learn how to extend Access 2002 using ActiveX Data Objects and how to make your database easier for others to use. Specifically you will learn

  • What the ActiveX Data Objects (ADO) are

  • How to use ADO within your database

  • How to use command bars and menus

  • How to develop with multiple developers

  • How to hide the Database window

  • How to distribute your database

ActiveX Data Objects (ADO)

Microsoft has a long ...

Get Sams Teach Yourself Microsoft Access 2002 in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.