When I was younger, I had my fair share of the dentist! Just remember you need to go there once every sixth months (I think) for a regular checkup.
But if you're going there to fix a cavity, a broken tooth, or to pull out any teeth...then yes, it may be scary. Trust me; even though my teeth...