Access-D Seminar. Needs Assessment. Joe Hecht

1
Access-D Seminar

• Needs Assessment
• Joe Hecht
• Jmhla_at_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