This is the full version of the companion database for chapter 8 in the Data Solutions for the Green Industry manual. The Nursery Database contains tables, queries, forms, reports, and code for the following items:
Plants
Locations
Inventory
Chemicals
Recordkeeping
Equipment
Contacts
Orders
Availability
Beginning with a Plants table and form as demonstrated in chapters 6 and 7, the manual guides the reader through creating a Locations table that, combined with Plants, is used to create an Inventory. Two methods of keeping track of inventory are considered. Next is a demonstration of a Chemicals table which, when combined with Inventory, can be used for Recordkeeping. There is an example of an Equipment table along with related Parts and Maintenance tables. Contacts and Orders tables and their related tables are also explained. Finally, there is a thorough discussion of how to use the Inventory and Orders tables to create an Availability.
This full version of the Nursery Database requires the full version of Microsoft Access.. There are no time or data limitations, and table designs and modules are available. It is an instructional tool intended for use with the manual. A free sample version is also available.
