List four advantages of using VBA rather than macros in Access.

What will be an ideal response?


Student answers will vary but should include four of the advantages listed here.
1. VBA offers better error-handling features.
2. VBA provides easier updating capabilities.
3. Users can create a specific set of statements to perform special calculations which cannot be accomplished with macros.
4. VBA has the ability to verify field values based on the value of another field or set of fields.
5. VBA may also dynamically change the color of a form control when a user enters or views a specific field value.

Computer Science & Information Technology

You might also like to view...

Input __________ is commonly done with a loop that iterates as long as an input variable contains bad data.

a. check b. validation c. examination d. priming

Computer Science & Information Technology

The ____ attribute of the

tag represents the older standard for identifying each form on the page.

A. id B. identification C. name D. what

Computer Science & Information Technology

The data type of the variable is listed after a comma character.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Data flow diagrams can be used for several different purposes.

What will be an ideal response?

Computer Science & Information Technology