Import from Access Database

You can reverse engineer the existing Microsoft Access database. This means that you can extract the database tables, attributes, relationships, indexes and other object from Microsoft Access database file to your diagram.

To reverse engineer Microsoft Access database:

Choose File | Reverse Engineer | Microsoft Access database.
If the currently opened diagram already contains some objects, a warning dialog will appear.

It requests you to create a new diagram to place the reversed objects or use the currently opened diagram.
Click Yes to create a new diagram, No to use the current diagram. Cancel to cancel reverse engineering.
Select Do not show this dialog again to prevent the showing of this dialog again.
The Access Reverse Engineering tool will be shown. First, provide full path to Access database in the Access File tab.
You can set reverse engineering options in the Option tab.

Tables only
Reverse engineer only tables ignoring views.

Tables and Views
Reverse engineer both tables and views.

Garbage symbols remove/replace
Defines symbols that will be replaced in the object's names.

Replace with
Defines a garbage replacement symbol.

Build references
This option enables extracting foreign keys from the database and creating the appropriate references in your diagram.

Automatically rebuild references when no reference is reversed
If there are no physical references extracted, it is possible to build them from logical structure of the database.
Enabling this feature leads to automatic reconstruction of references. Such reconstruction works by the following scheme: each column of a table is being compared with all primary keys of other tables, and if the column name and data type match one of the primary keys, a reference between the source column and the key column will be created.
This option available for modification only if Build references is checked.

Tables in a Diagram row
This option determine how reversed tables will be disposed on the diagram.
Reversed tables will be placed on the diagram in rows with equal distance, this option determine how many tables at most will be in one row.
In the Selection tab of the Access Reverse Engineering tool you can choose tables you want to reverse engineer.

Check on a checkbox near table to enable its reverse engineering.
Pay attention to the Select All and Deselect All button on the tab, they allow you to select/deselect all tables in the list.
Click OK to start the database reverse engineering process. The Output -> Reverse docking window will display the nstate of the process.
The reversed database objects will be placed on your diagram.