{"id":3153,"date":"2019-12-23T16:46:06","date_gmt":"2019-12-23T16:46:06","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3153"},"modified":"2025-10-30T16:08:08","modified_gmt":"2025-10-30T16:08:08","slug":"adding-criteria-to-a-query","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/chapter\/adding-criteria-to-a-query\/","title":{"raw":"Adding Criteria to a Query","rendered":"Adding Criteria to a Query"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Add criteria to a query<\/li>\r\n<\/ul>\r\n<\/div>\r\nMore complex queries can be created in Access by using the \u201cDatabase Designer.\u201d Database Designer allows criteria to be added to a query to include or exclude data elements to make queries more meaningful. Let\u2019s say we want to develop a list of employees\u2014but limit the list to employees who are Sales Representatives.\r\n\r\nSelect \u201cDatabase Designer\u201d from the tool bar and choose the \u201cEmployees\u201d table from the list.\r\n\r\nGo to the \u201cCriteria\u201d field and enter \u201c= Sales Representatives.\u201d Access automatically adds the parenthesis to your entry.\r\n\r\n<img class=\"alignnone wp-image-3495 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07233847\/Figure14_13.png\" alt=\"Employee table selected in &quot;Database Designer&quot; and &quot;Sales Representative&quot; is entered into the Criteria cell.\" width=\"974\" height=\"495\" \/>\r\n\r\nRun the query and Access returns only the list of employees who have that title.\r\n\r\n<img class=\"alignnone wp-image-3496 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07233901\/Figure14_14.png\" alt=\"Complete query shows datasheet that only presents query information for employees with the job titled &quot;Sales Representative.&quot; \" width=\"974\" height=\"214\" \/>\r\n<div class=\"textbox tryit\">\r\n<h3>PRactice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/e28ebd63-7d94-4dfb-9d6c-b2ceeca62cfe\r\n\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Add criteria to a query<\/li>\n<\/ul>\n<\/div>\n<p>More complex queries can be created in Access by using the \u201cDatabase Designer.\u201d Database Designer allows criteria to be added to a query to include or exclude data elements to make queries more meaningful. Let\u2019s say we want to develop a list of employees\u2014but limit the list to employees who are Sales Representatives.<\/p>\n<p>Select \u201cDatabase Designer\u201d from the tool bar and choose the \u201cEmployees\u201d table from the list.<\/p>\n<p>Go to the \u201cCriteria\u201d field and enter \u201c= Sales Representatives.\u201d Access automatically adds the parenthesis to your entry.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3495 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07233847\/Figure14_13.png\" alt=\"Employee table selected in &quot;Database Designer&quot; and &quot;Sales Representative&quot; is entered into the Criteria cell.\" width=\"974\" height=\"495\" \/><\/p>\n<p>Run the query and Access returns only the list of employees who have that title.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3496 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07233901\/Figure14_14.png\" alt=\"Complete query shows datasheet that only presents query information for employees with the job titled &quot;Sales Representative.&quot;\" width=\"974\" height=\"214\" \/><\/p>\n<div class=\"textbox tryit\">\n<h3>PRactice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_e28ebd63-7d94-4dfb-9d6c-b2ceeca62cfe\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/e28ebd63-7d94-4dfb-9d6c-b2ceeca62cfe?iframe_resize_id=assessment_practice_id_e28ebd63-7d94-4dfb-9d6c-b2ceeca62cfe\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\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-3153\">\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>Adding Criteria to a Query. <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":7,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Adding Criteria to a Query\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"7ad60111-c7c6-469a-915a-ae45ba761d3d, 09e48209-13ba-46cc-b733-928805f604c3","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3153","chapter","type-chapter","status-publish","hentry"],"part":2775,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":11,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3153\/revisions"}],"predecessor-version":[{"id":5601,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3153\/revisions\/5601"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/parts\/2775"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3153\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/media?parent=3153"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapter-type?post=3153"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/contributor?post=3153"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/license?post=3153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}