Hi x2x3i5x,
Like mechengr2000 said, it's what has happened recently that matters even if it's courses from CC. More importantly is to take steps to demonstrate your intent on going into your program of interest. My best friend was in a similar situation. She graduated with no idea what to do with her Psychology degree from university and spent several years miserable working at menial jobs. After some soul-searching she decided she wanted to become an optometrist. So she went to CC for several years and took all the prerequisite sciences courses, getting all A's. She also did a lot of optometry related volunteering services, shadowing doctors, and did good on the OATs. She was accepted this past spring and will be going to optometry school this fall.
Is a PhD program your goal? I'm not knowledgeable enough to say whether going into a MS program first would help, perhaps other members on this forum can answer that. But when you do apply to grad school having things that can demonstrate your seriousness in your program of interest on your application certainly helps your chances. If the courses that you took at CC fulfills some of the prerequisites, then it's a good first step