OK, so now we're going to have an exercise for the if statement. So we're going to use the ratings table on the right to write a macro using if statements to display a message box with the rating of the students from the student table on the left here, when you have his or her name selected, so you need to make sure that you have the student's name selected before you execute the macro. Okay, this is how the macros should work. So you need to make sure to construct the text on the message box using string concatenation. So you can catenate strings using the ampersand as shown on previous examples. So as examples of what a messagebox should say, Jennifer is excellent.

Adam has failed Bob has passed and Joe is good. And as a tip Make sure to try to change the values for the marks and rerun your macro to make sure it's working correctly. So this is a very simple macro that you're going to create you Using if statements to pop up some message boxes about the grades of the students. Okay, so you need to make sure to select the student's name before executing the macro. Now I do have the answer for the exercise here on the module called exercise answer. So if you get stuck Have a look at that answer, but please try to attempt the exercise yourself and if you have any questions, please leave them in the q&a section.

Thank you very much for watching this video and I'll see you on the next one.