Access reports basically have no user interaction, so no drill down. Subreports are doable but they don't provide any sort of pivot table functionality. Access forms don't have pivot table capability either. Not sure if a tree view control would give you what you want but I suspect not. Even so, they are tricky to use and lack documentation and a full property/event listing in the property sheet.
Another potential method is breaking up data into subforms which are then placed on a tab control. Last and probably least useful to you would be loading a table into a subform control where that table has subform data sheet enabled. However that would only provide one drill down level, unless perhaps the "child" tables also have subform data sheets on them. That is something I never use because I adhere to the principle of not exposing tables to users so I'm not sure of what you'd get with that. This might be a job for Excel.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.