Horningsea is close enough to Cambridge to cycle (or even a pleasant one hour walk along the river), is close to two train stations (Waterbeach and Cambridge North) and has a very good bus service (7 days a week)

National Rail – Waterbeach Station and Cambridge North is on the Kings Cross line with a fast service to London
Buses
Whippet Coaches provide the 196 service, Mon-Fri, between Cambridge, Horningsea and Waterbeach.
Central Connect run the 100 service. Every 30 mins seven days a week.
Taxis
Beaches Community Car Service is a voluntary, inexpensive service for all reasonable local journeys.
Veezu, Uber and other local taxi firms serve the village
Active Travel
Sustrans cycling route 11, via the River Cam towpath, offers a quiet, safe and pleasant cycling & walking route to Cambridge, Waterbeach and Milton