{"id":3118,"date":"2019-12-23T16:41:19","date_gmt":"2019-12-23T16:41:19","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3118"},"modified":"2024-05-17T00:25:32","modified_gmt":"2024-05-17T00:25:32","slug":"sorting-data-2","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/sorting-data-2\/","title":{"raw":"Sorting Data","rendered":"Sorting Data"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Sort and filter records<\/li>\r\n<\/ul>\r\n<\/div>\r\nThere are multiple ways to sort data in Access. The first option is to use the toolbar shown in the example below. The tools function as you would expect from any MS Office tool bar.\r\n\r\n<img class=\"alignnone wp-image-3457 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07212042\/Figure13_17.png\" alt=\"Microsoft Access Filter tool bar. Options include Ascending (a to z), Descending (z to a), Selection (with a dropdown menu), Advanced (with a dropdown menu), Remove Sort, and Toggle Filter. The words &quot;Sort &amp; Filter&quot; are at the bottom middle of the toolbar.\" width=\"395\" height=\"162\" \/>\r\n\r\nAnother way to quickly sort data in a table is to use the sorting capability built-in to the column headers, as shown in the example below. Clicking on the arrow in each header will sort the records in ascending or descending order (alternating).\r\n\r\n<img class=\"alignnone wp-image-3458 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07212100\/Figure13_18.png\" alt=\"A series of column headers, each with a small black arrow to the right of the column header text. Clicking the arrow will sort the column in descending or ascending order.\" width=\"974\" height=\"33\" \/>\r\n\r\nFiltering your view of the data set can be accomplished in several ways. Perhaps the quickest is to right-click on the value you wish to filter by to open the dialog in the example below.\r\n\r\n<img class=\"alignnone wp-image-3459 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07212117\/Figure13_19.png\" alt=\"Cell selected by right clicking. A dialogue box opens to the right of the selected cell. Options present in this dialogue box include &quot;Equals &quot;Closed&quot;&quot;, &quot;Does Not Equal &quot;Closed&quot;&quot;, Contains &quot;Closed&quot;, and Does Not Contain &quot;Closed&quot;.\" width=\"974\" height=\"631\" \/>\r\n\r\nIn this case, if we wish to filter by the value \u201cClosed\u201d and can choose one of four filtering elements: \u201cEquals,\u201d \u201cDoes Not Equal,\u201d Contains,\u201d or \u201cDoes Not Contain.\u201d\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/a14fb53b-bef0-4c4e-90c1-8c6a8cb2b91e\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Sort and filter records<\/li>\n<\/ul>\n<\/div>\n<p>There are multiple ways to sort data in Access. The first option is to use the toolbar shown in the example below. The tools function as you would expect from any MS Office tool bar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3457 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07212042\/Figure13_17.png\" alt=\"Microsoft Access Filter tool bar. Options include Ascending (a to z), Descending (z to a), Selection (with a dropdown menu), Advanced (with a dropdown menu), Remove Sort, and Toggle Filter. The words &quot;Sort &amp; Filter&quot; are at the bottom middle of the toolbar.\" width=\"395\" height=\"162\" \/><\/p>\n<p>Another way to quickly sort data in a table is to use the sorting capability built-in to the column headers, as shown in the example below. Clicking on the arrow in each header will sort the records in ascending or descending order (alternating).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3458 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07212100\/Figure13_18.png\" alt=\"A series of column headers, each with a small black arrow to the right of the column header text. Clicking the arrow will sort the column in descending or ascending order.\" width=\"974\" height=\"33\" \/><\/p>\n<p>Filtering your view of the data set can be accomplished in several ways. Perhaps the quickest is to right-click on the value you wish to filter by to open the dialog in the example below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3459 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07212117\/Figure13_19.png\" alt=\"Cell selected by right clicking. A dialogue box opens to the right of the selected cell. Options present in this dialogue box include &quot;Equals &quot;Closed&quot;&quot;, &quot;Does Not Equal &quot;Closed&quot;&quot;, Contains &quot;Closed&quot;, and Does Not Contain &quot;Closed&quot;.\" width=\"974\" height=\"631\" \/><\/p>\n<p>In this case, if we wish to filter by the value \u201cClosed\u201d and can choose one of four filtering elements: \u201cEquals,\u201d \u201cDoes Not Equal,\u201d Contains,\u201d or \u201cDoes Not Contain.\u201d<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_a14fb53b-bef0-4c4e-90c1-8c6a8cb2b91e\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/a14fb53b-bef0-4c4e-90c1-8c6a8cb2b91e?iframe_resize_id=assessment_practice_id_a14fb53b-bef0-4c4e-90c1-8c6a8cb2b91e\" 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-3118\">\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>Sorting 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":15,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Sorting Data\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"ce005cba-2a20-4cfe-9b6c-e38010b4fc2e, c7135520-d0c9-429f-9f20-ba9729993011","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3118","chapter","type-chapter","status-publish","hentry"],"part":2774,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3118","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\/3118\/revisions"}],"predecessor-version":[{"id":5965,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3118\/revisions\/5965"}],"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\/3118\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3118"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3118"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3118"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}