Recall The CDC Design ...
v As it exists so far, the CDC database system has the
following components:
o Clients Table and Clients Form with Queue mechanism
o MedPros Table and MedPros Form
o Visits Table and Visits Form with Order button to set the
tracking number
v What remains is to prepare for the “post visit”
processing
v The main idea in “post visit” processing is to build
new tables from the data in the Visits table
v These derived tables are produced by queries