{"id":3122,"date":"2019-12-23T16:41:34","date_gmt":"2019-12-23T16:41:34","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3122"},"modified":"2024-05-17T00:25:56","modified_gmt":"2024-05-17T00:25:56","slug":"putting-it-together-microsoft-access-intermediate-skills","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/putting-it-together-microsoft-access-intermediate-skills\/","title":{"raw":"Putting It Together: Microsoft Access Intermediate Skills","rendered":"Putting It Together: Microsoft Access Intermediate Skills"},"content":{"raw":"In this section we spent a great deal of time learning how to work with Access datasheets: adding and deleting data, displaying data, sorting and filtering data, aggregating data, and previewing and printing records. This is important as an MS Access user will spend a good deal of time taking advantage of the ease-of-use of this view to get work done.\r\n\r\nMore broadly, we dove in to some important database principles and how database technology can be applied to create useful commercial applications. The fact that multiple users can consume information\u2014even utilize different views at the same time\u2014from a database application is of tremendous value. Database applications as simple as generating mailing lists to as complex as airline reservations rely on the database principles we discussed.","rendered":"<p>In this section we spent a great deal of time learning how to work with Access datasheets: adding and deleting data, displaying data, sorting and filtering data, aggregating data, and previewing and printing records. This is important as an MS Access user will spend a good deal of time taking advantage of the ease-of-use of this view to get work done.<\/p>\n<p>More broadly, we dove in to some important database principles and how database technology can be applied to create useful commercial applications. The fact that multiple users can consume information\u2014even utilize different views at the same time\u2014from a database application is of tremendous value. Database applications as simple as generating mailing lists to as complex as airline reservations rely on the database principles we discussed.<\/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-3122\">\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>Putting It Together: Microsoft Access Intermediate Skills. <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":18,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Putting It Together: Microsoft Access Intermediate Skills\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"d0e36751-eb54-4390-8af5-e614fe32414a","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3122","chapter","type-chapter","status-publish","hentry"],"part":2774,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3122","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":7,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3122\/revisions"}],"predecessor-version":[{"id":5968,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3122\/revisions\/5968"}],"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\/3122\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3122"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3122"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3122"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}