{"id":66589,"date":"2025-05-23T12:27:42","date_gmt":"2025-05-23T12:27:42","guid":{"rendered":"http:\/\/www.accessrepairnrecovery.com\/blog\/?p=66589"},"modified":"2025-05-27T19:35:37","modified_gmt":"2025-05-27T19:35:37","slug":"merge-tables-in-access","status":"publish","type":"post","link":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access","title":{"rendered":"MS Access Merge Tables- How to Merge Tables In Access?"},"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;\">Want to know <strong>how to merge tables in Access database<\/strong>? Combining the data from the databases in Access helps you create an effortless overview of a huge amount of data and keep your database organized. However, Access database offers 3 ways to combine tables or consolidate rows\/columns in the primary database tables. In this blog, I will mention the step-by-step instructions for <strong>merging Access database tables <\/strong>easily.<\/p>\n<p style=\"text-align: justify;\"><!--more--><\/p>\n<div style='margin: 10px 0; clear: both;'><div style='clear: both; border-top: 1px solid #eeeeee; border-bottom: 1px solid #eeeeee; margin: 30px auto; padding: 15px 15px 15px 20px; display: flex; align-items: center; justify-content: space-between;'><div style='margin-bottom: 0; line-height: 1.6; flex-shrink: 1;'><span style='color:#aaa; font-size: 13px;'>Rated <i>Excellent<\/i> on <a rel='nofollow' target='_blank' href='https:\/\/www.trustpilot.com\/review\/www.stellarinfo.com'><span style='color: #aaa;'>Trustpilot<\/span><\/a><\/span><br><strong>Free MS Access Database Repair Tool<\/strong><br>Repair corrupt MDB and ACCDB database files and recover deleted database tables, queries, indexes and records easily. Try Now!<br><div style='margin-top: 5px;'><a style='background: #b10923; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 16px; font-weight: 500; padding: 0 16px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'><span style='color: #ffffff;'><i class='fas fa-arrow-alt-circle-down'><\/i><\/span> Download<\/a><br><span style='font-style: italic; display: block; font-size: 10px; margin-top: 10px;'>By clicking the button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the <a href='https:\/\/www.accessrepairnrecovery.com\/eula.php' target='_blank'>End User License Agreement<\/a> and <a href='https:\/\/www.accessrepairnrecovery.com\/privacy-policy.php' target='_blank'>Privacy Policy<\/a> of this site.<\/span><\/div><\/div><\/div><\/div>\n<h2><strong>Why is The Need Of Merging Data In Access?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Merging data in Access helps you to make an effortless overview of a huge amount of data. Suppose you are getting input from different sources, like from entire account executive group. It&#8217;s easy to create a report from a single file, which can be done simply by using the copy and paste technique. But what if there are multiple records and tables are available? In that case, copying and pasting data from a huge number of rows and columns is just not enough.<\/p>\n<p style=\"text-align: justify;\">Thus, for such types of tasks <strong>merging Access tables<\/strong> is the best solution to go with.<\/p>\n<h2 style=\"text-align: left;\"><strong>How to Merge Tables In Access Database?<\/strong><\/h2>\n<h3 style=\"text-align: left;\"><strong>Method 1# <\/strong><strong>Merge Access Tables <\/strong><strong>Using the Append Method<\/strong><\/h3>\n<p style=\"text-align: justify;\">We all know the Access database mainly consists of tables. So if your database has two similar tables, then without going through the lengthy manual procedure, you can easily merge them by using the append query.<\/p>\n<p style=\"text-align: justify;\">Using this special append query command, you can easily perform the task of <strong>merging table data in Access.<\/strong><\/p>\n<p style=\"text-align: justify;\">Apart from this, you have the option to select the records which you need to copy from the source table and after that append them to the destination table.<\/p>\n<p style=\"text-align: justify;\"><strong>Step 1<\/strong><\/p>\n<ul>\n<li style=\"text-align: left;\">Open the Access database that contains the table which you need to merge into another one.<\/li>\n<li style=\"text-align: left;\">Make sure that the source and destination table data types are well compatible with each other.<\/li>\n<li style=\"text-align: left;\">Suppose, if your source table&#8217;s first field is a number, then it\u2019s compulsory for the destination field also to be in the number field.<\/li>\n<li style=\"text-align: left;\">According to Microsoft, text fields are well compatible with other field types. So if your source table has a number field and the destination table has a text field then no issue will arise.<\/li>\n<\/ul>\n<p><strong>Step 2<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\">Hit the &#8220;<strong>Create<\/strong>&#8221; button and then tap to the &#8220;<strong>Query Design<\/strong>\u201d. This will open the \u201c<strong>Show Table<\/strong>\u201d window here you will see all the database tables listed.<\/li>\n<li style=\"text-align: justify;\">Hit the table which contains the records you need to copy.<\/li>\n<li style=\"text-align: justify;\">Hit the \u201c<strong>add\u201d <\/strong>and then \u201c<strong>close\u201d<\/strong> option. Access database put the fields and table within the query designer.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Step 3<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\">At the top section of query design, there is an asterisk, you need to make a double click over it. Access will add all tables\u2019 fields within a grid of query design.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Step 4<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\">Hit the &#8220;Run&#8221; button to execute the query and also to view the table that has records in it.<\/li>\n<li style=\"text-align: justify;\">Hit the View&gt;Design View&gt; append option. This will open the Append window.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Step 5<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\">Make a hit over &#8220;Current Database&#8221;, if your destination table is present in the current database.<\/li>\n<li style=\"text-align: justify;\">After that hit the combo box of &#8220;Table Name&#8221;. Choose the table which you need to merge to the records of the source table.<\/li>\n<li style=\"text-align: justify;\">Or else, hit the &#8220;Another Database&#8221; option. After that assign the name and location of your Access database which is having the destination table.<\/li>\n<li style=\"text-align: justify;\">Enter the name of the table within the <strong>Table Name<\/strong> and click the <strong>ok<\/strong> button.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Step 6<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\">Make a right-click over the query design window. After that choose the <strong>&#8220;Datasheet View&#8221;<\/strong> for watching out the preview shown by the records which query will append.<\/li>\n<li style=\"text-align: justify;\">At the window\u2019s top make rights click and choose the &#8220;Design View&#8221; option.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Step 7<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\">Hit the <strong>View <\/strong>tab and then select the <strong>Data Sheet &gt; Run<\/strong> option.<\/li>\n<li style=\"text-align: justify;\">In the opened dialog box you are asked to press yes or no to append rows of the Access database from source to the destination table.<\/li>\n<li style=\"text-align: justify;\">Hit the<strong> yes<\/strong> button, to <strong>merge tables in Access.<\/strong><\/li>\n<\/ul>\n<h3 style=\"text-align: left;\"><strong>Method 2# Merge Access Tables Using Inner Join<\/strong><\/h3>\n<p style=\"text-align: justify;\">Another method to merge tables in Access is by using the inner join. Here is the complete step to perform this process of merging the Access database table using an inner join.<\/p>\n<p style=\"text-align: justify;\">Usually, an inner join is used to obtain entire records from linked tables. You will also see that a common value is present in both Access database tables.<\/p>\n<p style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Steps To Merge Tables In Access By Using The Inner Join Function<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><strong>Step 1: Create the Tables<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\">First of all, you need to make a table that you need to link in your Access database.<\/li>\n<li style=\"text-align: justify;\">Just like I have created here the two tables: one contains information about shipping and another is about the clients.<\/li>\n<li style=\"text-align: justify;\">Here is a screenshot of the client and shipping table.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66602\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-1.png\" alt=\"Merge Access Tables Using Inner Join 1\" width=\"382\" height=\"147\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-1.png 382w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-1-300x115.png 300w\" sizes=\"auto, (max-width: 382px) 100vw, 382px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66603\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-2.png\" alt=\"Merge Access Tables Using Inner Join 2\" width=\"343\" height=\"126\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-2.png 343w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-2-300x110.png 300w\" sizes=\"auto, (max-width: 343px) 100vw, 343px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">In the end, you need to link the shipping table with the client table using the <strong>Client ID<\/strong> field.\u00a0 This field should present in both tables.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Step 2: Link the Tables<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\">For linking Access database tables, at first, go to the <strong>create <\/strong>tab and then hit the<strong> Query Design<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66604\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-3.png\" alt=\"Merge Access Tables Using Inner Join 3\" width=\"481\" height=\"323\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-3.png 481w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-3-300x201.png 300w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">In the opened dialog box of \u201c<strong>show table<\/strong>\u201d make a double click on each client and shipping tables. After completing all this, hit the <strong>close<\/strong> option.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66605\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-4.png\" alt=\"Merge Access Tables Using Inner Join 4\" width=\"605\" height=\"557\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-4.png 605w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-4-300x276.png 300w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">Now you will see both table\u2019s respective fields will start appearing on your screen.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66606\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-5.png\" alt=\"Merge Access Tables Using Inner Join 5\" width=\"442\" height=\"245\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-5.png 442w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-5-300x166.png 300w\" sizes=\"auto, (max-width: 442px) 100vw, 442px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">From the client table you need to drag the \u2018Client ID\u2019 field. After that put it over the shipping table.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66607\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-6.png\" alt=\"Merge Access Tables Using Inner Join 6\" width=\"442\" height=\"245\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-6.png 442w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-6-300x166.png 300w\" sizes=\"auto, (max-width: 442px) 100vw, 442px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">This process will link the shipping and client table with one common field i.e. \u2018Client ID\u2019.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Step 3: Select The Fields To Display<\/strong><\/p>\n<p style=\"text-align: justify;\">Choose the field which you need to show from your linked tables. For this, you need to make a double click over desired fields of each table.<\/p>\n<p style=\"text-align: justify;\">Suppose, make a double-click over the following fields:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-style: inherit; font-weight: inherit;\">From the Clients\u00a0table choose the \u2018Client First Name\u2019 and the \u2018Client Last Name\u2019<\/li>\n<li style=\"font-style: inherit; font-weight: inherit;\">Now from the Shipping\u00a0table choose the \u2018Shipping Address\u2019<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66608\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-7.png\" alt=\"Merge Access Tables Using Inner Join 7\" width=\"771\" height=\"506\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-7.png 771w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-7-300x197.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-7-768x504.png 768w\" sizes=\"auto, (max-width: 771px) 100vw, 771px\" \/><\/p>\n<p style=\"text-align: justify;\">At last hit the <strong>run<\/strong> button<strong>, <\/strong>as this will display the result:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66609\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-8.png\" alt=\"Merge Access Tables Using Inner Join 8\" width=\"646\" height=\"384\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-8.png 646w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-8-300x178.png 300w\" sizes=\"auto, (max-width: 646px) 100vw, 646px\" \/><\/p>\n<p style=\"text-align: justify;\">Now this newly created merged table contains the 3 fields which we have selected from these two linked tables.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66610\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-9.png\" alt=\"Merge Access Tables Using Inner Join 9\" width=\"434\" height=\"129\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-9.png 434w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merge-Access-Tables-Using-Inner-Join-9-300x89.png 300w\" sizes=\"auto, (max-width: 434px) 100vw, 434px\" \/><\/p>\n<p style=\"text-align: justify;\">After that you will see that in your linked tables 3 fields start appearing. So this is how you can merge Access table data using inner join.<\/p>\n<h3 style=\"text-align: left;\"><strong>Method 3# Merge Access Table Using Left Joins<\/strong><\/h3>\n<p style=\"text-align: justify;\">For retrieving up the data, you just need to do several right or left joins. Here is an example to show you how it is to be done.<\/p>\n<p style=\"text-align: justify;\">I will mainly focus on how to achieve this query using the left joins.<\/p>\n<p style=\"text-align: justify;\">For this example, we will assume:<\/p>\n<p style=\"text-align: justify;\">First Table is of\u00a0 &#8220;Employees&#8221;<br \/>\nSecond Table is of\u00a0 &#8220;Orders&#8221;<br \/>\nThird Table is of \u00a0&#8220;Order Details&#8221;<\/p>\n<ul>\n<li style=\"text-align: justify;\">First of all, create one new query and then add all these 3 tables into the new query.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66591\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-1.png\" alt=\"Merage table in access using left join 1\" width=\"536\" height=\"301\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-1.png 536w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-1-300x168.png 300w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">Make a right-click over the <strong>\u201cjoin line&#8221; <\/strong>present in between the table of orders and employee. From the popup menu choose the <strong>\u201cjoin properties\u201d. <\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66592\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-2.png\" alt=\"Merage table in access using left join 2\" width=\"538\" height=\"303\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-2.png 538w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-2-300x169.png 300w\" sizes=\"auto, (max-width: 538px) 100vw, 538px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">From the opened window of <strong>\u201cJoin Properties\u201d<\/strong> you have to choose the second option and then hit the <strong>OK<\/strong> button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66593\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-3.png\" alt=\"Merage table in access using left join 3\" width=\"330\" height=\"326\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-3.png 330w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-3-300x296.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-3-65x65.png 65w\" sizes=\"auto, (max-width: 330px) 100vw, 330px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">In this way, your query will look like. You will see an arrow sign on the right-hand side of the join line present between the Orders and Employees table.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66594\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-4.png\" alt=\"Merage table in access using left join 4\" width=\"537\" height=\"301\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-4.png 537w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-4-300x168.png 300w\" sizes=\"auto, (max-width: 537px) 100vw, 537px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">After that make a right-click over the join line present between the order detail and order table. Now from the popup menu choose the <strong>\u201cjoin properties\u201d<\/strong> option.<\/li>\n<li style=\"text-align: justify;\">From the opened <strong>Properties <\/strong>window you have to select the\u00a0<strong>second<\/strong>\u00a0option and tap to the <strong>OK <\/strong>button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66595\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-5.png\" alt=\"Merage table in access using left join 5\" width=\"330\" height=\"326\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-5.png 330w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-5-300x296.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-5-65x65.png 65w\" sizes=\"auto, (max-width: 330px) 100vw, 330px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">Choose the fields which you need to show in the query results. I have selected the following fields:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66596\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-6.png\" alt=\"Merage table in access using left join 6\" width=\"537\" height=\"302\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-6.png 537w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-6-300x169.png 300w\" sizes=\"auto, (max-width: 537px) 100vw, 537px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">So when the query is been executed, you can see the blank values present within the Quantity\u00a0fields. And Order Date.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-66597\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-7.png\" alt=\"Merage table in access using left join 7\" width=\"453\" height=\"302\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-7.png 453w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/Merage-table-in-access-using-left-join-7-300x200.png 300w\" sizes=\"auto, (max-width: 453px) 100vw, 453px\" \/><\/p>\n<p style=\"text-align: justify;\">This happens because actually there is no matching records available in corresponding tables which mainly uses the join criteria.<\/p>\n<h2 style=\"text-align: left;\"><strong>Frequently Asked Questions:<\/strong><\/h2>\n<h4 style=\"text-align: left;\"><strong>Can I Merge Two Tables in Access?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Yes, you can definitely combine two tables in an Access database, even if you have not created relationships. MS Access creates inner joins automatically if you add 2 tables to a query &amp; those tables each have a field with the same or compatible data type, and one of the join fields is a primary key.<\/p>\n<h3><strong>How to Join Two Tables in a Database?<\/strong><\/h3>\n<p>If you want to join two tables in a database, you can use the following syntax:<\/p>\n<p><strong>SELECT * FROM table_1 JOIN table_2 USING (id);<\/strong><\/p>\n<h4 style=\"text-align: left;\"><strong>Which Key Combines Two Database Tables?<\/strong><\/h4>\n<p>Composite Key combines two database tables.<\/p>\n<h4 style=\"text-align: left;\"><strong>How to Append Tables in Access?<\/strong><\/h4>\n<p>To append tables in Access, follow the steps below:<\/p>\n<ul>\n<li>Navigate to <strong>Home<\/strong> tab, click on View group &gt;&gt; and click View.<\/li>\n<li>After that, click on <strong>Design View<\/strong>.<\/li>\n<li>On the <strong>Query Design<\/strong> tab, in the Query Type group, click <strong>Append<\/strong>.<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>Final Thoughts<\/strong><\/h2>\n<p style=\"text-align: justify;\">Merging tables in Access is quick and effective. Use Append or Make Table queries for permanent changes. Always test before making major changes. With these steps, your database stays efficient and accurate.<\/p>\n<p style=\"text-align: justify;\">But what if you lost your database data? In such a situation, you can try the <a href=\"https:\/\/www.accessrepairnrecovery.com\/download-access-repair.php\"><strong>Access Database Recovery Tool<\/strong><\/a>. With this professional tool, you can easily recover all your lost Access database data. Apart from this, if your data is lost due to the occurrence of a corruption issue in the table, then this tool also works very efficiently.<\/p>\n<blockquote><p><strong>References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/how-to-merge-two-access-database-tables-in\/3d074f3d-0762-4a51-8292-67a865e48849\" target=\"_blank\" rel=\"noopener\">https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/how-to-merge-two-access-database-tables-in\/3d074f3d-0762-4a51-8292-67a865e48849<\/a><\/li>\n<\/ul>\n<\/blockquote>\n<p style=\"text-align: justify;\"><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>Want to know how to merge tables in Access database? Combining the data from the databases in Access helps you &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"MS Access Merge Tables- How to Merge Tables In Access?\" class=\"read-more button\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#more-66589\" aria-label=\"Read more about MS Access Merge Tables- How to Merge Tables In Access?\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":66599,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[1517,1514,1515],"class_list":["post-66589","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial","tag-merge-access-table-using-left-joins","tag-merge-table-in-access-using-inner-join","tag-merging-tables-in-access-database","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>MS Access Merge Tables- How to Merge Tables In Access?<\/title>\n<meta name=\"description\" content=\"Read this exclusive guide and learn how to merge tables in Access database with 3 effective methods, keep your database organized.\" \/>\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\/merge-tables-in-access\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MS Access Merge Tables- How to Merge Tables In Access?\" \/>\n<meta property=\"og:description\" content=\"Read this exclusive guide and learn how to merge tables in Access database with 3 effective methods, keep your database organized.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access\" \/>\n<meta property=\"og:site_name\" content=\"MS Access Repair And Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-23T12:27:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-27T19:35:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Merge-Tables-In-Access-Database.png\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"540\" \/>\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=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access\"},\"author\":{\"name\":\"Pearson Willey\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\"},\"headline\":\"MS Access Merge Tables- How to Merge Tables In Access?\",\"datePublished\":\"2025-05-23T12:27:42+00:00\",\"dateModified\":\"2025-05-27T19:35:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access\"},\"wordCount\":1583,\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Merge-Tables-In-Access-Database.png\",\"keywords\":[\"Merge Access Table Using Left Joins\",\"merge table in Access using inner join\",\"merging tables in Access database\"],\"articleSection\":[\"Tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access\",\"name\":\"MS Access Merge Tables- How to Merge Tables In Access?\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Merge-Tables-In-Access-Database.png\",\"datePublished\":\"2025-05-23T12:27:42+00:00\",\"dateModified\":\"2025-05-27T19:35:37+00:00\",\"description\":\"Read this exclusive guide and learn how to merge tables in Access database with 3 effective methods, keep your database organized.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#primaryimage\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Merge-Tables-In-Access-Database.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Merge-Tables-In-Access-Database.png\",\"width\":960,\"height\":540,\"caption\":\"3 Ways To Merge Tables In Access Database\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MS Access Merge Tables- How to Merge Tables In Access?\"}]},{\"@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":"MS Access Merge Tables- How to Merge Tables In Access?","description":"Read this exclusive guide and learn how to merge tables in Access database with 3 effective methods, keep your database organized.","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\/merge-tables-in-access","og_locale":"en_US","og_type":"article","og_title":"MS Access Merge Tables- How to Merge Tables In Access?","og_description":"Read this exclusive guide and learn how to merge tables in Access database with 3 effective methods, keep your database organized.","og_url":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access","og_site_name":"MS Access Repair And Recovery Blog","article_published_time":"2025-05-23T12:27:42+00:00","article_modified_time":"2025-05-27T19:35:37+00:00","og_image":[{"width":960,"height":540,"url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Merge-Tables-In-Access-Database.png","type":"image\/png"}],"author":"Pearson Willey","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Pearson Willey","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#article","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access"},"author":{"name":"Pearson Willey","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb"},"headline":"MS Access Merge Tables- How to Merge Tables In Access?","datePublished":"2025-05-23T12:27:42+00:00","dateModified":"2025-05-27T19:35:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access"},"wordCount":1583,"publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Merge-Tables-In-Access-Database.png","keywords":["Merge Access Table Using Left Joins","merge table in Access using inner join","merging tables in Access database"],"articleSection":["Tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access","name":"MS Access Merge Tables- How to Merge Tables In Access?","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#primaryimage"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Merge-Tables-In-Access-Database.png","datePublished":"2025-05-23T12:27:42+00:00","dateModified":"2025-05-27T19:35:37+00:00","description":"Read this exclusive guide and learn how to merge tables in Access database with 3 effective methods, keep your database organized.","breadcrumb":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#primaryimage","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Merge-Tables-In-Access-Database.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Merge-Tables-In-Access-Database.png","width":960,"height":540,"caption":"3 Ways To Merge Tables In Access Database"},{"@type":"BreadcrumbList","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/merge-tables-in-access#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.accessrepairnrecovery.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MS Access Merge Tables- How to Merge Tables In Access?"}]},{"@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\/66589","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=66589"}],"version-history":[{"count":4,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/66589\/revisions"}],"predecessor-version":[{"id":69049,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/66589\/revisions\/69049"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media\/66599"}],"wp:attachment":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media?parent=66589"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/categories?post=66589"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/tags?post=66589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}