Must women in their 40s have preventive health screenings?

Yes, to stay healthy. In general these would include pap smears and (if high risk or worried) mammograms to screen for cervical and breast cancer, screens for high bp, depression, alcohol abuse and possibly high cholesterol or blood sugar, obesity, and unhealthy lifestyle behaviors. A good resource is the iphone app my health checklist 2012.