Access-D Seminar

1. Access-D Seminar Needs Assessment Joe Hecht Jmhla@Earthlink.net

2. Needs Assessment • Originally for LACS • Office Application SIG • June 1999 • Intro Level

3. Needs Assessment • Sources • Databases for Mere Mortals – Mike Hernandez • VB Super Bible – David Jung et al • Access 97 Expert Solutions – Stan Lesynzki

4. Needs Assessment • The Project • Office Supply Store • “ Paper Clips” • One .MDB per store • No LAN or WAN

5. Needs Assessment • What we know: • Employees • Customers • Suppliers • Orders by PO • Accept Payments • Inventory

6. Needs Assessment • What we know (2) • Several Stores and Growing • Accounting • Mailing List, no clubs • No Quantity Discounts

7. Needs Assessment • What do we need to know? • Employees • Classifications – Manager, Supervisor, Sales • Payroll – Where to keep this data? • Accounting not part of discussion

8. Needs Assessment • Departments • What departments do they have? • Computers • Electronics • Office Supplies • Office Furniture • Photo Copies and Printing

9. Needs Assessment • Inventory • Track how it comes in • Track how it goes out

10. Needs Assessment • The Question of the Pen • Pens come from wholesaler in cases of 12 boxes • Pens are sold in boxes of 12 each or individually • How do you track pen sales?

11. Needs Assessment • Inventory • ·Each item has a unique catalogue number from the store. • ·The same item at each store has the same catalogue number • ·The same product but different brand has a unique number • ·Items can go out in different size lots from how they come in.

12. Needs Assessment

13. Needs Assessment

14. Needs Assessment

15. Needs Assessment

16. Needs Assessment