10. Programming Access Databases

In This Chapter

• Learning about database programming

• Getting your projects and system set up to program databases

• Opening data in a recordset

Accessing recordset data

Navigating, finding, editing, adding, and deleting records

• Retrieving data into an Excel worksheet

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

Get Absolute Beginner's Guide to VBA 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.