Asked by Brooke Candia on Jun 08, 2024
Verified
Why would you create a function in a standard module?
A) To embed the function in the open form
B) To use the function in any query, form, or report in the database
C) To prepare for converting the function to a macro
D) To avoid having to use VBA syntax
Standard Module
In programming, a module containing a collection of functions, subroutines, or declarations without instantiating them.
- Comprehend the procedure for backing up data and constructing functions within modules.
- Learn to identify and deploy VBA keywords, and fathom the significance of programming driven by events.
Verified Answer
MB
Maddie BairdJun 13, 2024
Final Answer :
B
Explanation :
Creating a function in a standard module allows it to be used in any query, form, or report in the database, providing flexibility and reusability of code.
Learning Objectives
- Comprehend the procedure for backing up data and constructing functions within modules.
- Learn to identify and deploy VBA keywords, and fathom the significance of programming driven by events.