{"id":64850,"date":"2019-07-22T11:10:38","date_gmt":"2019-07-22T11:10:38","guid":{"rendered":"http:\/\/www.accessrepairnrecovery.com\/blog\/?p=64850"},"modified":"2023-08-22T06:51:19","modified_gmt":"2023-08-22T06:51:19","slug":"ms-access-relationships","status":"publish","type":"post","link":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships","title":{"rendered":"Get Quick Idea On How To Create, Edit And Delete MS Access Relationships"},"content":{"rendered":"<div class=\"8e1a49907eb0ebe2b39ac6355e555698\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\"><strong>Have you ever worked with the Microsoft Access database coolest option \u201cRelationships\u201d?<\/strong> If not then this blog will surely gonna help you a lot.<\/p>\n<p style=\"text-align: justify;\">As this post mainly focuses on providing every pinch of information regarding <strong>MS Access Relationships<\/strong>. Apart from this, the blog will also help you in easy learning of different ways to create relationships in Access and how to delete the relationship in Access.<!--more--><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><span style=\"color: #000080;\"><strong>What Are Relationships In Microsoft Access ?<\/strong><\/span><\/span><\/h2>\n<p style=\"text-align: justify;\">In MS Access relational Database, data contained in one table is associated with data present in other tables. The Access database relationship option is mainly used to link reference information between multiple Access tables.<\/p>\n<p style=\"text-align: justify;\"><strong>MS Access relationships<\/strong> window allows you to set relationships between several items kept in multiple Access tables. You can fetch this option by clicking to <strong>Database Tools<\/strong>\u00a0&gt;\u00a0<strong>Relationships<\/strong>.<\/p>\n<h4 style=\"text-align: justify;\"><strong>Example Of MS Access Relationships<\/strong><\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64857\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_access_2013_3.png\" alt=\"\" width=\"588\" height=\"191\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_access_2013_3.png 588w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_access_2013_3-300x97.png 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/p>\n<p style=\"text-align: justify;\">Access relationship feature helps you to combine data of two different tables. Every single relationship consists of fields in two tables having corresponding data.<\/p>\n<p style=\"text-align: justify;\"><strong>Let\u2019s take an example:<\/strong><\/p>\n<p style=\"text-align: justify;\">Suppose you have created tables with the names Products and OrderDetails. In these two tables, you have one common field i.e ProductID. So, every record in the Products table has a ProductID which corresponds to the record present in the OrderDetails table with the same ProductID.<\/p>\n<p style=\"text-align: justify;\">When anyone uses a related table in the query, the relationship allows Access to make a selection about, which records of each table need to get combined in the result set.<\/p>\n<p style=\"text-align: justify;\">The relationship also prevents data missing issues by saving deleted data from getting out of synch. This is known as referential integrity.<\/p>\n<h2><span style=\"text-decoration: underline;\"><strong>What Are The Types Of Relationship In MS Access?<\/strong><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64856\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-16-638.jpg\" alt=\"\" width=\"638\" height=\"479\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-16-638.jpg 638w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-16-638-300x225.jpg 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-16-638-320x240.jpg 320w\" sizes=\"auto, (max-width: 638px) 100vw, 638px\" \/><\/p>\n<p style=\"text-align: justify;\">Basically, there are three types of MS Access relationships.<\/p>\n<h4 style=\"text-align: justify;\">One-to-One:<\/h4>\n<p style=\"text-align: justify;\">Table A having a row that is exactly the same present in table B and vice versa. In this way, one to one relationships in Access is created<\/p>\n<h4 style=\"text-align: justify;\">One-to-Many (or Many-to-One)<\/h4>\n<p style=\"text-align: justify;\">In the case of a One-to-Many relationship, table A contains a row that has more than one similar row in table B. But when it comes to vice versa a row of table B must contain only one matching row in table A.<\/p>\n<h4 style=\"text-align: justify;\">Many-to-Many<\/h4>\n<p style=\"text-align: justify;\">In many to many relationships, table A can contain many similar rows in table B and vice versa. Well, this kind of relationship can be made using third table commonly known as <strong>junction table<\/strong> which keeps lookup data of both tables.<\/p>\n<h2 style=\"text-align: left;\"><span style=\"text-decoration: underline;\"><strong>How To Work With Relationships In Access Database?<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\"><strong><em>I have listed down the complete manual steps to set up the relationship in the Access database, but for quick and easy learning you can watch out this video:<\/em><\/strong><\/p>\n<p><iframe loading=\"lazy\" title=\"How To Work With Access Database Relationships?\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/vdeVGzwot_I?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/p>\n<h2 style=\"text-align: left;\"><span style=\"text-decoration: underline;\"><strong>How To Create Relationships In<\/strong> Access 2016?<\/span><\/h2>\n<p style=\"text-align: justify;\">in this section we will discuss how to <span style=\"color: #000000;\"><strong>Create Relationships In<\/strong> <strong>Access 2016. <\/strong>Well, y<\/span>ou can <strong>create relationships in Access<\/strong> using the Relationships Window.<\/p>\n<p style=\"text-align: justify;\">In the Microsoft Access Relationships window, add tables that you want to crosslink. After then drag the field to link them from one table to another.<\/p>\n<p style=\"text-align: justify;\">Another method is to drag a field from the <strong>Field List<\/strong>\u00a0pane to the <strong>table datasheet.<\/strong><\/p>\n<p style=\"text-align: justify;\">Note:<\/p>\n<p style=\"text-align: justify;\">While <strong>creating relationships between tables in Access,<\/strong> common fields do not need to have the same name.\u00a0 But the field must contain the same data type.<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Create A Table Relationship By Using The Relationships Window<\/strong><\/span><\/h3>\n<ul>\n<li>In your MS Access application window, go to <strong>Database Tools\u00a0<\/strong> Now, from the <strong>Relationships<\/strong> section, tap to the\u00a0<strong>Relationships <\/strong>icon.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64860\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_1.png\" alt=\"\" width=\"952\" height=\"687\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_1.png 952w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_1-300x216.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_1-768x554.png 768w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\" \/><\/p>\n<ul>\n<li>Tapping to this Relationships icon will automatically open up &#8220;<strong>Show Table&#8221; <\/strong>dialog box on your screen. If this dialog box won\u2019t come automatically. After then go to the <strong>Design<\/strong>\u00a0tab&gt;<strong>Relationships<\/strong> section and tap to the <strong>Show Table <\/strong>option. In this <strong>Show Table<\/strong> dialog box, you can see all tables and queries used in your particular database. If you want to see only Access tables then click to the <strong>Tables <\/strong>tab. In order to see only Access queries, tap to <strong>Queries <\/strong>tab. To see all tables and queries tap to <strong>Both <\/strong>tab.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64861\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_2.png\" alt=\"\" width=\"952\" height=\"687\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_2.png 952w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_2-300x216.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_2-768x554.png 768w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\" \/><\/p>\n<ul>\n<li>Make a selection of either one or more queries\/tables after then tap to the <strong>Add <\/strong> After completing up the work of adding tables and queries into the Relationships document tab, hit the <strong>Close <\/strong>option.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64862\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_3.png\" alt=\"\" width=\"952\" height=\"687\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_3.png 952w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_3-300x216.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_3-768x554.png 768w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\" \/><\/p>\n<ul>\n<li>Now you need to drag the field (mainly the primary key field) of one table into the common field (which a foreign key) in another table. If you need to drag more than one field. Then keep pressing the <strong>CTRL<\/strong> key, tap to each field, after then drag them all. Now <strong>Edit Relationships <\/strong>dialog box pop-up on your screen.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64863\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_4.png\" alt=\"\" width=\"952\" height=\"687\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_4.png 952w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_4-300x216.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_4-768x554.png 768w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\" \/><\/p>\n<ul>\n<li>You need to verify for the field names that all the shown field names are actually common fields for relationships. If in case the field name won\u2019t match or it is incorrect, then tap to the field name and make a selection of the right field from the list.<br \/>\nFor enforcing referential integrity for this new relationship, choose the <strong>Enforce Referential Integrity <\/strong>check box.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64858\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_access_2013_4.png\" alt=\"How To Create, Edit And Delete MS Access Relationships\" width=\"356\" height=\"249\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_access_2013_4.png 356w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_access_2013_4-300x210.png 300w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/p>\n<p style=\"text-align: justify;\">To catch more information on referential integrity, check out our blog on <strong><a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-fix-ms-access-can-t-create-the-relationship-and-enforce-referential-integrity-issue\">Enforce Referential Integrity.<\/a><\/strong><\/p>\n<ol style=\"text-align: justify;\" start=\"6\">\n<li>Hit the <strong>Create option<\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">MS Access will make a relationship line between two tables. If you have chosen the <strong>Enforce Referential Integrity<\/strong> check box, the line will seem to be thicker at each of the ends.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64864\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_5.png\" alt=\"\" width=\"952\" height=\"687\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_5.png 952w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_5-300x216.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/create_a_relationship_in_microsoft_access_5-768x554.png 768w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\" \/><\/p>\n<p style=\"text-align: justify;\">Additionally, if again you have selected the check box of <strong>Enforce Referential Integrity<\/strong>, then the number\u00a0<strong>1<\/strong> will appears above the thick portion present on one side of the relationship line, whereas the infinity symbol located above the thick portion present on another side of the line.<\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>How To Edit Relationship In Access?<\/strong><\/span><\/h2>\n<p>You can make modifications in the relationship by choosing it in the relationship window and then make editing of it.<\/p>\n<ol style=\"text-align: justify;\">\n<li>Correctly position the cursor on the relationship line and then tap to the line to make the selection of it. When the relationship line is selected well, it appears thicker.<\/li>\n<li>Double click the selected relationship line.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">\u2013or else-<\/p>\n<p style=\"text-align: justify;\">Go to the <strong>design<\/strong> tab, and from the Tools group, tap to the <strong>Edit Relationships <\/strong>option.<\/p>\n<p style=\"text-align: justify;\">Hitting on this option will open the<strong> Edit Relationships<\/strong>\u00a0dialog box.<\/p>\n<h3 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">Open The Edit Relationships Dialog Box<\/span><\/strong><\/h3>\n<ol style=\"text-align: justify;\">\n<li>Go to the database tools tab, and from the <strong>Relationships <\/strong>group, tap the <strong>Relationships<\/strong> icon.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">This will open up the Relationships window on your screen.<\/p>\n<p style=\"text-align: justify;\">If you are opening the relationships windows for the first time, then it will pop-up a <strong>Show Table<\/strong>\u00a0dialog box on your screen. If this dialog box appears, hit on the\u00a0<strong>Close <\/strong>option.<\/p>\n<ol style=\"text-align: justify;\" start=\"2\">\n<li>Now on the <strong>Design <\/strong>tab, go to the <strong>Relationships<\/strong>\u00a0group and hit the\u00a0<strong>All Relationships <\/strong>option.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">You will see all the tables are get listed along with their relationships and relationship lines.<\/p>\n<p style=\"text-align: justify;\">Note:<\/p>\n<p style=\"text-align: justify;\">The hidden tables and their relationship won\u2019t appear until <strong>Show Hidden Objects <\/strong>is been chosen in the <strong>Navigation Options<\/strong>\u00a0dialog box.<\/p>\n<p style=\"text-align: justify;\">For this, you need to uncheck the <strong>hidden<\/strong> check box option of the particular table present within the table&#8217;s\u00a0<strong>Properties<\/strong>\u00a0dialog box.<\/p>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li>For changing the relationship, tap into the relationship line. When it is selected it appears thicker.<\/li>\n<li>Make double tap on the relationship line.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">-or-<\/p>\n<p style=\"text-align: justify;\">Go to the\u00a0<strong>Design<\/strong>\u00a0tab and from the\u00a0<strong>Tools<\/strong>\u00a0group, hit on the\u00a0<strong>Edit Relationships <\/strong>option.<\/p>\n<p style=\"text-align: justify;\">This will open up the <strong>Edit Relationships<\/strong>\u00a0dialog box.<\/p>\n<ol style=\"text-align: justify;\" start=\"5\">\n<li>Do whatever change you want to do, and then click\u00a0to the <strong>OK <\/strong><\/li>\n<\/ol>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>How To Delete Relationship In Access?<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\"><strong>Remark:<\/strong> With the deletion of the relationship, the referential integrity support for that specific relationship is also been removed. After then the Access will not prevent the automatic creation of records on many sides of the relationship.<\/p>\n<p style=\"text-align: justify;\">To remove a relationship from any table, you need to delete the relationship line appearing in the Relationships window.<\/p>\n<p style=\"text-align: justify;\">Place your cursor pointing on the relationship line, and hit the line. After tapping on the relationship line, it will appear thicker if it is selected. Keeping the relationship line selected, hit the<strong> DELETE<\/strong> option.<\/p>\n<ol style=\"text-align: justify;\">\n<li>Firstly, you need to go to<strong> the Database Tools <\/strong>tab, and then from the\u00a0<strong>Relationships<\/strong>\u00a0group, hit the <strong>Relationships <\/strong><\/li>\n<li>Now go to the\u00a0<strong>Design <\/strong>tab, and in the\u00a0<strong>Relationships<\/strong> section, tap to the <strong>All Relationships <\/strong>after then all the tables along with their relationships and relationship lines are displayed.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><strong>Note:<\/strong><\/p>\n<p style=\"text-align: justify;\">The hidden tables and their relationship won\u2019t appear until <strong>Show Hidden Objects<\/strong> is been chosen in the <strong>Navigation Options<\/strong> dialog box.<\/p>\n<p style=\"text-align: justify;\">For this, you need to un-check the hidden check box option of the particular table present within the table&#8217;s <strong>Properties<\/strong> dialog box.<\/p>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li>Hit on the relationship line of the relationship which you want to delete. The line of relationship appears thicker after being selected.<\/li>\n<li>Hit the DELETE key.<\/li>\n<li>After then the Access will display the pop-up message\u00a0like: \u201c<strong>Are you sure you want to permanently delete the selected relationship from your database?\u201d<\/strong>. when this confirmation message comes to your screen, tap to the\u00a0<strong>Yes <\/strong>option.<\/li>\n<\/ol>\n<p>So, try out the above steps to<strong> delete relationship in Access.<\/strong><\/p>\n<h2><span style=\"text-decoration: underline;\"><strong>Try The Recommended Option:<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">Sometimes the relationship in Access goes missing or won\u2019t work either due to table corruption or due to the entire of your Access database corruption. In that case, you should try a professional <a href=\"https:\/\/www.accessrepairnrecovery.com\/download-access-repair.php\"><strong>MS Access Repair\u00a0 &amp; Recovery Tool<\/strong><\/a>. This recovery software successfully restores every database object like queries, forms, reports, macros, relations, the referential integrity, modules, field properties, tables, relations, and absolutely all field types including Memo, OLE from the corrupted MDB and ACCDB files.<\/p>\n<h2 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">Conclusion:<\/span><\/strong><\/h2>\n<p style=\"text-align: justify;\">So, now you have got enough idea on<strong> how to create, edit or delete relationship in Access<\/strong>. To check this up you can query data across any of the two tables and get meaningful results from it.<\/p>\n<div style='margin: 8px 0; clear: both;'><div style='border: 1px solid #e7e7e7; border-radius: 3px; background: #ffffff; color: #000; margin-top: 30px;'><div style='display: inline; background: #fff; padding: 10px; border: 1px solid #e7e7e7; border-bottom-right-radius: 10px; border-top-left-radius: 10px; border-top-right-radius: 10px; margin-left: -1px;'><img src='https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/12\/y-bulb.png' alt='tip' style='vertical-align: middle;' width='30px'><strong style='font-size: 18px; vertical-align: middle;'> Still having issues?<\/strong> Fix them with this Access repair tool: <\/div><div style='padding: 1rem; line-height: 1.6;'><p style='margin: 0; font-size: 17px;'>This software repairs & restores all ACCDB\/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.<\/p><div><ol style='font-size: 17px;'><li><strong><a href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'>Download Stellar Repair for Access <\/a><\/strong> rated <i>Great<\/i> on Cnet (<i>download starts on this page<\/i>).<\/li><li>Click <strong>Browse<\/strong> and <strong>Search<\/strong> option to locate corrupt Access database.<\/li><li>Click <strong>Repair<\/strong> button to repair & preview the database objects.<\/li><\/ol><\/div><\/div><\/div><\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Have you ever worked with the Microsoft Access database coolest option \u201cRelationships\u201d? If not then this blog will surely gonna &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Get Quick Idea On How To Create, Edit And Delete MS Access Relationships\" class=\"read-more button\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#more-64850\" aria-label=\"Read more about Get Quick Idea On How To Create, Edit And Delete MS Access Relationships\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":64859,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[1104,1278,1109,1112,1111,1110,1279,1108,1107,1105],"class_list":["post-64850","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial","tag-access-relationships","tag-create-relationships-in-access","tag-creating-relationships-between-tables-in-access","tag-delete-a-table-relationship-in-access","tag-edit-relationship-in-access","tag-example-of-access-database-with-relationships","tag-how-to-create-relationships-in-access-2016","tag-microsoft-access-2013-relationships","tag-ms-access-2010-relationships","tag-ms-access-relationships","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Get Quick Idea On How To Create, Edit And Delete MS Access Relationships<\/title>\n<meta name=\"description\" content=\"Catch complete information on MS Access Relationships and its types. Learn how to create, edit and delete relationships in MS Access.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get Quick Idea On How To Create, Edit And Delete MS Access Relationships\" \/>\n<meta property=\"og:description\" content=\"Catch complete information on MS Access Relationships and its types. Learn how to create, edit and delete relationships in MS Access.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships\" \/>\n<meta property=\"og:site_name\" content=\"MS Access Repair And Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-22T11:10:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-22T06:51:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-relationship.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Pearson Willey\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pearson Willey\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships\"},\"author\":{\"name\":\"Pearson Willey\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\"},\"headline\":\"Get Quick Idea On How To Create, Edit And Delete MS Access Relationships\",\"datePublished\":\"2019-07-22T11:10:38+00:00\",\"dateModified\":\"2023-08-22T06:51:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships\"},\"wordCount\":1621,\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-relationship.png\",\"keywords\":[\"access relationships\",\"create relationships in Access\",\"creating relationships between tables in access\",\"Delete a table relationship in access\",\"edit relationship in access\",\"example of access database with relationships\",\"How To Create Relationships In Access 2016\",\"Microsoft access 2013 relationships\",\"ms access 2010 relationships\",\"MS Access Relationships\"],\"articleSection\":[\"Tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships\",\"name\":\"Get Quick Idea On How To Create, Edit And Delete MS Access Relationships\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-relationship.png\",\"datePublished\":\"2019-07-22T11:10:38+00:00\",\"dateModified\":\"2023-08-22T06:51:19+00:00\",\"description\":\"Catch complete information on MS Access Relationships and its types. Learn how to create, edit and delete relationships in MS Access.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#primaryimage\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-relationship.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-relationship.png\",\"width\":900,\"height\":450,\"caption\":\"How To Create, Edit And Delete MS Access Relationships\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get Quick Idea On How To Create, Edit And Delete MS Access Relationships\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"name\":\"MS Access Repair And Recovery Blog\",\"description\":\"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More\",\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\",\"name\":\"MS Access Repair And Recovery Blog\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"MS Access Repair And Recovery Blog\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\",\"name\":\"Pearson Willey\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"caption\":\"Pearson Willey\"},\"description\":\"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Get Quick Idea On How To Create, Edit And Delete MS Access Relationships","description":"Catch complete information on MS Access Relationships and its types. Learn how to create, edit and delete relationships in MS Access.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships","og_locale":"en_US","og_type":"article","og_title":"Get Quick Idea On How To Create, Edit And Delete MS Access Relationships","og_description":"Catch complete information on MS Access Relationships and its types. Learn how to create, edit and delete relationships in MS Access.","og_url":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships","og_site_name":"MS Access Repair And Recovery Blog","article_published_time":"2019-07-22T11:10:38+00:00","article_modified_time":"2023-08-22T06:51:19+00:00","og_image":[{"width":900,"height":450,"url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-relationship.png","type":"image\/png"}],"author":"Pearson Willey","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Pearson Willey","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#article","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships"},"author":{"name":"Pearson Willey","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb"},"headline":"Get Quick Idea On How To Create, Edit And Delete MS Access Relationships","datePublished":"2019-07-22T11:10:38+00:00","dateModified":"2023-08-22T06:51:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships"},"wordCount":1621,"publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-relationship.png","keywords":["access relationships","create relationships in Access","creating relationships between tables in access","Delete a table relationship in access","edit relationship in access","example of access database with relationships","How To Create Relationships In Access 2016","Microsoft access 2013 relationships","ms access 2010 relationships","MS Access Relationships"],"articleSection":["Tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships","name":"Get Quick Idea On How To Create, Edit And Delete MS Access Relationships","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#primaryimage"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-relationship.png","datePublished":"2019-07-22T11:10:38+00:00","dateModified":"2023-08-22T06:51:19+00:00","description":"Catch complete information on MS Access Relationships and its types. Learn how to create, edit and delete relationships in MS Access.","breadcrumb":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#primaryimage","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-relationship.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/07\/ms-access-relationship.png","width":900,"height":450,"caption":"How To Create, Edit And Delete MS Access Relationships"},{"@type":"BreadcrumbList","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ms-access-relationships#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.accessrepairnrecovery.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Get Quick Idea On How To Create, Edit And Delete MS Access Relationships"}]},{"@type":"WebSite","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","name":"MS Access Repair And Recovery Blog","description":"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More","publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization","name":"MS Access Repair And Recovery Blog","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","width":350,"height":70,"caption":"MS Access Repair And Recovery Blog"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb","name":"Pearson Willey","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","caption":"Pearson Willey"},"description":"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey"}]}},"_links":{"self":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/64850","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/comments?post=64850"}],"version-history":[{"count":1,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/64850\/revisions"}],"predecessor-version":[{"id":67661,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/64850\/revisions\/67661"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media\/64859"}],"wp:attachment":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media?parent=64850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/categories?post=64850"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/tags?post=64850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}