在Microsoft Access中，关系^{(Relationship)}可帮助您将数据从一个表合并或链接到另一个表。关系^{(Relationships)}允许用户创建查询、^(Queries,) 表单^(Forms)和报告^(Reports)。当为数据库中的每个主题创建表时，您必须将公共字段放入相关的表中并与它们形成关系，以便再次将信息聚集在一起。

^(Create)在Access中^(Access)创建、编辑^(Edit)、删除^(Delete)表关系

有以下三种类型的关系：

1. 一对一关系^{(One-to-One Relationship)}：一对一关系^{(Relationship)}是最简单的一种关系^{(Relationship)}，也是最不常见的，因为相关的信息存储在同一个表中。它将一个表链接到另一个表中的单个记录；主键^{(Primary Keys)}链接表。一对一关系^{(Relationship)}可以将具有许多字段的表连接在一起，并出于安全原因将表分开。
2. 一对多关系^{(A One-to-Many relationship)}：一对多关系^{(Relationship)}是最常见的关系^{(Relationship)}；它将一张表中的每条记录链接到另一张表中的多条记录。只有一个被链接的字段可以是Primary Key，并且Primary Key必须有一个记录，用于另一个表中的许多记录。
3. 多对多关系^{(Many-to-Many relationships)}：多对多关系^{(Relationship)}需要一个连接表^{(Junction Table)}，其中包括要连接的两个表的主键列。^{(Primary Key)}多对多关系^{(Relationship)}允许您将一个表的每一行连接到另一个表中的多行。

为什么在 Access 中使用表关系？^{(Why use table relationships in Access?)}

• 表关系更新您的表单和报表设计^{(Table Relationships updates your form and report designs)}– 当您设计表单和报表时，Access需要一个关系^{(Relationship)}来收集可以放置在您创建的表单或报表中的信息。
• 表关系更新您的查询设计^{(Table Relationships updates your query design)}——要使记录从多个表中工作，必须创建一个查询来连接这些表。该查询通过将第一个表的主键字段中的值与第二个表中的外键进行匹配来工作。
• 参照完整性可以在表关系中强制执行^{(Referential Integrity can be enforced in a table relationship)}——参照完整性^{(Referential Integrity)}有助于防止数据库中出现孤立记录。孤立记录是引用另一个不存在的记录的记录。

在本文中，我们将解释：

1. 如何在Microsoft Access中创建^{(Microsoft Access)}关系^{(Relationship)}
2. 如何在Microsoft Access中编辑^{(Microsoft Access)}关系^{(Relationship)}
3. 如何在Microsoft Access中删除^{(Microsoft Access)}关系^{(Relationship)}

1] 如何在 Microsoft Access 中创建关系^{(1] How to Create a Relationship in Microsoft Access)}

转到菜单栏上的表格选项卡。^{(Table Tab)}选择关系^{(Relationship)}在关系窗口中，选择添加表。^{(Add Table.)}将打开一个添加表对话框；单击添加选定的表。^{(Add Selected Tables.)}

在“关系”工具部分的左上角，单击“编辑关系^{(Edit Relationships.)}”窗口。^{(Relationship)}选择新建。^{(Create New.)}

在创建新对话框时，您将选择表的左表名称^{(Left Table Name)}和右表^{(Right Table)} 名称^(Name)，然后选择左列名称^{(Left Column Name)}和右列名称，^{(Right Column Name, )}这应该是表的主键^{(Primary Key)}；现在单击确定。^(OK.)

编辑关系^{(Edit Relationship )}对话框将再次显示您选择的选项；按创建^(create)。还有一个快捷选项，您可以将主键^{(Primary Key)}从一个表拖到另一个表；任何链接的表都必须与主键^{(Primary Key)}相关。这将形成两个表之间的关系。

2]如何在Microsoft Access中编辑关系^{(2] How to edit relationships in Microsoft Access)}

您可以在Microsoft Access中修改您的关系^{(Relationships )}；这里有几个步骤。

双击关系线^{(Relationship Line)}，将显示编辑关系^{(Edit Relationship)}对话框。

还有另一种打开编辑关系对话框的方法。在设计选项卡^{(Design Tab)}上，您将看到编辑关系^{(Edit Relationship)}选项；点击它。

做^(Make)任何你想做的改变。

3]在Microsoft Access中删除关系^{(3] Deleting Relationships in Microsoft Access)}

要删除^(Delete)关系，您必须从两个表中删除该行；^{(Relationship)}这些是措施。

右键单击光标，单击删除。^(Delete.)另一种选择是将光标放在行上，然后按Delete Key Button。

将弹出一个对话框，询问您“是否确定要永久删除关系^{(Relationship)}”。

单击确定^(OK)。

相关阅读^{(Related read)}：如何在 Access 中使用表设计器构建表^{(How to build Tables with Table Designer in Access)}。

如果您有任何问题，请在评论中告诉我们，我们会尽快回复您。

How to Create, Edit and Delete a Table Relationship in Access

In Microsoft Access, a Relationship helps you to merge or link data from one table to another. Relationships allow the user to create Queries, Forms, and Reports. When tables are created for each topic in a database, you must place common fields into the table related and form a relationship with them for information to be brought together again.

Create, Edit, Delete a Table Relationship in Access

There are three types of Relationships:

1. One-to-One Relationship: One-to-One Relationship is the simplest kind of Relationship and the least common because the information related is stored in the same table. It links one table to a single record in another table; Primary Keys links tables. One- to- One Relationship can connect a table with many fields together and separate a table for security reasons.
2. A One-to-Many relationship: One-to-Many Relationship is the most common Relationship; it links each record in one table to several records in another table. Only one of the fields been linked can be the Primary Key, and the Primary Key must have one record for many records in another table.
3. Many-to-Many relationships: Many-to-Many Relationship requires a Junction Table, which includes the Primary Key column of the two tables you want to connect.  Many -to Many Relationship allows you to connect each row of one table to many rows in another table.

Why use table relationships in Access?

• Table Relationships updates your form and report designs – When you design a form and report, a Relationship is needed for Access to gather the information that can be placed in the form or report you have created.
• Table Relationships updates your query design – For records to work from more than one table, a query must be created to join these tables. The query works by matching the values in the first table’s primary key field with the foreign key in the second table.
• Referential Integrity can be enforced in a table relationship – Referential Integrity helps to prevent orphan records in your database. An orphan record is a record with reference to another record that does not exist.

In this article, we are going to explain:

1. How to Create a Relationship in Microsoft Access
2. How to Edit a Relationship in Microsoft Access
3. How to Delete a Relationship in Microsoft Access

1] How to Create a Relationship in Microsoft Access

Go to the Table Tab on the menu bar. Select Relationship In the relationship window, select Add Table. An add table dialog box will open; click on Add Selected Tables.

On the left corner in the tools section of the Relationship, window click on Edit Relationships. Select Create New.

In creating a new dialog box, you will choose the Left Table Name and the Right Table Name of your table, then choose the Left Column Name and Right Column Name, which should be the Primary Key of your tables; now click OK.

The Edit Relationship dialog box will be seen again with your selected choice; press create. There is also a shortcut option where you can drag the Primary Key from one table to another table; any table linked must be related to the Primary Key. This will form a relationship between the two tables.

2] How to edit relationships in Microsoft Access

You can modify your Relationships in Microsoft Access; here are a few steps in doing so.

Double-tap on the Relationship Line, and the Edit Relationship dialog box will show up.

There is another way of opening the edit relationship dialog box. On the Design Tab, you will see the Edit Relationship option; click on it.

Make whatever changes you want to make.

3] Deleting Relationships in Microsoft Access

To Delete a Relationship, you must remove the line from the two tables; these are the measures.

Right-click on the cursor, click Delete. The other option is to place the cursor on the line then press the Delete Key Button.

A dialog box will pop up asking you ‘if you are sure you want to permanently delete the Relationship.’

Click OK.

Related read: How to build Tables with Table Designer in Access.

Let us know in the comments if you have any problems and will get back to you.

Related posts

• MDB Viewer Plus：View and Edit Microsoft Access Database Files

• 什么是Ctrl Alt Delete？ Ctrl Alt Del做了什么？

• 如何从游戏面板中删除麻烦且无效的快捷方式

• 如何在Outlook中创建，Edit和Delete Quick Steps

• NVIDIA Control Panel Access拒绝 - 不会应用设置

• 在Chrome中为Remote Access主机启用更少的针对性身份验证

• 什么是远程访问木马？预防、检测和清除

• Windows 10中的快速Access不起作用或慢开放

• TeamViewer：免费的远程访问和控制软件

• 如何从Logon screen中删除Access button的Ease

• Access & use Microsoft Edge有关在Windows 10 flags页面

• 便于Access Keyboard Settings上Windows 10

• Fix Error 1005 Access Denied message访问网站时

• IPersistFile Save失败，Code 0x80070005，Access被拒绝

• ERR NETWORK ACCESS DENIED | ERR INTERNET DISCONNECTED

• 如何Backup and Restore Quick Access Folders在Windows 10

• 如何在Word Quick Access Toolbar上展示Spelling and Grammar tool

• 如何使用Microsoft Access创建Report

• 如何在Access datasheet中添加，删除记录和调整大小列

• Access Replacer：Access button的Access Replacer：Replace Ease，具有有用的工具