Chemistry for Majors - Real Chemistry
Chemistry - Intro: Basically Chemistry Lite
*Chemistry Lite is good if 1) you didn't take Chem in HS, 2) you took Chem in HS, but it has been a while since you were in HS (Returning Adult Students who need a review), 3) You need to fulfill a science requirement for graduation.
The best idea would be to go to Borders, Barnes and Noble, etc and pick up a general study guide to give you a better idea of what to study.
Regarding Chem for Majors or Chem 101 in college, just try to get yourself prepped and be ready to go on day 1. Chem 101, Organic Chem, etc. are often "weed out" type classes that quickly eliminate those who are at school for something other than and education. ;-)
I went to a party with the head of the CU Chemistry Dept just after the final exam in O-Chem, he started talking about "well a lot of students had their dreams of med school dashed today".