{"id":372,"date":"2022-12-01T20:32:50","date_gmt":"2022-12-01T20:32:50","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/understanding-calculations\/"},"modified":"2022-12-01T20:32:50","modified_gmt":"2022-12-01T20:32:50","slug":"understanding-calculations","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/understanding-calculations\/","title":{"raw":"Understanding Calculations","rendered":"Understanding Calculations"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Discuss the use of calculations in Microsoft Access<\/li>\n<\/ul>\n<\/div>\nAccess has a rich set of calculations, functions, and expressions to assist in data analysis.\n\n<img class=\"alignnone wp-image-3516 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234754\/Figure14_23.png\" alt=\"Expression Builder dialog box. The Expression box is empty. There are boxes to select Expression Elements and Values below.\" width=\"791\" height=\"697\">\n\nThis library of calculations is easily opened and is fairly intuitive to use. In the example below, if the user is interested in using the DateDiff function, Access lists the necessary arguments for that function in the top window.\n\n<img class=\"alignnone wp-image-3517 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234807\/Figure14_24.png\" alt=\"Expression Builder dialog box. The Expression box has been filled with the expression &quot;DateDiff(<<interval>>, <<date1>>, <<date2>>, <<firstdayofweek>>, <<firstweekofyear>>)\" width=\"695\" height=\"620\">\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/6b8d7b9a-e31f-43db-ba1e-f2a8c6278a3b\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\/1cqgAAbgmIU-5fihFYWVl9DpBtufdwra62DRsRsbPp8s\" 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>Discuss the use of calculations in Microsoft Access<\/li>\n<\/ul>\n<\/div>\n<p>Access has a rich set of calculations, functions, and expressions to assist in data analysis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3516 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234754\/Figure14_23.png\" alt=\"Expression Builder dialog box. The Expression box is empty. There are boxes to select Expression Elements and Values below.\" width=\"791\" height=\"697\" \/><\/p>\n<p>This library of calculations is easily opened and is fairly intuitive to use. In the example below, if the user is interested in using the DateDiff function, Access lists the necessary arguments for that function in the top window.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-3517 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07234807\/Figure14_24.png\" alt=\"image\" \/>&gt;, &lt;&lt;date1&gt;&gt;, &lt;&lt;date2&gt;&gt;, &lt;&lt;firstdayofweek&gt;&gt;, &lt;&lt;firstweekofyear&gt;&gt;)&#8221; width=&#8221;695&#8243; height=&#8221;620&#8243;&gt;<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_6b8d7b9a-e31f-43db-ba1e-f2a8c6278a3b\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/6b8d7b9a-e31f-43db-ba1e-f2a8c6278a3b?iframe_resize_id=assessment_practice_id_6b8d7b9a-e31f-43db-ba1e-f2a8c6278a3b\" 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\/1cqgAAbgmIU-5fihFYWVl9DpBtufdwra62DRsRsbPp8s\" 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-372\">\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>Understanding Calculations. <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":16,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Understanding Calculations\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"f92d00e2-b587-46e4-bff2-3cc40f9de00d, de436fae-bff3-4a72-93e5-0c6921483c5d","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-372","chapter","type-chapter","status-publish","hentry"],"part":356,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/372","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\/372\/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\/372\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=372"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=372"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=372"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}