This video shows you how to create a query in design view and add relative fields to the query purpose.