All vehicles need a smog check during a title transfer whether the vehicle was given to them or purchased. The rule does only not apply when the title transfer is between immediate family members.
In this particular case, you will need to have the Honda Accord smog checked before getting the title transferred in your name.