Access - conditional statement

Coming from the excel world, how to I create a conditional statement to populate one field based on the value on the other, something that in excel would look like:

=if(A1="A","Yes","No")

Thank you