1. Build & design Purchase order forms in either MS Excel or MS Access with specified fields to be picked up from Supplier/Item Master records
2. Auto-generate alpha-numeric Purchase order number based on specific logic whenever new purchase order form is filled and saved.
3. Auto-generate fleet numbers based on specific logic to be derived from fields entered in purchase order form
4. Link data entry in Purchase order forms to central database.
5. Build Supplier/Item Master record tables that can be edited & updated when needed
6. Additional fields in database to manage/update order status e.g. emailed, received, etc.
7. Permit multiple users to use file