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