Adding Criteria to a Query

Learning Outcomes

  • Add criteria to a query

More complex queries can be created in Access by using the “Database Designer.” Database Designer allows criteria to be added to a query to include or exclude data elements to make queries more meaningful. Let’s say we want to develop a list of employees—but limit the list to employees who are Sales Representatives.

Select “Database Designer” from the tool bar and choose the “Employees” table from the list.

Go to the “Criteria” field and enter “= Sales Representatives.” Access automatically adds the parenthesis to your entry.

Employee table selected in "Database Designer" and "Sales Representative" is entered into the Criteria cell.

Run the query and Access returns only the list of employees who have that title.

Complete query shows datasheet that only presents query information for employees with the job titled "Sales Representative."

PRactice Question