I’m developing an Access 2010 database application. It is split into a back-end, holding all the tables, and a front-end, holding all the queries, forms, etc. I find the Relationships tool helps provide an extremely valuable visual resource (an ERD), in the back-end, and know that Access uses it to enforce integrity.
So far, however, I’ve never used the same tool in the front-end. I have many more queries than tables but have never seen them in form of an entity-relationship diagram. Have you ever found it useful to diagram your queries using the Relationships tool? Any advice on what practice has worked well for you?