1 / 16

Access-D Seminar

This seminar, originally designed for the LACS Office Application SIG in June 1999, focuses on conducting an effective needs assessment for an office supply store's inventory management. Led by experts including Joe Hecht, Mike Hernandez, and David Jung, the discussion covers key topics such as employee classifications, sales tracking, and inventory control methods. Participants will learn about critical data sources, challenges of managing multiple store inventories, and unique product identification. This introductory seminar aims to equip attendees with tools to optimize their inventory processes.

kenton
Télécharger la présentation

Access-D Seminar

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related