{"id":64146,"date":"2025-08-05T11:50:50","date_gmt":"2025-08-05T11:50:50","guid":{"rendered":"http:\/\/www.accessrepairnrecovery.com\/blog\/?p=64146"},"modified":"2025-08-07T08:31:22","modified_gmt":"2025-08-07T08:31:22","slug":"complete-information-about-ms-access-pivot-table","status":"publish","type":"post","link":"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table","title":{"rendered":"How to Create MS Access Pivot Table in 2016\/2019?"},"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;\">In Microsoft Access, PivotTables simplify the large data sets. You can distinguish trends, compare values, and identify outliers. A pivot table allows you to summarize and analyze complex data. It transforms raw records into meaningful insights by organizing data into rows and columns with calculated values. However, it is important to know <strong>how to create MS Access pivot table<\/strong> before using it in the database.<\/p>\n<p style=\"text-align: justify;\"><!--more--><\/p>\n<p>So, let\u2019s scroll down this page to know complete info regarding PivotTables.<\/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 style=\"text-align: justify;\"><strong><span style=\"color: #000000;\">What is MS Access PivotTable?<\/span><\/strong><\/h2>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">In MS Access, the <strong>Pivot table<\/strong> is a programming tool that provides you the option to recognize and summarize selected columns and rows of data in a spreadsheet or database table to get the desired report. The<strong> Pivot\u00a0table in Access<\/strong> doesn\u2019t actually change the spreadsheet or database itself.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">You can use the <strong>Access pivot table<\/strong> to make a list of unique values because it summarizes data that can be used to find unique values in a field. It\u2019s a good way to take a quick overview of all the values appearing in the field and other inconsistencies.<\/span><\/p>\n<p>Have a look over the <strong>Access pivot table<\/strong> screenshot:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65421\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/maxresdefault-1.jpg\" alt=\"What is MS Access PivotTable\" width=\"1280\" height=\"720\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/maxresdefault-1.jpg 1280w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/maxresdefault-1-300x169.jpg 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/maxresdefault-1-768x432.jpg 768w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/maxresdefault-1-1024x576.jpg 1024w\" sizes=\"auto, (max-width: 1280px) 100vw, 1280px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">Apart from this, you can also make use of the <strong>Access PivotTable<\/strong> and <strong>PivotChart views<\/strong> to perform interactive data analysis or create dynamic, interactive charts.<\/span><\/p>\n<blockquote><p><strong>Also Read: <\/strong><strong><a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/unhide-hidden-objects-in-access\">How to Unhide Hidden Objects in Access Database? \u2013 (2025 Guide)<\/a><\/strong><\/p><\/blockquote>\n<h2 style=\"text-align: left;\"><strong><span style=\"color: #000000;\">How To Create MS Access Pivot Table?<\/span><\/strong><\/h2>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">In order to make a PivotTable or PivotChart view for Access queries, forms, or tables. Here is <strong>how to create a PivotTable view<\/strong> and a PivotChart view for an Access Query.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><strong><span style=\"color: #000000;\">Step 1: Create a query<\/span><\/strong><\/h3>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">If you do not have a query to use for PivotTable view, then create a new one. To know how this is to be done, you can check out the post regarding Access Query Designing.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><strong><span style=\"color: #000000;\">Step 2: Open up your query in the PivotTable view<\/span><\/strong><\/h3>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">Once the query has been created, try out the following steps to open the query in PivotTable view.<\/span><\/p>\n<ol style=\"text-align: justify;\">\n<li><span style=\"color: #000000;\">Go to the Navigation Pane and make a double-tap to the query.<\/span><\/li>\n<li><span style=\"color: #000000;\">Now from the <strong>Home\u00a0<\/strong>tab, go into the <strong>Views<\/strong> group and tap the <strong>View<\/strong> option. After then hit the <strong>PivotTable View<\/strong>.<\/span><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-69107 aligncenter\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/getting_started_ribbon_more.png\" alt=\"PivotTable View\" width=\"521\" height=\"324\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">This will open the PivotTable view without having any data or fields.<\/span><\/p>\n<h3 style=\"text-align: left;\"><strong><span style=\"color: #000000;\">Step 3: Within PivotTable View <\/span><\/strong><strong><span style=\"color: #000000;\">Add Data Fields <\/span><\/strong><\/h3>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">Now add some fields, which make up the columns and row headings of PivotTable view. Also, enter the detail &amp; filter fields. For this, it&#8217;s important to have clear visibility of the Field List.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"color: #000000;\">If in case, field list not appearing clear to you then go to the <strong>Design <\/strong>tab and choose the <strong>Show\/Hide<\/strong> group after then hit on the <strong>Field List <\/strong>option.<\/span><\/li>\n<\/ul>\n<h4 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Add column fields:<\/span><\/span><\/strong><\/h4>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">To add a column field:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"color: #000000;\">At first drag the field present in the Field List in the PivotTable area which is marked by <strong>Drop Column Fields Here<\/strong>.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">Or else, you can just add a filter field through the following steps:<\/span><\/p>\n<ol style=\"text-align: justify;\">\n<li><span style=\"color: #000000;\">Choose a field from <strong>Field List.<\/strong><\/span><\/li>\n<li><span style=\"color: #000000;\">From the bottom section of the <strong>Field List<\/strong>, choose the <strong>Column Area <\/strong>option from the drop-down list. After then hit the <strong>Add to <\/strong>option.<\/span><\/li>\n<\/ol>\n<h4 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Add row fields:<\/span><\/span><\/strong><\/h4>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">Row fields are one that makes up the rows of the <strong>Pivot Table in Access.<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">Steps to add a row field:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"color: #000000;\">At first drag the field present in the Field List in the PivotTable area which is marked by <strong>Drop Row Fields Here<\/strong>.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">Apart from that, you can just add a filter field through the following steps:<\/span><\/p>\n<ol style=\"text-align: justify;\">\n<li><span style=\"color: #000000;\">Make a selection for the fields from Field List.<\/span><\/li>\n<li><span style=\"color: #000000;\">From the bottom section of the Field List, choose <strong>Row Area <\/strong>option from the drop-down list. After then hit the <strong>Add to <\/strong>option.<\/span><\/li>\n<\/ol>\n<h3 style=\"text-align: left;\"><strong><span style=\"color: #000000;\">Step 4: Make Changes In Field Captions &amp; Format Data<\/span><\/strong><\/h3>\n<ul>\n<li><span style=\"color: #000000;\">Now in the pivot table, just choose the label for the field which you need to change.<\/span><\/li>\n<li><span style=\"color: #000000;\">From the <strong>Design <\/strong>tab, get into the<strong>\u00a0Tools<\/strong> group. After then hit on the <strong>Properties <\/strong>option.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-68009 aligncenter\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2023\/08\/access-image91.png\" alt=\"field properties\" width=\"355\" height=\"242\" \/><\/p>\n<ul>\n<li><span style=\"color: #000000;\">In the dialog box of <strong>Properties<\/strong>, click on the <strong>Captions <\/strong>option<strong>.<\/strong><\/span><\/li>\n<li><span style=\"color: #000000;\">Within the opened <strong>Caption\u00a0<\/strong>box, just write the caption which you want. After that press the <strong>ENTER <\/strong>button.<\/span><\/li>\n<li><span style=\"color: #000000;\">You can also apply different formatting options for your caption.<\/span><\/li>\n<li><span style=\"color: #000000;\">now in the same <strong>Properties<\/strong> dialog box, you need to tap the <strong>Format tab.<\/strong><\/span><\/li>\n<li><span style=\"color: #000000;\">Make use of the command on the format tab for sorting the data. Also, to format cells and text.<\/span><\/li>\n<li><span style=\"color: #000000;\">If your PivotTable has total rows, then click the <strong>Hide Details\u00a0<\/strong>option from the <strong>Design<\/strong> tab. This will hide all detail fields and only display the total fields.<\/span><\/li>\n<li><span style=\"color: #000000;\">Repeat steps 3 to 7 for setting up the format and captions for complete fields.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><strong><span style=\"color: #000000;\">Step 5: Filter, Sort, &amp; Group Data<\/span><\/strong><\/h3>\n<ul style=\"text-align: justify;\">\n<li><span style=\"color: #000000;\">To filter the data, hit the down arrow present next to the field name. After that either choose or put a checkmark over the filtering option that you require.<\/span><\/li>\n<li><span style=\"color: #000000;\">For grouping the data:<\/span>\n<ol>\n<li><span style=\"color: #000000;\">In your PivotTable, tap on the values that you require for grouping.<\/span><\/li>\n<li><span style=\"color: #000000;\">After that, make a right-click on any one of the chosen values. After that, tap on the <strong>Group Items <\/strong>option.\u00a0<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">After the addition of the grouping level, you need to choose the group. And then make use of the <strong>Collapse Field<\/strong> and <strong>Expand Field<\/strong> commands from the design tab to hide or view each field in a group.<\/span><\/p>\n<blockquote><p><strong>Also Read: <\/strong><strong><a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/make-access-database-executable\">How to Make MS Access Database Executable?- 2025 Guide<\/a><\/strong><\/p><\/blockquote>\n<h2 style=\"text-align: left;\"><span style=\"color: #000000;\"><strong>What Issues Encountered While Working With The Access Pivot Table?<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">While working with the <strong>Access pivot table<\/strong> most commonly encountered issues with which users usually get stuck off are :<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li><span style=\"color: #000000;\">Access Pivot Table View Missing or<\/span><\/li>\n<li><span style=\"color: #000000;\">PivotTable and Chart controls don&#8217;t work<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\"><span style=\"color: #000000; text-decoration: underline;\">Symptoms<\/span><\/span><\/strong><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">Well, the &#8220;PivotTable and Chart controls don&#8217;t work&#8221; error can be encountered on any MS Access 2003\/2007\/2010 application. At that time it throws the following error message.<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\"><span style=\"color: #000000;\"><strong>Your Microsoft Office Access database or project contains a missing or broken reference to the file &#8216;0WC10.DLL&#8217; version 1.0.<\/strong><\/span><\/li>\n<li style=\"text-align: left;\"><span style=\"color: #000000;\"><strong>Your Microsoft Office Access database or project contains a missing or broken reference to the file &#8216;0WC11.DLL&#8217; version 1.0.<\/strong><\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">Even after the appearance of such an error, you can open your Access 2007 database file, but any of the PivotTable controls or Microsoft Office Chart controls contained on the form, report, or data access page don\u2019t work. \u00a0Along with that, the Access display message <strong>&#8220;There is no object in this control&#8221;<\/strong> each time you try to open an object that contains a PivotTable control or a Chart control.<\/span><\/p>\n<h2 style=\"text-align: left;\"><strong><span style=\"color: #000000;\">Resolution To Fix MS Access PivotTable Controls Not Working Issue<\/span><\/strong><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-65420\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/computer-service-icon-vector-7399875.jpg\" alt=\"Fix MS Access PivotTable Controls Not Working Issue\" width=\"308\" height=\"270\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/computer-service-icon-vector-7399875.jpg 1000w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/computer-service-icon-vector-7399875-300x263.jpg 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/computer-service-icon-vector-7399875-768x673.jpg 768w\" sizes=\"auto, (max-width: 308px) 100vw, 308px\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\">In order to make an Access 2007 application to shows your previous version PivotTable controls and PivotChart controls correctly. You need to download and install the right .dll file first. Make use of the following procedure to find out the missing reference file and then download and install those files.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong><span style=\"color: #000000; text-decoration: underline;\">Determine which reference is missing<\/span><\/strong><\/span><\/h3>\n<ol style=\"text-align: justify;\">\n<li style=\"text-align: left;\"><span style=\"color: #000000;\">First of all, open your Access Database 2007.<\/span><\/li>\n<li style=\"text-align: left;\"><span style=\"color: #000000;\">Perform the following steps to open the Visual Basic Editor:<\/span>\n<ul>\n<li><span style=\"color: #000000;\">Now, open an existing module by double-clicking it in the <strong>Navigation Pane<\/strong>.<\/span><\/li>\n<li><span style=\"color: #000000;\">On the\u00a0<strong>Create <\/strong>tab, in the\u00a0<strong>Other<\/strong> group, tap the\u00a0<strong>Module <\/strong>option. If you are unable to find this command then tap to the arrow beneath either the\u00a0<strong>Macro<\/strong>\u00a0or the\u00a0<strong>Class Module<\/strong>\u00a0button, and then hit the\u00a0<strong>Module <\/strong>option.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"text-align: left;\"><span style=\"color: #000000;\">In the <strong>Visual Basic Editor<\/strong>, go to the\u00a0<strong>Tools\u00a0<\/strong>menu, and tap the <strong>References<\/strong>.<\/span><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-67986 aligncenter\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2020\/10\/go-to-tools-to-select-references.png\" alt=\"Check for Missing References\" width=\"462\" height=\"171\" \/><\/p>\n<p><span style=\"color: #000000;\">4. In the reference dialog box, within the <strong>Available References<\/strong>, search for the references which are marked as\u00a0<strong>MISSING<\/strong>.<\/span><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"text-align: left;\"><span style=\"color: #000000;\">If version 10.0 or version 11.0 of the MS Office Web Component is missing, follow the steps to download and install the required .dll file.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3 style=\"text-align: left;\"><span style=\"color: #000000;\"><strong>Steps to Download and install the required file<\/strong><\/span><\/h3>\n<ol style=\"text-align: justify;\">\n<li style=\"text-align: left;\"><span style=\"color: #000000;\">First of all, search for the Microsoft Download Center for <strong>exe <\/strong>or\u00a0<strong>owc11.exe<\/strong>, depending on the version that you have to find through the above-mentioned <strong>reference missing section.<\/strong><\/span><\/li>\n<li style=\"text-align: left;\"><span style=\"color: #000000;\">After that, follow the instructions as guided in the Download Center to download and install the file properly.<\/span><\/li>\n<\/ol>\n<p style=\"text-align: left;\"><span style=\"color: #000000;\">Note: either you can save the .exe file and then run it to install the .dll file, or you can make a shortcut to <strong>Run <\/strong>option to install the .dll file directly from the Download Center.<\/span><\/p>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li style=\"text-align: left;\"><span style=\"color: #000000;\">After the complete installation. Just tap on the <strong>Close<\/strong> and then reopen your Access database application to make sure that the Access database controls were working as expected.<\/span><\/li>\n<\/ol>\n<h2 style=\"text-align: left;\"><strong>Frequently Asked Questions:<\/strong><\/h2>\n<h4 style=\"text-align: left;\"><strong>How Do I Add a PivotTable to the Quick Access Toolbar?<\/strong><\/h4>\n<p style=\"text-align: justify;\">To add a PivotTable in Access, right-click anywhere on the Quick Access Toolbar. On a shortcut menu, you have to click on the Customize Quick Access Toolbar. Under the opened dialog box, click on the down arrow in the Choose commands from field, and from the list, select <strong>Add PivotTable<\/strong>.<\/p>\n<h4 style=\"text-align: left;\"><strong>How to Link PivotTable to Access Database?<\/strong><\/h4>\n<p style=\"text-align: justify;\">To link PivotTable to an Access database, follow the steps below:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Click on the Data tab &gt; From Access.<\/li>\n<li>Under the Select Data Source dialog box, find the Access database that you need to connect to, and click Open.<\/li>\n<li>Now, under the Select Table dialog box, choose the table you need &gt;&gt; click OK.<\/li>\n<\/ul>\n<h4 style=\"text-align: left;\"><strong>How To Enable Power Pivot in Office 365?<\/strong><\/h4>\n<p style=\"text-align: justify;\">To enable Power Pivot in Office 365, follow the steps below:<\/p>\n<ol>\n<li style=\"text-align: justify;\">Go to the <strong>File<\/strong> tab &gt; <strong>Options<\/strong> &gt; <strong>Add-Ins.<\/strong><\/li>\n<li style=\"text-align: justify;\">In the <strong>Manage box<\/strong>, click on the COM Add-ins &gt; <strong>Go<\/strong>.<\/li>\n<li style=\"text-align: justify;\">Check the Microsoft Office Power Pivot box, and then click OK.<\/li>\n<\/ol>\n<h2 style=\"text-align: left;\"><strong>Final Thoughts<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>Creating pivot tables in Microsoft Access<\/strong> is a straightforward process once you follow the correct steps mentioned above in this post. It boosts data analysis inside your database environment. Use it to create reports, dashboards, and data insights fast and efficiently.<\/p>\n<p style=\"text-align: justify;\">I hope you enjoyed reading this post on how to create MS Access Pivot Table.<\/p>\n<p><strong>References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-pivottable-or-pivotchart-views-in-an-access-desktop-database-83e524df-dfbd-456d-9dd0-0a48c1aa6752\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/create-pivottable-or-pivotchart-views-in-an-access-desktop-database-83e524df-dfbd-456d-9dd0-0a48c1aa6752<\/a><\/li>\n<\/ul>\n<p><span style=\"color: #000000;\"><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><\/span><\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>In Microsoft Access, PivotTables simplify the large data sets. You can distinguish trends, compare values, and identify outliers. A pivot &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Create MS Access Pivot Table in 2016\/2019?\" class=\"read-more button\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table#more-64146\" aria-label=\"Read more about How to Create MS Access Pivot Table in 2016\/2019?\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":66049,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[2005,2006],"class_list":["post-64146","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial","tag-how-to-create-ms-access-pivot-table","tag-how-to-create-pivot-table-in-ms-access","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Create MS Access Pivot Table in 2016\/2019?<\/title>\n<meta name=\"description\" content=\"Catch complete detail on how to create MS Access Pivot Table. Also, learn the precautionary tips to be taken to avoid duplicate tables in Access database.\" \/>\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\/complete-information-about-ms-access-pivot-table\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create MS Access Pivot Table in 2016\/2019?\" \/>\n<meta property=\"og:description\" content=\"Catch complete detail on how to create MS Access Pivot Table. Also, learn the precautionary tips to be taken to avoid duplicate tables in Access database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table\" \/>\n<meta property=\"og:site_name\" content=\"MS Access Repair And Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-05T11:50:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-07T08:31:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/how-to-create-ms-access-pivot-tbale.jpg\" \/>\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\/jpeg\" \/>\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\\\/complete-information-about-ms-access-pivot-table#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/complete-information-about-ms-access-pivot-table\"},\"author\":{\"name\":\"Pearson Willey\",\"@id\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/#\\\/schema\\\/person\\\/9e865a2660c466b5b9c3a485e05f8ecb\"},\"headline\":\"How to Create MS Access Pivot Table in 2016\\\/2019?\",\"datePublished\":\"2025-08-05T11:50:50+00:00\",\"dateModified\":\"2025-08-07T08:31:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/complete-information-about-ms-access-pivot-table\"},\"wordCount\":1631,\"publisher\":{\"@id\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/complete-information-about-ms-access-pivot-table#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/how-to-create-ms-access-pivot-tbale.jpg\",\"keywords\":[\"how to create MS Access pivot table\",\"how to create pivot table in MS Access\"],\"articleSection\":[\"Tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/complete-information-about-ms-access-pivot-table\",\"url\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/complete-information-about-ms-access-pivot-table\",\"name\":\"How to Create MS Access Pivot Table in 2016\\\/2019?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/complete-information-about-ms-access-pivot-table#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/complete-information-about-ms-access-pivot-table#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/how-to-create-ms-access-pivot-tbale.jpg\",\"datePublished\":\"2025-08-05T11:50:50+00:00\",\"dateModified\":\"2025-08-07T08:31:22+00:00\",\"description\":\"Catch complete detail on how to create MS Access Pivot Table. Also, learn the precautionary tips to be taken to avoid duplicate tables in Access database.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/complete-information-about-ms-access-pivot-table#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/complete-information-about-ms-access-pivot-table\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/complete-information-about-ms-access-pivot-table#primaryimage\",\"url\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/how-to-create-ms-access-pivot-tbale.jpg\",\"contentUrl\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/how-to-create-ms-access-pivot-tbale.jpg\",\"width\":960,\"height\":540,\"caption\":\"How To Create Pivot Table In MS Access\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/complete-information-about-ms-access-pivot-table#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.accessrepairnrecovery.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create MS Access Pivot Table in 2016\\\/2019?\"}]},{\"@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:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"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":"How to Create MS Access Pivot Table in 2016\/2019?","description":"Catch complete detail on how to create MS Access Pivot Table. Also, learn the precautionary tips to be taken to avoid duplicate tables in Access database.","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\/complete-information-about-ms-access-pivot-table","og_locale":"en_US","og_type":"article","og_title":"How to Create MS Access Pivot Table in 2016\/2019?","og_description":"Catch complete detail on how to create MS Access Pivot Table. Also, learn the precautionary tips to be taken to avoid duplicate tables in Access database.","og_url":"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table","og_site_name":"MS Access Repair And Recovery Blog","article_published_time":"2025-08-05T11:50:50+00:00","article_modified_time":"2025-08-07T08:31:22+00:00","og_image":[{"width":960,"height":540,"url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/how-to-create-ms-access-pivot-tbale.jpg","type":"image\/jpeg"}],"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\/complete-information-about-ms-access-pivot-table#article","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table"},"author":{"name":"Pearson Willey","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb"},"headline":"How to Create MS Access Pivot Table in 2016\/2019?","datePublished":"2025-08-05T11:50:50+00:00","dateModified":"2025-08-07T08:31:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table"},"wordCount":1631,"publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/how-to-create-ms-access-pivot-tbale.jpg","keywords":["how to create MS Access pivot table","how to create pivot table in MS Access"],"articleSection":["Tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table","name":"How to Create MS Access Pivot Table in 2016\/2019?","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table#primaryimage"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/how-to-create-ms-access-pivot-tbale.jpg","datePublished":"2025-08-05T11:50:50+00:00","dateModified":"2025-08-07T08:31:22+00:00","description":"Catch complete detail on how to create MS Access Pivot Table. Also, learn the precautionary tips to be taken to avoid duplicate tables in Access database.","breadcrumb":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table#primaryimage","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/how-to-create-ms-access-pivot-tbale.jpg","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2018\/08\/how-to-create-ms-access-pivot-tbale.jpg","width":960,"height":540,"caption":"How To Create Pivot Table In MS Access"},{"@type":"BreadcrumbList","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.accessrepairnrecovery.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Create MS Access Pivot Table in 2016\/2019?"}]},{"@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:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","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\/64146","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=64146"}],"version-history":[{"count":5,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/64146\/revisions"}],"predecessor-version":[{"id":69111,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/64146\/revisions\/69111"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media\/66049"}],"wp:attachment":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media?parent=64146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/categories?post=64146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/tags?post=64146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}