Middle Caicos is accessible by plane or by ferry to North Caicos. There are a couple hundred full-time residents on the island, a few stores and local restaurants. If you like that kind of thing it is a wonderful place to be.
Most of the farming is done on North Caicos and not Middle. You take the ferry to North then cross the causeway into Middle.