{"id":357,"date":"2022-12-01T20:32:44","date_gmt":"2022-12-01T20:32:44","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/why-it-matters-microsoft-access-advanced-skills\/"},"modified":"2022-12-01T20:32:44","modified_gmt":"2022-12-01T20:32:44","slug":"why-it-matters-microsoft-access-advanced-skills","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/why-it-matters-microsoft-access-advanced-skills\/","title":{"raw":"Why It Matters: Microsoft Access Advanced Skills","rendered":"Why It Matters: Microsoft Access Advanced Skills"},"content":{"raw":"\n<h2>Why learn advanced Microsoft Access skills?<\/h2>\nHow does database technology matter today? For one thing, there would be no eCommerce without underlying database technology to support it. What about healthcare? How would we keep track of patients, appointments, and treatment history without the use of database applications? Then you have online television streaming. Streaming services need database applications to generate a list of shows to watch and track individuals\u2019 viewing history. Very powerful database applications are needed to not only track viewing but to analyze and recommend new viewing for each and every individual customer.\n\nIn this final section, we will get into some of the advanced capabilities of MS Access. Dealing with external data\u2014data outside of the current Access database\u2014is a real-world situation that needs to be covered here. The concept of queries\u2014how we interact with databases to leverage the information stored within\u2014is another important topic to be addressed in this section. Finally, forms and reports are key to how we get data in and out of databases.\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\/18JtORmzn72GfRpNKLbDw-0zF0KQ-poBSmlAk2GxtyFw\" 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":"<h2>Why learn advanced Microsoft Access skills?<\/h2>\n<p>How does database technology matter today? For one thing, there would be no eCommerce without underlying database technology to support it. What about healthcare? How would we keep track of patients, appointments, and treatment history without the use of database applications? Then you have online television streaming. Streaming services need database applications to generate a list of shows to watch and track individuals\u2019 viewing history. Very powerful database applications are needed to not only track viewing but to analyze and recommend new viewing for each and every individual customer.<\/p>\n<p>In this final section, we will get into some of the advanced capabilities of MS Access. Dealing with external data\u2014data outside of the current Access database\u2014is a real-world situation that needs to be covered here. The concept of queries\u2014how we interact with databases to leverage the information stored within\u2014is another important topic to be addressed in this section. Finally, forms and reports are key to how we get data in and out of databases.<\/p>\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\/18JtORmzn72GfRpNKLbDw-0zF0KQ-poBSmlAk2GxtyFw\" 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-357\">\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>Why It Matters: Microsoft Access Advanced 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":503070,"menu_order":1,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Why It Matters: Microsoft Access Advanced Skills\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"7ff19125-1641-42ea-bc3f-ba0ded4e88f6","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-357","chapter","type-chapter","status-publish","hentry"],"part":356,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/357","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\/357\/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\/357\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=357"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=357"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=357"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}