Adding A Data Macro To Automatically Fill in a Field

In the following table, I have used a Access 2010 data macro to fill in field. In this case I wanted the PassFail field to equal "Pass" only if all three questions were answered yes as in picture 1

If any of the question fields were No, then it would be a fail as below

I did this with the following data macro

So now how did I learn how to do this, I watched this video from Microsoft