{"id":361,"date":"2022-12-01T20:32:45","date_gmt":"2022-12-01T20:32:45","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/introduction-to-queries\/"},"modified":"2022-12-01T20:32:45","modified_gmt":"2022-12-01T20:32:45","slug":"introduction-to-queries","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/introduction-to-queries\/","title":{"raw":"Introduction to Queries","rendered":"Introduction to Queries"},"content":{"raw":"\n<h2>What you'll learn to do: Create and modify queries<\/h2>\nQueries represent the most useful way we interact with a relational database. In this section, we will learn how to create basic and advanced queries in order to \"ask questions\" of the information stored in Access. Database queries can be as simple as \"show me the top product line in XYZ territory this month\" to as complex as \"show me the lowest revenue stores in these five product lines in the top producing territories\". In either case, without queries relational databases would not be very helpful in running the business.\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\/1gbFKnaHBPkgZEa4__vkrTzIfAkAs8FfDxDLM0gy8DlI\" 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>What you&#8217;ll learn to do: Create and modify queries<\/h2>\n<p>Queries represent the most useful way we interact with a relational database. In this section, we will learn how to create basic and advanced queries in order to &#8220;ask questions&#8221; of the information stored in Access. Database queries can be as simple as &#8220;show me the top product line in XYZ territory this month&#8221; to as complex as &#8220;show me the lowest revenue stores in these five product lines in the top producing territories&#8221;. In either case, without queries relational databases would not be very helpful in running the business.<\/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\/1gbFKnaHBPkgZEa4__vkrTzIfAkAs8FfDxDLM0gy8DlI\" 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","protected":false},"author":503070,"menu_order":5,"template":"","meta":{"_candela_citation":"[]","CANDELA_OUTCOMES_GUID":"7ad60111-c7c6-469a-915a-ae45ba761d3d","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-361","chapter","type-chapter","status-publish","hentry"],"part":356,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/361","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\/361\/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\/361\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=361"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=361"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=361"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}