{"appState":{"pageLoadApiCallsStatus":true},"bookState":{"book":{"headers":{"timestamp":"2024-11-22T12:11:26+00:00"},"bookId":292955,"data":{"name":"Access Forms and Reports For Dummies","title":"Access Forms and Reports For Dummies","slug":"access-forms-and-reports-for-dummies","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}],"description":"Create queries that make forms and reports useful<br /> <br /> Develop forms to access the data you need and make reports that make sense!<br /> <br /> If you thought you had to use a spreadsheet program to produce reports and forms, guess what! Access can turn out great-looking forms and reports that actually show what's going on with your data -- if you know how to ask it nicely. This hands-on guide helps you do just that, and it works with all versions of Access.<br /> <br /> Discover how to<br /> * Ask Access the right questions<br /> * Work with sets of data<br /> * Create simple forms with a wizard<br /> * Use queries to create new tables<br /> * Troubleshoot queries<br /> * Add visual features to reports","bookOutOfPrint":false,"testBankPinActivationLink":"","publishedDate":"2005-09-30T12:11:22+00:00","primaryISBN":"9780764599651","secondaryISBNs":"9780471776260,9780470196571","learningType":"Advance","primaryCategory":{"categoryId":33643,"title":"Access","slug":"access","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33643"}},"secondaryCategory":{"categoryId":0,"title":null,"slug":null,"_links":null},"amazon":{"default":"https://www.amazon.com/gp/product/0764599658/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/0764599658/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/0764599658-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/0764599658/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/0764599658/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/covers/9780764599651.jpg","width":250,"height":350},"authors":[{"authorId":9181,"name":"Brian Underdahl","slug":"brian-underdahl","description":" <b>Brian Underdahl</b> is the well-known, best selling author of over 70 computer books on a broad range of subjects. He has appeared on a number of TV shows, including the <i>Computer Chronicles,</i> and several <i>TechTV</i> programs, and is the subject of an hour-long interview on the syndicated <i>Computer Outlook</i> radio program. One of his titles was recently recommended to viewers by Scott Gurvey, Bureau Chief, on the <i>Nightly Business Report</i> on PBS, and his books have won awards including an Award of Merit from the Northern California Technical Communications Competition and the Referenceware Excellence Award for best title in the Graphic Design and Multimedia category.<br /> Brian has been involved in personal computers from their beginning and has a background in electrical engineering. His last “real” job was as a Senior Programmer/Analyst for a large company, where he worked hard to bring the power and freedom of PCs to the desktops.<br /> Brian figures that it’s the author who should do the work so that readers can get their money’s worth. That’s why his books are different — he takes the time to explain what’s going on so that readers can understand the subjects easily.","hasArticle":true,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9181"}}],"relatedArticles":{"_links":{"self":"https://dummies-api.dummies.com/v2/articles?book=292955&offset=0&size=5"}},"relatedBooks":[{"bookId":292383,"name":"Access 2007 Forms and Reports For Dummies","slug":"access-2007-forms-and-reports-for-dummies","primaryCategory":{"categoryId":33643,"title":"Access","slug":"access","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33643"}},"categoryList":["technology","software","microsoft-products","access"],"image":{"src":"https://www.dummies.com/covers/9780470046593.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/292383"}},{"bookId":281616,"name":"Access 2019 For Dummies","slug":"access-2019-for-dummies","primaryCategory":{"categoryId":33643,"title":"Access","slug":"access","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33643"}},"categoryList":["technology","software","microsoft-products","access"],"image":{"src":"https://www.dummies.com/covers/9781119513261.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/281616"}},{"bookId":288931,"name":"Access For Dummies","slug":"access-for-dummies","primaryCategory":{"categoryId":33643,"title":"Access","slug":"access","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33643"}},"categoryList":["technology","software","microsoft-products","access"],"image":{"src":"https://www.dummies.com/covers/9781119829089.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/288931"}}],"cheatSheet":null,"bookAuthorBio":"<b data-author-id=\"9181\">Brian Underdahl</b> is the well-known, best selling author of over 70 computer books on a broad range of subjects. He has appeared on a number of TV shows, including the <i>Computer Chronicles,</i> and several <i>TechTV</i> programs, and is the subject of an hour-long interview on the syndicated <i>Computer Outlook</i> radio program. One of his titles was recently recommended to viewers by Scott Gurvey, Bureau Chief, on the <i>Nightly Business Report</i> on PBS, and his books have won awards including an Award of Merit from the Northern California Technical Communications Competition and the Referenceware Excellence Award for best title in the Graphic Design and Multimedia category.<br /> Brian has been involved in personal computers from their beginning and has a background in electrical engineering. His last “real” job was as a Senior Programmer/Analyst for a large company, where he worked hard to bring the power and freedom of PCs to the desktops.<br /> Brian figures that it’s the author who should do the work so that readers can get their money’s worth. That’s why his books are different — he takes the time to explain what’s going on so that readers can understand the subjects easily.","additionalResourceLink":"","bookCompanionPage":{"pageId":0,"name":null,"slug":null,"_links":null},"seo":{"metaDescription":"With Access Forms and Reports For Dummies (0764599658) you can create great-looking forms and reports that accurately describe your data.","noIndex":0,"noFollow":0}},"_links":{"self":"https://dummies-api.dummies.com/v2/books/292955"}},"bookLoadedStatus":"success","bookExtras":{},"bookExtrasLoadedStatus":"initial"},"listState":{"list":{},"objectTitle":"","status":"progress","pageType":"book","objectId":"292955","page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":["Articles"],"filterData":{},"filterDataLoadedStatus":"initial","pageSize":3},"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":"Book4","path":"/book/technology/software/microsoft-products/access/access-forms-and-reports-for-dummies-292955/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"access","book":"access-forms-and-reports-for-dummies-292955"},"fullPath":"/book/technology/software/microsoft-products/access/access-forms-and-reports-for-dummies-292955/","meta":{"routeType":"book","breadcrumbInfo":{"suffix":"Books","baseRoute":"/category/books"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"profileState":{"auth":{},"userOptions":{},"status":"success"}}

Access Forms and Reports For Dummies book cover

Access Forms and Reports For Dummies

Author:

Brian Underdahl

Overview

Create queries that make forms and reports useful

Develop forms to access the data you need and make reports that make sense!

If you thought you had to use a spreadsheet program to produce reports and forms, guess what! Access can turn out great-looking forms and reports that actually show what's going on with your data -- if you know how to ask it nicely. This hands-on guide helps you do just that, and it works with all versions of Access.

Discover how to
* Ask Access the right questions
* Work with sets of data
* Create simple forms with a wizard
* Use queries to create new tables
* Troubleshoot queries
* Add visual features to reports

Create queries that make forms and reports useful

Develop forms to access the data you need and make reports that make sense!

If you thought you had to use a spreadsheet program to produce reports and forms, guess what! Access can turn out great-looking forms and reports that actually show what's going on with your data -- if you know

how to ask it nicely. This hands-on guide helps you do just that, and it works with all versions of Access.

Discover how to
* Ask Access the right questions
* Work with sets of data
* Create simple forms with a wizard
* Use queries to create new tables
* Troubleshoot queries
* Add visual features to reports

About The Author

Brian Underdahl is the well-known, best selling author of over 70 computer books on a broad range of subjects. He has appeared on a number of TV shows, including the Computer Chronicles, and several TechTV programs, and is the subject of an hour-long interview on the syndicated Computer Outlook radio program. One of his titles was recently recommended to viewers by Scott Gurvey, Bureau Chief, on the Nightly Business Report on PBS, and his books have won awards including an Award of Merit from the Northern California Technical Communications Competition and the Referenceware Excellence Award for best title in the Graphic Design and Multimedia category.
Brian has been involved in personal computers from their beginning and has a background in electrical engineering. His last “real” job was as a Senior Programmer/Analyst for a large company, where he worked hard to bring the power and freedom of PCs to the desktops.
Brian figures that it’s the author who should do the work so that readers can get their money’s worth. That’s why his books are different — he takes the time to explain what’s going on so that readers can understand the subjects easily.

Articles From The Book

0 results