{"id":3119,"date":"2019-12-23T16:41:23","date_gmt":"2019-12-23T16:41:23","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3119"},"modified":"2024-05-17T00:25:45","modified_gmt":"2024-05-17T00:25:45","slug":"aggregating-data","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/aggregating-data\/","title":{"raw":"Aggregating Data","rendered":"Aggregating Data"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Aggregate data<\/li>\r\n<\/ul>\r\n<\/div>\r\nTo aggregate data in Access, start by selecting the \u201cTotals\u201d button in the tool bar to create a \u201cTotal\u201d row at the bottom of the datasheet table view.\r\n\r\n<img class=\"alignnone wp-image-3462 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07212210\/Figure13_20.png\" alt=\"Datasheet table showing the word &quot;Total&quot; on the bottom on the far left of the sheet.\" width=\"974\" height=\"389\" \/>\r\n\r\nThen move the cursor to the field you wish to aggregate and right-click to expose the options.\r\n\r\n<img class=\"alignnone wp-image-3463 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07212229\/Figure13_21.png\" alt=\"Datasheet table with a cell selected in the &quot;Total&quot; row, prompting a dialogue box to appear with the following options: None, Sum, Average, Count, Maximum, Minimum, Standard Deviation, and Variance.\" width=\"974\" height=\"454\" \/>\r\n\r\nFrom this approach, Access offers a Sum, Average, Count, Maximum, Minimum, Standard Deviation, and Variance aggregation option.\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/68a9f39f-b138-49c4-9094-731f1b09a9a0\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Aggregate data<\/li>\n<\/ul>\n<\/div>\n<p>To aggregate data in Access, start by selecting the \u201cTotals\u201d button in the tool bar to create a \u201cTotal\u201d row at the bottom of the datasheet table view.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3462 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07212210\/Figure13_20.png\" alt=\"Datasheet table showing the word &quot;Total&quot; on the bottom on the far left of the sheet.\" width=\"974\" height=\"389\" \/><\/p>\n<p>Then move the cursor to the field you wish to aggregate and right-click to expose the options.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3463 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07212229\/Figure13_21.png\" alt=\"Datasheet table with a cell selected in the &quot;Total&quot; row, prompting a dialogue box to appear with the following options: None, Sum, Average, Count, Maximum, Minimum, Standard Deviation, and Variance.\" width=\"974\" height=\"454\" \/><\/p>\n<p>From this approach, Access offers a Sum, Average, Count, Maximum, Minimum, Standard Deviation, and Variance aggregation option.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_68a9f39f-b138-49c4-9094-731f1b09a9a0\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/68a9f39f-b138-49c4-9094-731f1b09a9a0?iframe_resize_id=assessment_practice_id_68a9f39f-b138-49c4-9094-731f1b09a9a0\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe>\n<\/div>\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-3119\">\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>Aggregating Data. <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":17,"menu_order":16,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Aggregating Data\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"ce005cba-2a20-4cfe-9b6c-e38010b4fc2e, d41807de-062f-44e5-b830-b0c638301ab3","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3119","chapter","type-chapter","status-publish","hentry"],"part":2774,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":10,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3119\/revisions"}],"predecessor-version":[{"id":5966,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3119\/revisions\/5966"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/2774"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3119\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3119"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3119"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3119"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}