13 Data Modeling tools for MS Access

This is the list of all database modeling and design tools for MS Access we found on the web. If you found something else or see any inaccuracies, let us know and we'll fix it.


Toad Data Modeler


Toad Data Modeler enables developers, DBAs, and designers to create, maintain and document quality database designs and structures across various database platforms.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, Access, DB2, Teradata, SAP ASE, SAP SQL Anywhere, SAP IQ, SQLite

Notable features: Model synchronization, generation of HTML, RTF and PDF reports, generation of alter (change) scripts

Type: Commercial

DeZign for Databases


Database design and modeling tool

Supports: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Access, SQLite3, SAP ASE, Firebird, Interbase, NexusDB, SAP SQL Anywhere

Notable features: Forward engineering (generates complete DDL scripts), subdiagrams (subviews), compare and merge models utility, model (model-to-database and database-to-model)

Type: Commercial



Data Modeling for Multi-Platform Environments

Supports: SQL Server, Oracle, MySQL, PostgreSQL, DB2, SAP ASE, MongoDB, Hadoop + Hive, Firebird, Hadoop, Hive, Access, SAP ASE, SAP IQ, Teradata

Type: Commercial



DbSchema is diagram designer and query tool.

Supports: SQL Server, Oracle, MySQL, Amazon Redshift, Cache, Cassandra, DaffodilDB, DB2, Derby, JavaDB, Exasol, Firebird, Filemaker, FoxPro, FrontBase, HBase, H2, Hive, HyperSQL, Informix, Ingres, JDataStore, MariaDb, MongoDb, Access

Type: Commercial



A database modeling tool for creating Entity Relationship Diagrams, Relational Schemas, Star Schemas, and SQL DDL statements.

Supports: SQL Server, Oracle, MySQL, PostgresSQL, Teradata, IBM DB2, Access

Notable features: Web application

Type: Free



Jeddict is an open source graphical tool that enhances productivity and simplifies development tasks of creating complex entity relationship models.

Supports: SQL Server, Oracle, MySQL, SAP ASE, PostgreSQL, Access, H2, Apache Derby

Notable features: Plugin to Netbeans

Type: Free

DatabaseSpy Graphical Database Design Tool


The Altova DatabaseSpy® 2017 graphical database Design Editor lets you view and edit the structures of all your databases through one graphical user interface.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, SAP ASE, Firebird, IBM DB2, Informix, Access, Azure SQL Database, OpenEdge, SQLite

Type: Commercial

DTM Data Modeler


DTM Data Modeler is a CASE tool for database developers that supports both forward and reverse engineering.

Supports: SQL Server, Oracle, IBM DB2, SQLite, Access, MySQL, SAP ASE, Interbase, Firebird

Type: Commercial

Database Designer for MySQL


Powerful MySQL-oriented database structure modeling, generation and modification.

Supports: SQL Server, Oracle, MySQL, Access, SAP, ASE, Informix, DB2, DBF

Type: Commercial

AnySQL Maestro


AnySQL Maestro is the premier multi-purpose admin tool for database management, control and development.

Supports: SQL Server, Oracle, MySQL, Access

Type: Commercial



MagicDraw is the award-winning business process, architecture, software and system modeling tool with teamwork support.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Standard SQL, PointBase, SAP ASE, Pervasive, Cloudscape, Access

Type: Commercial

ConceptDraw PRO


The main tool of domain modeling at the stage of conceptual design is the Entity-relationship model, also called ER-model.

Supports: SQL Server, Oracle, MySQL, InterBase, Access, Firebird

Type: Commercial

Visible Analyst


The Visible Analyst DB Engineer edition is focused on the Data Modeling and Database Engineering functionality of the popular Visible Analyst product.

Supports: SQL Server, Oracle, MySQL, Access, ANSI SQL-92, Centura SQLBase, DB2, DBASE IV SQL, Datacom SQL, Informix SQL, Ingres SQL, Netware SQL, Paradox, Progress, Rdb SQL, Server System, Teradata,, Unify SQL, Watcom, SAP SQL Anywhere, XDB SQL

Type: Commercial