database MS Access 的实体关系图

Entity Relationship Diagram for MS Access

提问by James Marshall

I've worked with MySQL and MSSQL for some time and have used a variety of CASE and UML tools when designing some of my more complex projects.

我使用 MySQL 和 MSSQL 已经有一段时间了，并且在设计一些更复杂的项目时使用了各种 CASE 和 UML 工具。

I was recently asked by a colleague if I could provide an Access database for his department. The application itself isn't too complicated, and Access actually looks like the ideal tool for the task at hand.

最近，一位同事问我是否可以为他的部门提供 Access 数据库。应用程序本身并不太复杂，而且 Access 实际上看起来像是手头任务的理想工具。

Apart from a couple of very amateur databases many years ago (before I'd even heard of normalization) I haven't much experience of Access. I've got into the habit of using ER diagrams to design databases and want to do the same when working with Access. It seems that the built in "Relationship" view is fine for viewing relationships (duh!), but you have to create the tables first, which seems to defeat the point somewhat.

除了多年前的几个非常业余的数据库（在我什至听说过规范化之前），我对 Access 没有太多经验。我已经养成了使用 ER 图来设计数据库的习惯，并希望在使用 Access 时也这样做。似乎内置的“关系”视图适用于查看关系（废话！），但是您必须先创建表，这似乎有点违背了这一点。

Does anybody know of any way to directly design the database using an ERD, either natively within Access, or else via round-trip generation using a 3rd party tool? Non of the software I usually use support Access.

有没有人知道使用 ERD 直接设计数据库的任何方法，无论是在 Access 中本机还是使用 3rd 方工具通过往返生成？我通常使用的软件不支持 Access。

I think I've been spoiled by by using "real" databases, but any help is appreciated...

我想我已经被使用“真正的”数据库宠坏了，但任何帮助都值得赞赏......

Update:I selected the answer below because it jogged my memory about using ODBC for the job - I already use the excellent ArgoUML application that can connect via ODBC. Just wanted to clarify that selecting the answer below wasn't endorsing the ModelRight application as I never needed to install it.

更新：我选择了下面的答案，因为它让我想起了使用 ODBC 完成工作的记忆——我已经使用了可以通过 ODBC 连接的优秀 ArgoUML 应用程序。只是想澄清一下，选择下面的答案并不支持 ModelRight 应用程序，因为我从不需要安装它。

采纳答案by Dwight T

ModelRight will do this for you. You can download the community version which will access any db using ODBC and Mysql.

ModelRight 将为您执行此操作。您可以下载使用 ODBC 和 Mysql 访问任何数据库的社区版本。

http://www.modelright.com/downloads.aspx

http://www.modelright.com/downloads.aspx

I currently use it with SQL server and it works great.

我目前将它与 SQL 服务器一起使用，效果很好。

回答by Dwight T

Dezign from datanamic (erd tool) can read in access databases and make a diagram out of it. No ODBC needed. Native connection to ms access.

来自 datanamic（erd 工具）的 Dezign 可以读取访问数据库并从中制作图表。不需要 ODBC。与 ms 访问的本机连接。

dezign for databases

数据库设计

回答by Albert D. Kallal

You can most certainly design tables from the diagram view. Simply right click on any table in the diagram and select design view.

您当然可以从图表视图设计表格。只需右键单击图表中的任何表格并选择设计视图。

To add a table, you do have to create the table first (but that's not really a big deal, and really only amounts to an extra mouse click or so.)

要添加表格，您必须先创建表格（但这并不是什么大不了的事，实际上只需要额外单击鼠标左右。）

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. So this all important join information has to be documented some place else in those other "supposed" professional tools. so somehow managed to leave out a most useful and important option in their relatonship desingers.

并且您发现 Access 图正确地显示了左连接，而 SQL Server 和您注意到的其他人没有正确显示关系设计器中的左连接。因此，必须将所有重要的连接信息记录在其他“假定”专业工具中的其他位置。所以不知何故设法在他们的关系设计者中遗漏了一个最有用和最重要的选项。

So any and all table design can be done from the Access relationships (diagram) view. You ONLY “very slight” change is to whack the create tab, and then choose table design – you have to add the table. (just add the PK id autonumber) and save it. From that point onwards from the Access ERD view, you can add the table and right click to design everything else` (including setting up relationships) from that point on.

所以任何和所有的表设计都可以从访问关系（图表）视图中完成。您只有“非常轻微”的更改是重击创建选项卡，然后选择表格设计——您必须添加表格。（只需添加 PK id 自动编号）并保存。从那时起，从 Access ERD 视图开始，您可以添加表并右键单击以从那时起设计其他所有内容（包括设置关系）。