i've just come into an assignment to document an access database (identify what the tables, queries, etc. do, what they're for -- their purpose, basically, be able to identify and explain how a db is functioning), but i'm not sure how much time to recommend for this particular project.
the erd itself is 3 tables! all the other tables are not in the erd, however, they are used in various queries with ad hoc joins. the dude who created it was heavy on the vba side but soft on the erd/normalization (fundamental db) side. i should also add that i'm not heavy on the vba side (will crash course learn it!) but heavy on the fundamental db side (structuring one correctly).
my question to you is: how much time should i recommend it take to document this db?