DBWebApplications 





Refining Access Queries  «Prev  Next»

Working with multiple query criteria - Exercise

Course project: Using the AND clause in a query


Objective:

Create a query using an AND clause.

Exercise scoring


You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

Background/overview

Recall that you are the Access database administrator for the marketing and documentation departments of companies in the software and networking business. Arizona has come up with new requirements for computer work performed for companies in that state. The requirements take effect as of 9/1/99. A query is needed to display the projects for companies in Arizona that are started as of 9/1/2009.

Download files

As we stated in the first module, the Consulting307.mdb database is included in the compressed download file available on the Resources page. If you have already downloaded the database, continue to work in that version.

Instructions

  1. Create a query that includes the Company, the State from the Clients table, and the StartDate fields from the Projects table.
  2. Add criteria to the State and StartDate fields so that only those records in Arizona that started on or after 9/1/99 are displayed.