Microsoft Access Database Diagram. Type the path and file name for the model that you want to import or click the browse button to locate the model file and then click open. On the database menu point to import and then click import.
Open the database that you want to document. As it happens access contains its own very useful diagram to visualize relations between tables click the relationships button which can be found in the relationships group of the database tools tab on the ribbon. And you find that the access diagram correctly shows left joins where as sql server and others you note do not show left joins in the relationships designer correctly.
Open the database that you want to document.
With the option of reverse engineering youll be able to get a er diagram of your database. The tables are displayed graphically in the new database diagram. Then from tables group click table. For more information see choose the best chart type for your needs.