You can put a magnetic reed switch on the cabinet door like one of these:
https://www.phidgets.com/?prodid=416
https://www.phidgets.com/?prodid=418
One of them can just be nailed into the door and the frame, and the other is designed to be drilled and fit flush into the frame. When the magnet gets near the switch, it triggers and sends a digital signal down the wires. These sensors can be connected to any Phidget
VINT Hub, including the
SBC3003 and
HUB5000 which don't need to be connected to a computer.
Playing a sound effect is more difficult- the only Phidget that could do this is SBC3003, with something like a USB speaker attached.
This is a fairly heavyweight solution for the task you've described, so unless you want to add other features to the project, you could look into using a microcontroller and analog speaker instead.
