Key component: wireless access point
Wireless access points are smallish boxes with one or two aerials and an Ethernet cable that provides a connection to the network. Each has its own IP address, and can plug straight into a hub, switch or broadband router. If you've configured it and the wireless network cards correctly it'll transparently link your wireless computers to the local wired network.
There are now broadband modems that not only incorporate a router, but also a wireless access point, such as the Vigor 2600We (www.draytek.co.uk). If you need all of these features then you may find it convenient to have everything in one place, although so far they are no less expensive than buying a modem/router and a separate wireless access point.