Access 2019 Bible

Part VIMicrosoft Access Programming Fundamentals

Part VI introduces macro programming and explains the art and science of Visual Basic for Applications (VBA).

Long maligned as weaker or inferior to VBA, macros were often relegated to second‐class citizenship in many Access developer toolkits. However, as you'll read later in this chapter, Microsoft introduced embedded macros, an efficient technique for automating many tasks in forms and reports. Chapter 23 takes a look at data macros, which enable you to perform important data‐management tasks at the table level.

Starting with Chapter 24, Part VI turns your attention to automation with VBA. VBA provides functionality that goes far beyond simply opening forms and reports and controlling the user interface.

IN THIS PART

• Chapter 22 Using Access Macros
• Chapter 23 Using Access Data Macros
• Chapter 24 Getting Started with Access VBA
• Chapter 25 Mastering VBA Data Types and Procedures
• Chapter 26 Understanding the Access Event Model
• Chapter 27 Debugging Your Access Applications