I have an external monitor which accepts DVI, VGA and HDMI.
I have a MacBook Air which has a Thunderbolt port only.
Can this MacBook Air use the monitor as a secondary display, and what adapter will I need?
You will need a Thunderbolt to DVI adapter. Or, Mini DisplayPort to DVI, since Thunderbolt's display connection is essentially the same as Mini DisplayPort.