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