How to Make an ERD in Access

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

An entity relationship diagram (ERD) helps database designers review and verify links between tables in a database. An ERD shows a visual representation of primary and foreign keys, which are the columns used to link tables. Microsoft Access includes a diagram utility that lets you create and view an ERD for your Access database. You can also use this diagram to reverse engineer any database.


Step 1

Open the Microsoft Access database software and open the database in which you want to create the diagram.

Video of the Day

Step 2

Click the "File" menu item and select "New." Click "Software and Database," and then select "Database Model Diagram." A new window opens with a blank diagram.


Step 3

Click the "Database" menu item and click "Reverse Engineer." Access goes through each table and creates a model diagram of your tables and the tables' relationships to each other.





Report an Issue

screenshot of the current page

Screenshot loading...