A student creates a VBA script in MS Access attached to the On Click event of a button. The script iterates through all records i…

Question

A student creates a VBA script in MS Access attached to the On Click event of a button. The script iterates through all records in the Students table. What does the script do?

1. A. It filters and displays only students who scored below 40 marks in the form
2. B. It automatically updates every record in the student table. (Correct answer)
3. C. It deletes all records of students who scored below 40 marks
4. D. It creates a new table that stores the result (Pass/Fail) separately

Correct Answer

Option B — It automatically updates every record in the student table.

Detailed Solution & Explanation

The correct answer is It automatically updates every record in the student table..

Key Points

• The VBA script iterates through all records and applies an update operation - it automatically updates every record in the Students table.