{"id":369,"date":"2022-12-01T20:32:49","date_gmt":"2022-12-01T20:32:49","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/presenting-data-on-reports\/"},"modified":"2022-12-01T20:32:49","modified_gmt":"2022-12-01T20:32:49","slug":"presenting-data-on-reports","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/presenting-data-on-reports\/","title":{"raw":"Presenting Data on Reports","rendered":"Presenting Data on Reports"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Present data on reports<\/li>\n<\/ul>\n<\/div>\nThe best way to think of forms and reports is this: forms are for input and reports for output. Reports are the primary way that users consume information. Luckily, Access wizards guide us through the process of designing reports.\n\nIn the example below, we are creating a report on inventory.\n\n<img class=\"alignnone wp-image-3507 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234412\/Figure14_18.png\" alt=\"A Report Wizard Dialog Box. Under Tables\/Queries Query: Inventory is selected.\" width=\"739\" height=\"570\">\n\nSelect the fields that need to be in the report\n\n<img class=\"alignnone wp-image-3508 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234431\/Figure14_19.png\" alt=\"A Report Wizard Dialog Box. Under Tables\/Queries Query: Inventory is selected. The Selected Fields box has been filled with the following: &quot;Qty Purchased, Qty On Hand, Qty Available, Qty on Order, Reorder Level, Qty Below Target Level, Current Level, and Qty to Reorder&quot;\" width=\"750\" height=\"556\">\n\nThe wizard provides several options for the display of the information, such as sorting.\n\n<img class=\"alignnone wp-image-3509 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234445\/Figure14_20.png\" alt=\"A Report Wizard Dialog Box. It asks &quot;What sort order do you want for your records?&quot; Product ID will be sorted by Ascending order. \" width=\"750\" height=\"564\">\n\nHere is the quick Inventory report for sake of example. The report has been sorted according to Product ID as was specified in the wizard.\n\n<img class=\"alignnone wp-image-3510 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234501\/Figure14_21.png\" alt=\"Inventory datasheet. The previously selected fields are the heading rows of the table.\" width=\"974\" height=\"441\">\n\nThere is a rich set of formatting options for reports. There is also a robust \u201cPrint Preview\u201d capability where professional-looking touches can be added to the appearance of the report.\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/b3ca2c98-ac04-4731-9dd1-6641a7a84bbd\n\n<\/div>\n<h2>Contribute!<\/h2><div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div><a href=\"https:\/\/docs.google.com\/document\/d\/1Q25dcqcJ-ZysDi8L4OKxTPae71X3yedbcFOzLfMuATE\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a>\n","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Present data on reports<\/li>\n<\/ul>\n<\/div>\n<p>The best way to think of forms and reports is this: forms are for input and reports for output. Reports are the primary way that users consume information. Luckily, Access wizards guide us through the process of designing reports.<\/p>\n<p>In the example below, we are creating a report on inventory.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3507 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234412\/Figure14_18.png\" alt=\"A Report Wizard Dialog Box. Under Tables\/Queries Query: Inventory is selected.\" width=\"739\" height=\"570\" \/><\/p>\n<p>Select the fields that need to be in the report<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3508 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234431\/Figure14_19.png\" alt=\"A Report Wizard Dialog Box. Under Tables\/Queries Query: Inventory is selected. The Selected Fields box has been filled with the following: &quot;Qty Purchased, Qty On Hand, Qty Available, Qty on Order, Reorder Level, Qty Below Target Level, Current Level, and Qty to Reorder&quot;\" width=\"750\" height=\"556\" \/><\/p>\n<p>The wizard provides several options for the display of the information, such as sorting.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3509 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234445\/Figure14_20.png\" alt=\"A Report Wizard Dialog Box. It asks &quot;What sort order do you want for your records?&quot; Product ID will be sorted by Ascending order.\" width=\"750\" height=\"564\" \/><\/p>\n<p>Here is the quick Inventory report for sake of example. The report has been sorted according to Product ID as was specified in the wizard.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3510 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234501\/Figure14_21.png\" alt=\"Inventory datasheet. The previously selected fields are the heading rows of the table.\" width=\"974\" height=\"441\" \/><\/p>\n<p>There is a rich set of formatting options for reports. There is also a robust \u201cPrint Preview\u201d capability where professional-looking touches can be added to the appearance of the report.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_b3ca2c98-ac04-4731-9dd1-6641a7a84bbd\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/b3ca2c98-ac04-4731-9dd1-6641a7a84bbd?iframe_resize_id=assessment_practice_id_b3ca2c98-ac04-4731-9dd1-6641a7a84bbd\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Contribute!<\/h2>\n<div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div>\n<p><a href=\"https:\/\/docs.google.com\/document\/d\/1Q25dcqcJ-ZysDi8L4OKxTPae71X3yedbcFOzLfMuATE\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a><\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-369\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Presenting Data on Reports. <strong>Authored by<\/strong>: Robert Danielson. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":503070,"menu_order":13,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Presenting Data on Reports\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"9303f6f2-6afa-405b-ae21-97c70d158afb, 2ea63d9a-581b-4711-8ad5-b2bcca5205c5","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-369","chapter","type-chapter","status-publish","hentry"],"part":356,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/users\/503070"}],"version-history":[{"count":0,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/369\/revisions"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/parts\/356"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/369\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=369"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=369"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=369"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}