Guys,

I havent used access that extensively. I need some pointer about the situation here. I am having internal audit plan for my department which is broadly like this. A centralised internal audit dept for the group that covers about 20 companies. There are about 100 audit programs (at the bottom most in hierarchy) which is under a sub focus area (approx. 15 sub focus areas). These sub focus areas are under main focus area (which are 4).

Either of the audit programs will be carried out for any of the or all companies during the year by the audit staff.

Basically I want to track:

how much time is spent on which focus / sub focus/ company/ audit program/ which audit staff for

travelling
fieldwork
reporting
discussion
presentation

any pointers if this can be managed or simplified in access ? many thanks in advance