Which item is an Access object specifically used to store macros and VBA code?

Which item is an Access object specifically used to store macros and VBA code?

• A. Tables
• B. Modules (Macros and VBA's)
• C. Forms
• D. Reports

Answer: (B)

Storing code and automation logic in an Access database is done in modules. A module is the container where you place VBA code—subroutines and functions—that perform actions, enforce logic, and support the behavior of forms, reports, and queries. While macros exist as their own objects to automate actions, the VBA code you write lives in modules, making them the primary repository for storing and organizing code that powers the application. Tables hold the data, and forms or reports are the user interface and output elements; they can trigger code, but they aren’t the places where you store the actual code logic.

Storing code and automation logic in an Access database is done in modules. A module is the container where you place VBA code—subroutines and functions—that perform actions, enforce logic, and support the behavior of forms, reports, and queries. While macros exist as their own objects to automate actions, the VBA code you write lives in modules, making them the primary repository for storing and organizing code that powers the application. Tables hold the data, and forms or reports are the user interface and output elements; they can trigger code, but they aren’t the places where you store the actual code logic.