Sorting and filtering are two ways to blank data

a macro is a tool that allows you to automate tasks and add functionality to your forms, reports, and controls. for example, if you add a command button to a form, you associate the button's onclick event to a macro, and the macro contains the commands that you want the button to perform each time it is clicked.

answer; certification; plz check first, i believe this is correct. good luck;