In a word, yes! The letters to look out for on lenses suitable for the entry level Nikons are AF-S for Nikkors and HSM for Sigmas. Not sure how Tamron label their equivalent (or the other small brands).
(BTW, I wouldn't say you had no idea what you're doing - at least you're aware that your lens choice is slightly limited!!!)