Business Solutions VBA for the 2007 Microsoft Office System

10Programming Access Databases

IN THIS CHAPTER

Getting Ready: Two Steps Before You Begin

Working with Database Records: Opening a Recordset

Working with a Recordset

Retrieving Data into Excel

In the past few chapters you’ve learned about the objects, properties, and methods associated with Word, Excel, and PowerPoint. You’ve seen that it’s possible to manipulate these objects to automate routine tasks and gain an unprecedented amount of control over these programs.

In this chapter, you’ll see that using VBA with Access is quite a bit different because you won’t learn anything about Access objects. Yes, Access does have an Application object and there’s a whole hierarchy of objects for things such as forms and reports. However, it’s a ...