{"id":373,"date":"2022-12-01T20:32:51","date_gmt":"2022-12-01T20:32:51","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/using-conditional-analysis\/"},"modified":"2022-12-01T20:32:51","modified_gmt":"2022-12-01T20:32:51","slug":"using-conditional-analysis","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/using-conditional-analysis\/","title":{"raw":"Using Conditional Analysis","rendered":"Using Conditional Analysis"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Use conditional analysis<\/li>\n<\/ul>\n<\/div>\nIn our discussion so far, getting information from Access databases has been a matter of creating queries, adding criteria and calculations, saving the queries, and then formatting the data into reports that can be run over and over as needed. Conditional Analysis comes into play when the basis of the analysis is in a state of flux or may otherwise need to change. Using parameter queries in Access is a solid approach to deal with this condition.\n\nIn the example below, a query is being prepared to display data regarding Purchase Order shipped and invoice dates. A hard-coded date is a criteria for the query.\n\n<img class=\"alignnone wp-image-3520 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234927\/Figure14_25.png\" alt=\"A query that looks at Orders, Purchase Order Details, and Invoices. \" width=\"924\" height=\"612\">\n\nBut what if users from different departments need the flexibility to fetch this information from different time periods? Notice how this draft query has been changed to a conditional query by bracketing user instructions in the example below.\n\n<img class=\"alignnone wp-image-3521 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234942\/Figure14_26.png\" alt=\"A query that looks at Orders, Purchase Order Details, and Invoices. \" width=\"854\" height=\"566\">\n\nNow when the query is run, this dialog box would open and display the bracketed text to give the user the opportunity to enter the desired date of the analysis.\n\n<img class=\"alignnone wp-image-3522 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07235006\/Figure14_27.png\" alt=\"An Enter Parameter Value dialog box. The field below &quot;Enter System Period&quot; is empty.\" width=\"410\" height=\"214\">\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/fa8bfda3-600f-4907-9ab3-00784d217db8\n\n<\/div>\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\/1X5x7bjJQfoybhAbEtw9WhZlflSz9NEv2uTyviN0XEFg\" 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":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Use conditional analysis<\/li>\n<\/ul>\n<\/div>\n<p>In our discussion so far, getting information from Access databases has been a matter of creating queries, adding criteria and calculations, saving the queries, and then formatting the data into reports that can be run over and over as needed. Conditional Analysis comes into play when the basis of the analysis is in a state of flux or may otherwise need to change. Using parameter queries in Access is a solid approach to deal with this condition.<\/p>\n<p>In the example below, a query is being prepared to display data regarding Purchase Order shipped and invoice dates. A hard-coded date is a criteria for the query.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3520 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234927\/Figure14_25.png\" alt=\"A query that looks at Orders, Purchase Order Details, and Invoices.\" width=\"924\" height=\"612\" \/><\/p>\n<p>But what if users from different departments need the flexibility to fetch this information from different time periods? Notice how this draft query has been changed to a conditional query by bracketing user instructions in the example below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3521 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234942\/Figure14_26.png\" alt=\"A query that looks at Orders, Purchase Order Details, and Invoices.\" width=\"854\" height=\"566\" \/><\/p>\n<p>Now when the query is run, this dialog box would open and display the bracketed text to give the user the opportunity to enter the desired date of the analysis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3522 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07235006\/Figure14_27.png\" alt=\"An Enter Parameter Value dialog box. The field below &quot;Enter System Period&quot; is empty.\" width=\"410\" height=\"214\" \/><\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_fa8bfda3-600f-4907-9ab3-00784d217db8\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/fa8bfda3-600f-4907-9ab3-00784d217db8?iframe_resize_id=assessment_practice_id_fa8bfda3-600f-4907-9ab3-00784d217db8\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\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\/1X5x7bjJQfoybhAbEtw9WhZlflSz9NEv2uTyviN0XEFg\" 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-373\">\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>Using Conditional Analysis. <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":17,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Using Conditional Analysis\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"f92d00e2-b587-46e4-bff2-3cc40f9de00d, 4a6e8ab4-61b4-4ea7-b55c-eeca81f13a9c","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-373","chapter","type-chapter","status-publish","hentry"],"part":356,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/373","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\/373\/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\/373\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=373"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=373"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=373"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}