Writing Queries
Queries are written in a “query language” … SQL has become the most popular, though others exist
Writing queries is easily learned (easier than VB6.0!)
Basic components of a query ...
SELECT Visit.Date, Visit.Tracking, Visit.HepBO
FROM Visit
WHERE (((Visit.Tracking)<>"") AND ((Visit.HepBR)=Yes));
The SELECT clause specifies the fields in the resulting table
The WHERE clause imposes constraints on the fields
allowing specific types of information to be extracted