Name three reasons you must use a module rather than a macro.
What will be an ideal response?
1. Class modules are stored as part of the form or report in which they are created. If you copy the form or report, the module is contained within the object.
2. You must use modules to create unique function procedures.
3. Modules can contain procedures to mask error messages.
4. VBA works with other products in the Microsoft Office suite.
5. VBA code can contain nested If statements, Case statements, and other powerful programming code.
6. VBA can be used in conjunction with SQL to select, update, append, and delete data.
You might also like to view...
COGNITIVE ASSESSMENT What is the role of an address when used in the context of computer memory?
A. It determines the amount of data a computer can process over a given period of time. B. It automatically registers each byte that is stored in memory. C. It determines whether the data stored in memory is represented as ASCII or as 8-bit and then indicates to the processor the type of processing that is allowed for the data. D. It identifies the location of a byte in memory.
You can delete a table that is no longer needed by using the ____________________ TABLE command.
Fill in the blank(s) with the appropriate word(s).
By using ____, you can use reasonable, easy-to-remember names for methods and concentrate on their purpose rather than on memorizing different method names.
A. inheritance B. inference C. polymorphism D. relationships
When you move the mouse pointer over the formula bar, the mouse pointer changes to a(n) ____.
A. one-sided arrow B. double-sided arrow C. white plus sign D. I-beam