= #9/1/1999#. Include Company, State, and StartDate, then submit your query summary." /> Multiple Query Criteria [Access AND Clause] - Exercise


Refining Queries  «Prev  Next»

Working with multiple query criteria — Exercise

Course project: Using AND criteria in an Access query

Objective: Create a query that filters results using two criteria (an AND condition).

Exercise scoring

This exercise is auto-scored for 10 points. When you are finished, click Submit to view the exercise result page and confirm the expected criteria and output.

Background

You are the Access database administrator supporting marketing/documentation projects. A new Arizona reporting requirement applies to work performed in the state starting on 9/1/1999. You need a query that returns projects for Arizona clients with a StartDate on or after 9/1/1999.

Download files

Use the Consulting307.mdb database from the Resources download. If you already have it, keep using that copy.

Instructions

  1. Create a query that includes:
    • Company (Clients table)
    • State (Clients table)
    • StartDate (Projects table)
  2. Add criteria so the query returns only:
    • State = "AZ"
    • StartDate >= #9/1/1999#

    In Design View, placing both criteria on the same Criteria row enforces an AND condition.

Your work (what to submit)

Paste either (1) the query design summary (fields + criteria) or (2) the SQL view of your query below. Keep it short and focused on the three fields and the two criteria.