The difficult I do immediately, the impossible takes a little bit longer.

Data Models

Data Model ~ Purchase Orders with Inventory...
This data model was designed to handle Purchase Orders with Inventory management.  (Note, there only tables included in this database the balance is up to you!)
Business Rules...

You may want to sort your Inventory by Category

Inventory will need to be stored

There many Purchase Orders

Each Purchase Order will have a Vendor

You will want to know who ordered (requistioned) the Inventory

Purchases may require an Expenditure Code

Main Entities...

Purchase Orders


Vendors will have Types

Download Sample (Access 2007 and higher and an unzipping program needed)