Yes, there are regular trains to Alkmaar from CS. Snelltreins (fast trains) two times per hour. The Achterdam is about a 15 minute walk from the Alkmaar train station. Set your sites on the Waagplein...