I havent tested this trainer yet since the offline aspect is not entirely explained. Do accomplishments, skill points, and unlocks carry over when you switch to online again? Or is it like having two separated games?

Yes, they will become available as that save will upload to cloud. but only for that character. uplay points and rewards however are game wide, any character can get those.