Table Definition, Queries & Reports

I. Table Definition
A. Table Design

B. Orchid Information
C. Supplier Information
D. Wholesaler InformationII. Queries
A. Best Sellers
B. Greenhouse Requirements
C. Most Profitable Group
D. Orchid Not in Bloom
E. Orchid that Died

Table Definition

A. Client Data

B. Jobs Input
C. Sales CallsD. Work Per Client

E. Clients By Zip

Revenue From Customers -December 2005

Revenue From Customers -December 2005

Rooms Booked the Week of 12/12/05

A. Rooms Booked the Week of 12/12/05

Case 1- Queries (Money Generated By Room)

A. Money Generated By Room

Case 1 - Tables Definition

List of Tables
A. Customers Table

B. Reservations Table


C. Rooms Table