Designed and deployed using Access 2000.
I made it to track daily activities and incidents when I worked security at a 4-star hotel.
There is a main switchboard where you select options ranging from beginning a daily activity log, work on your log, begin or edit incident reports (which can hold photographs).
See the readme for a few hints.