DBWebApplications 





Refining Access Queries  «Prev  Next»

Specifying join properties for queries - Exercise

Specifying join properties for queries


Course project: Using a left outer join


Objective:

Use a left outer join to create a query.

Exercise scoring


You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the OK, I’m Done 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. For one of your large clients, you need to see all the clients that don’t have projects assigned to them.

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 left-joining the Clients and Projects tables on ClientNo.
  2. Display the Company field.
  3. Set a criteria comparing the Projects.ClientNo against Is Null.
  4. Run the query.