Analysis of the Central
District Clinic
The Central District
Clinic
Consider The Operation Of
The CDC
Operation (Continued)
Needs Analysis
Enter Client Data
Queue Client With Med
Professional
Further Attention To
Queuing
A Fundamental Idea
Fill Out Chart
Order Tests
Compare To Manifest
CDC Database Design --
Summary
Recall The CDC Operation
The Problem of Queuing
Construct A Client’s Form
To Queue
Clicking on Queue ...
Getting A Linked Form
Handling Tests
Ordering
The Order Button
Computing Tracking Number
Entering Tracking Number
The Results ...
Form Commands
Summary
Recall The CDC Design ...
Queries
A Query
Queries Do More Than Save
Columns
Specifying The Criteria
For Testing
Changes To The Query Are
Visible
Another Example
The Basic Query
Finishing Query With
Selections
Joining Tables Together
Build A Table Summarizing
Tests
Must Be More Selective
At The CDC, Form Today’s
Tests
The SQL For Today
The Table From The Today
Query
Making The Manifest
Wrapping Up Today