Skip to content
Sign in
Artwork for Computer Learning Zone
Computer Learning Zone · Today · 4 min

Microsoft Access VBA Quiz: Private Procedures and Control Flow

Test your Microsoft Access VBA knowledge with five quick questions about private procedures, procedure parameters, Select Case statements, ElseIf chains, and operation-specific validation. Learn why a Private Sub stays local to its form module, how arguments such as "Add" are passed into a procedure, and why Select Case can make a calculator-style routine easier to read and maintain. The quiz also covers a common control-flow detail: ElseIf stops checking later conditions after a match, while separate If statements continue evaluating. Plus, see why divide-by-zero validation belongs inside the division case, right before the calculation happens.

0:00-4:20
Play in

transcript

No transcript — this publisher did not publish one.

show notes

Test your Microsoft Access VBA knowledge with five quick questions about private procedures, procedure parameters, Select Case statements, ElseIf chains, and operation-specific validation.


Learn why a Private Sub stays local to its form module, how arguments such as "Add" are passed into a procedure, and why Select Case can make a calculator-style routine easier to read and maintain.


The quiz also covers a common control-flow detail: ElseIf stops checking later conditions after a match, while separate If statements continue evaluating. Plus, see why divide-by-zero validation belongs inside the division case, right before the calculation happens.

more episodes

All episodes