A few questions and comments.
It appears that this is a work in progress -- not fully developed.
I don't understand your frmCustomers -- buttons don't seem to be associated with Click events. What's the purpose of the Reports button or the Add or Save, and how do they function? Once I add a Customer, how do I use the form to deal with a Booking?
There are normalization issues with Tour info being stored partly in tblTours, tblTourDates and tblBookings. TourDate and TourDuration are attributes of Tour not Booking. These should be in tblTours. Bookings can be related to Tours thru TourId.
TourDuration should a number and not text.
In your Oct23 db, TourId 1 has TourDate sept 25, 2010 but in tblBookings it has TourDate Oct, 23 2010?? I have no idea what this is supposed to represent. As I mentioned above, there is a normalization issue.
If a Customer makes several Bookings, that Customer could have a different CustomerType for each Booking, so CustomerType should be an attribute of Booking, not Customer.
In your tblCustomers, DOB sometimes has 3 digit year (194) and one is 9999????