{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2016-03-27T16:49:50+00:00","modifiedTime":"2016-03-27T16:49:50+00:00","timestamp":"2022-09-14T18:13:47+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Access","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33643"},"slug":"access","categoryId":33643}],"title":"Access 2013 All-In-One For Dummies Cheat Sheet","strippedTitle":"access 2013 all-in-one for dummies cheat sheet","slug":"access-2013-all-in-one-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Access 2013 makes managing your data easy, combining a visual interface with the power of a relational database. Discover how to organize data into tables, desi","noIndex":0,"noFollow":0},"content":"<p>Access 2013 makes managing your data easy, combining a visual interface with the power of a relational database. Discover how to organize data into tables, design forms and reports for editing and presenting information, and create queries for selecting and combining information. The next steps are writing macros and Visual Basic for Applications (VBA) scripts to make your database smart, and using SharePoint to publish data to the web.</p>\n","description":"<p>Access 2013 makes managing your data easy, combining a visual interface with the power of a relational database. Discover how to organize data into tables, design forms and reports for editing and presenting information, and create queries for selecting and combining information. The next steps are writing macros and Visual Basic for Applications (VBA) scripts to make your database smart, and using SharePoint to publish data to the web.</p>\n","blurb":"","authors":[{"authorId":9788,"name":"Alison Barrows","slug":"alison-barrows","description":" <p><b>Alison Barrows</b> is the author or coauthor of several books about Access, Windows, and the Internet. Joseph Stockman is an 18-year software designer who has authored or coauthored five Access programming books. Allen Taylor is a 30-year veteran of the computer industry and the author of over 20 books.</p>","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9788"}},{"authorId":9789,"name":"Joseph C. Stockman","slug":"joseph-c-stockman","description":" <p><b>Alison Barrows</b> is the author or coauthor of several books about Access, Windows, and the Internet. Joseph Stockman is an 18-year software designer who has authored or coauthored five Access programming books. Allen Taylor is a 30-year veteran of the computer industry and the author of over 20 books.</p>","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9789"}},{"authorId":9559,"name":"Allen G. Taylor","slug":"allen-g-taylor","description":" <p><b>Allen G. Taylor</b> is a 30-year veteran of the computer industry and the author of over 40 books, including <b><i>SQL For Dummies</i></b> and <i>Crystal Reports For Dummies.</i> He lectures nationally on databases, innovation, and entrepreneurship. He also teaches database development internationally through a leading online education provider. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9559"}}],"primaryCategoryTaxonomy":{"categoryId":33643,"title":"Access","slug":"access","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33643"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":[{"articleId":172026,"title":"Repurposing Items for Beautiful Holiday Decorating","slug":"decorating-for-the-holidays-with-what-you-already-have","categoryList":["home-auto-hobbies","crafts","gifts-holidays"],"_links":{"self":"/articles/172026"}},{"articleId":192609,"title":"How to Pray the Rosary: A Comprehensive Guide","slug":"how-to-pray-the-rosary","categoryList":["body-mind-spirit","religion-spirituality","christianity","catholicism"],"_links":{"self":"/articles/192609"}},{"articleId":193770,"title":"How to Play Rummy: All You Need to Know","slug":"rummy-understanding-the-rules-and-starting-a-game","categoryList":["home-auto-hobbies","games","card-games","general-card-games"],"_links":{"self":"/articles/193770"}},{"articleId":153792,"title":"Format Numbers in Thousands and Millions in Excel Reports","slug":"format-numbers-in-thousands-and-millions-in-excel-reports","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"/articles/153792"}},{"articleId":147241,"title":"How to Use the Z-Table","slug":"how-to-use-the-z-table","categoryList":["academics-the-arts","math","statistics"],"_links":{"self":"/articles/147241"}}],"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":170082,"title":"Finding Alternatives to Access Data Projects","slug":"finding-alternatives-to-access-data-projects","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/170082"}},{"articleId":170081,"title":"How to Create a New Access 2013 Form","slug":"how-to-create-a-new-access-2013-form","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/170081"}},{"articleId":170080,"title":"How to Keep Blank Pages Out of Your Access 2013 Report","slug":"how-to-keep-blank-pages-out-of-your-access-2013-report","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/170080"}},{"articleId":170079,"title":"How to Filter Multiple Fields in Access 2013","slug":"how-to-filter-multiple-fields-in-access-2013","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/170079"}},{"articleId":170078,"title":"Getting Help with Functions in Access 2013","slug":"getting-help-with-functions-in-access-2013","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/170078"}}],"fromCategory":[{"articleId":258112,"title":"Field Types and Uses in Access 2019 Databases","slug":"field-types-and-uses-in-access-2019-databases","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258112"}},{"articleId":258108,"title":"How to Use Access 2019 ScreenTips","slug":"how-to-use-access-2019-screentips","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258108"}},{"articleId":258103,"title":"How to Work with Onscreen Tools in Access 2019","slug":"how-to-work-with-onscreen-tools-in-access-2019","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258103"}},{"articleId":258100,"title":"How to Navigate the Access 2019 Opening Workspace","slug":"how-to-navigate-the-access-2019-opening-workspace","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258100"}},{"articleId":258096,"title":"How Access 2019 Works and How You Work with It","slug":"how-access-2019-works-and-how-you-work-with-it","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/258096"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281614,"slug":"access-2013-all-in-one-for-dummies","isbn":"9781118510551","categoryList":["technology","software","microsoft-products","access"],"amazon":{"default":"https://www.amazon.com/gp/product/1118510550/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1118510550/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1118510550-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1118510550/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1118510550/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/access-2013-all-in-one-for-dummies-cover-9781118510551-201x255.jpg","width":201,"height":255},"title":"Access 2013 All-in-One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9788\">Alison Barrows</b> is the author or coauthor of several books about Access, Windows, and the Internet. Joseph Stockman is an 18-year software designer who has authored or coauthored five Access programming books. Allen Taylor is a 30-year veteran of the computer industry and the author of over 20 books.</p>","authors":[{"authorId":9789,"name":"Joseph C. Stockman","slug":"joseph-c-stockman","description":" <p><b>Alison Barrows</b> is the author or coauthor of several books about Access, Windows, and the Internet. Joseph Stockman is an 18-year software designer who has authored or coauthored five Access programming books. Allen Taylor is a 30-year veteran of the computer industry and the author of over 20 books.</p>","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9789"}},{"authorId":9559,"name":"Allen G. Taylor","slug":"allen-g-taylor","description":" <p><b>Allen G. Taylor</b> is a 30-year veteran of the computer industry and the author of over 40 books, including <b><i>SQL For Dummies</i></b> and <i>Crystal Reports For Dummies.</i> He lectures nationally on databases, innovation, and entrepreneurship. He also teaches database development internationally through a leading online education provider. ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9559"}},{"authorId":9788,"name":"Alison Barrows","slug":"alison-barrows","description":" <p><b>Alison Barrows</b> is the author or coauthor of several books about Access, Windows, and the Internet. Joseph Stockman is an 18-year software designer who has authored or coauthored five Access programming books. Allen Taylor is a 30-year veteran of the computer industry and the author of over 20 books.</p>","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9788"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","access"]},{"key":"isbn","values":["9781118510551"]}]\" id=\"du-slot-632219db79791\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","access"]},{"key":"isbn","values":["9781118510551"]}]\" id=\"du-slot-632219db79d94\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":169920,"title":"Designing a Relational Database in Access 2013","slug":"designing-a-relational-database-in-access-2013","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/169920"}},{"articleId":169929,"title":"Tips for Choosing Field Types in Access 2013","slug":"tips-for-choosing-field-types-in-access-2013","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/169929"}},{"articleId":169932,"title":"Handy Access 2013 Keyboard Shortcuts","slug":"handy-access-2013-keyboard-shortcuts-2","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/169932"}},{"articleId":169931,"title":"Secrets of Access 2013 Database Design","slug":"secrets-of-access-2013-database-design","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/169931"}},{"articleId":169919,"title":"Finding the Right Access 2013 Tool for Keeping Garbage Out","slug":"finding-the-right-access-2013-tool-for-keeping-garbage-out","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/169919"}},{"articleId":169928,"title":"Using Visual Basic for Applications Efficiently in Access 2013","slug":"using-visual-basic-for-applications-efficiently-in-access-2013","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/169928"}},{"articleId":169930,"title":"Sharing Data with Other Programs from within Access 2013","slug":"sharing-data-with-other-programs-from-within-access-2013","categoryList":["technology","software","microsoft-products","access"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/169930"}}],"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":208045},"articleLoadedStatus":"success"},"listState":{"list":{},"objectTitle":"","status":"initial","pageType":null,"objectId":null,"page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{},"filterDataLoadedStatus":"initial","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2024-11-22T05:50:01+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n","enabled":true},{"pages":["all"],"location":"footer","script":"\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'></div>\r\n","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":" <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":295890,"title":"Career Shifting","hasSubCategories":false,"url":"/collection/career-shifting-295890"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":299891,"title":"For the College Bound","hasSubCategories":false,"url":"/collection/for-the-college-bound-299891"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":301547,"title":"For the Game Day Prepper","hasSubCategories":false,"url":"/collection/big-game-day-prep-made-easy-301547"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"Article4","path":"/article/technology/software/microsoft-products/access/access-2013-all-in-one-for-dummies-cheat-sheet-208045/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"access","article":"access-2013-all-in-one-for-dummies-cheat-sheet-208045"},"fullPath":"/article/technology/software/microsoft-products/access/access-2013-all-in-one-for-dummies-cheat-sheet-208045/","meta":{"routeType":"article","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"dropsState":{"submitEmailResponse":false,"status":"initial"},"profileState":{"auth":{},"userOptions":{},"status":"success"}}

Access 2013 All-In-One For Dummies Cheat Sheet

By: Alison Barrows and Joseph C. Stockman and Allen G. Taylor and

Updated: 03-27-2016

From The Book: Access 2013 All-in-One For Dummies

Access 2013 All-in-One For Dummies

Explore Book Buy On Amazon

Access 2013 makes managing your data easy, combining a visual interface with the power of a relational database. Discover how to organize data into tables, design forms and reports for editing and presenting information, and create queries for selecting and combining information. The next steps are writing macros and Visual Basic for Applications (VBA) scripts to make your database smart, and using SharePoint to publish data to the web.

About This Article

This article is from the book:

Access 2013 All-in-One For Dummies ,

About the book authors:

Alison Barrows is the author or coauthor of several books about Access, Windows, and the Internet. Joseph Stockman is an 18-year software designer who has authored or coauthored five Access programming books. Allen Taylor is a 30-year veteran of the computer industry and the author of over 20 books.

This article can be found in the category:

Access ,

Article Categories

Book Categories

Collections